1.What are the elements of an information system? List and explain

2.Explain how computers are tools for information systems, what is the role of a computer in an information system?

3.What is the difference between Data and Information? Explain

4.List andexplain the characteristics of valuable information

5.What are the main advantages of the Database approach over the file approach?

6.What is a character, a field, a record, a file? Give examples

7.Define Foreign Key, primary Key, and how they are used on a database.

8.Explain the concept of a Relational Database

9.What are Entities? What are attributes? Give examples.

10.What is an entity-relationship diagram? Sketch an example

11.What is an Entity Relationship Diagram? How is it used?

12.When we say a Database is Normalized, what are we referring to?

13.What is a query language? What is SQL?

14.What is a database management system (dbms)? What does it do? (List its main functions)

15.Understand queries and reports as outputs from a DBMS

16.What is a Data Dictionary?

17.Explain an information system, a database management system and a database.

18.What is a data warehouse? For what purpose would it be used?

19.Explain an ETL process and the purpose for which it is used

20.What is a data mart?

21.Explain Big Data with your own words, and what the main concerns are around that concept.

22.What activities make up i) the revenue cycle and ii) the expenditure cycle of an Accounting Information System (AIS)?

a.Identify the main transactions that would be part of the revenue cycle of an organization. Identify the main transactions that are part of the expenditure cycle of the organization

23.Explain what a Fully Automated Accounting information system is, and how there can be different levels of automation when implementing a General ledger system

24.Explain the nature of Managerial Work with regard to the two main activities managers perform: Planning and Controlling

25.What is Data Management and what is the purpose of it for Organizations?

26.Explain the main characteristics of decisions made by senior managers, middle managers, and operational managers.

27.Provide a description of the characteristics of information used at each the Operational, Tactical and Executive level.

28.How are information systems classified according to the level of the organization in which they are used? What do you call each category? Explain.

29.What is the difference between online processing and batch processing?

30.Explain with examples the main characteristics and functions of tactical (MIS) and strategic systems (ESS)

31.List four characteristics of operational information systems (transaction processing systemsTPS). By whom are operational systems usually used in an organization?

32.List four different types of reports that can be produced by MIS. Explain.

33.What is a KPI? At which managerial level are KPI normally used?

34.Explain the concept of a Dashboard Report. Why is it useful?

35.Where is most of the raw data used for tactical systems usually captured?

36.What is the purpose of the General Ledger system?

37.Explain clearly: chart of accounts, debit/credit, general ledger, balance sheet, income statement.

38. What is the difference between installing and initializing a purchased accounting software package?

39.What main steps are involved in initializing an accounting system?

40.What are the main functional areas of a large manufacturing organization?

41.What are some of the main characteristics of information in the HR Area?

42. What are the characteristics of Information systems used in the marketing area?

43. What is MRP? What are the inputs and the outputs from MRP?

44. How does MRP differ from MRPII and ERP? Explain

45. What are the main characteristics of information in the Manufacturing area?