Question 1

Queries in Access are utilized by users to enter data into tables and view existing records.

Accepted Answer

A) True 
 B)False

Question 2

In Access,users can edit database information in reports.

Accepted Answer

A) True 
 B)False

Question 3

In Microsoft Access,we use "Forms" for

Accepted Answer

A)  Data entry 
B)  Data storage 
C)  Date retrieve 
D)  Two of the above 
A)  Data entry 
B)  Data storage 
C)  Date retrieve 
D)  Two of the above

Question 4

Using the Cash Receipt Table in the previous question,show the SQL command which will return the result table below.

Accepted Answer

SELECT *
FROM [Cash

Question 5

Which of the following items can best be described as a "Resource" in the REA data model?

Accepted Answer

A)  Cashier 
B)  Sales 
C)  Cash 
D)  Two of the above are correct. 
A)  Cashier 
B)  Sales 
C)  Cash 
D)  Two of the above are correct.

Question 6

To convert a conceptual model with a maximum Multiplicities relationship of "many to many" into relationship database tables,one must

Accepted Answer

A)  Create a foreign key in one of the tables to link the two tables. 
B)  Create a relation with no attributes of its own. 
C)  Create a relationship table to handle the many-to-many relationship. 
D)  Many-to-many relationship cannot be represented in Access. 
A)  Create a foreign key in one of the tables to link the two tables. 
B)  Create a relation with no attributes of its own. 
C)  Create a relationship table to handle the many-to-many relationship. 
D)  Many-to-many relationship cannot be represented in Access.

Question 7

While hierarchical and network data models require relationships to be formed at the database creation,relational data models can be made up as needed.

Accepted Answer

A) True 
 B)False

Question 8

What are the three main advantages of relational databases?

Accepted Answer

@#IMG-DLM& Flexibility and Scalability: relational

Question 9

Which of the following statements about the requirements of table design is incorrect?

Accepted Answer

A)  Each attribute in a table must have a unique name. 
B)  Values of a specific attribute must be of the same type. 
C)  Each attribute (column) of a record (row) must be single-valued. 
D)  All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key. 
A)  Each attribute in a table must have a unique name. 
B)  Values of a specific attribute must be of the same type. 
C)  Each attribute (column) of a record (row) must be single-valued. 
D)  All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key.

Question 10

Explain the three main types of classes in data modeling.

Accepted Answer

@#IMG-DLM& Resources (R),events (E),and agents (A)

Question 11

Which of the following about cloud computing is incorrect?

Accepted Answer

A)  Cloud computing is Internet-based computing where shared resources, software, and information are provided to firms on demand. 
B)  Cloud Computing can easily host enterprise system applications. 
C)  One major issue on using cloud computing is about security. 
D)  Clients using cloud computing do not need to periodically backup data. 
A)  Cloud computing is Internet-based computing where shared resources, software, and information are provided to firms on demand. 
B)  Cloud Computing can easily host enterprise system applications. 
C)  One major issue on using cloud computing is about security. 
D)  Clients using cloud computing do not need to periodically backup data.

Question 12

A Query in a program language can be used to

Accepted Answer

A)  Update data 
B)  Report data 
C)  Retrieve data 
D)  All of the above 
A)  Update data 
B)  Report data 
C)  Retrieve data 
D)  All of the above

Question 13

Search for another case on-line in which the company failed to implement the ERP systems.Summarize the case and give the reasons that caused the failure.

Accepted Answer

Following is an example.Students' answer

Question 14

Which of the following items can best be described as an "Event" in the REA data model?

Accepted Answer

A)  Cash. 
B)  Cashier. 
C)  Cash collection. 
D)  None of the above is correct. 
A)  Cash. 
B)  Cashier. 
C)  Cash collection. 
D)  None of the above is correct.

Question 15

Each attribute in a table can have several names.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following items can best be described as an "Agent" in the REA data model?

Accepted Answer

A)  Purchases. 
B)  Accounts payable clerk. 
C)  Raw material inventory. 
D)  None of the above is correct. 
A)  Purchases. 
B)  Accounts payable clerk. 
C)  Raw material inventory. 
D)  None of the above is correct.

Question 17

What kind of data models is most commonly used in today's business environment?

Accepted Answer

A)  Hierarchical data model 
B)  Network data model 
C)  Relational data model 
D)  All of the above 
A)  Hierarchical data model 
B)  Network data model 
C)  Relational data model 
D)  All of the above

Question 18

Cloud computing is an internet-based computing where shared resources,software,and information is provided to firms on demand.

Accepted Answer

A) True 
 B)False

Question 19

Access is a simple database management system that can be used to run databases for individuals and small firms.

Accepted Answer

A) True 
 B)False

Question 20

In a database,while queries allow the user to access,read and report on desired data,the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS).

Accepted Answer

A) True 
 B)False

Queries in Access are utilized by users to enter data into tables and view existing records.

In Access,users can edit database information in reports.

In Microsoft Access,we use "Forms" for

Using the Cash Receipt Table in the previous question,show the SQL command which will return the result table below.

Which of the following items can best be described as a "Resource" in the REA data model?

To convert a conceptual model with a maximum Multiplicities relationship of "many to many" into relationship database tables,one must

While hierarchical and network data models require relationships to be formed at the database creation,relational data models can be made up as needed.

What are the three main advantages of relational databases?

Which of the following statements about the requirements of table design is incorrect?

Explain the three main types of classes in data modeling.

Which of the following about cloud computing is incorrect?

A Query in a program language can be used to

Search for another case on-line in which the company failed to implement the ERP systems.Summarize the case and give the reasons that caused the failure.

Which of the following items can best be described as an "Event" in the REA data model?

Each attribute in a table can have several names.

Which of the following items can best be described as an "Agent" in the REA data model?

What kind of data models is most commonly used in today's business environment?

Cloud computing is an internet-based computing where shared resources,software,and information is provided to firms on demand.

Access is a simple database management system that can be used to run databases for individuals and small firms.

In a database,while queries allow the user to access,read and report on desired data,the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS).

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language XBRL

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing AIS

The Balanced Scorecard and Business Value of Information Technology

Evaluating AIS Investments

The Systems Development Life Cycle and Project Management: Addressing the Challenges of Building Ais Systems

Filters

Exam 4: Relational Databases and Enterprise Systems

Queries in Access are utilized by users to enter data into tables and view existing records.

In Access,users can edit database information in reports.

In Microsoft Access,we use "Forms" for

Using the Cash Receipt Table in the previous question,show the SQL command which will return the result table below.

Which of the following items can best be described as a "Resource" in the REA data model?

To convert a conceptual model with a maximum Multiplicities relationship of "many to many" into relationship database tables,one must

While hierarchical and network data models require relationships to be formed at the database creation,relational data models can be made up as needed.

What are the three main advantages of relational databases?

Which of the following statements about the requirements of table design is incorrect?

Explain the three main types of classes in data modeling.

Which of the following about cloud computing is incorrect?

A Query in a program language can be used to

Search for another case on-line in which the company failed to implement the ERP systems.Summarize the case and give the reasons that caused the failure.

Which of the following items can best be described as an "Event" in the REA data model?

Each attribute in a table can have several names.

Which of the following items can best be described as an "Agent" in the REA data model?

What kind of data models is most commonly used in today's business environment?

Cloud computing is an internet-based computing where shared resources,software,and information is provided to firms on demand.

Access is a simple database management system that can be used to run databases for individuals and small firms.

In a database,while queries allow the user to access,read and report on desired data,the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS).

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language XBRL

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing AIS

The Balanced Scorecard and Business Value of Information Technology

Evaluating AIS Investments

The Systems Development Life Cycle and Project Management: Addressing the Challenges of Building Ais Systems

Filters