Question 1

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 2

In Microsoft Access,we use "Forms" for

Accepted Answer

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

Question 3

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 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

Each attribute in a table can have several names.

Accepted Answer

A) True 
 B)False

Question 7

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.

Question 8

Explain the three main types of classes in data modeling.

Accepted Answer

<img  loading="lazy" src="/assets/images/blured-textbook.svg" class="d-inline m-1" alt="blured image" width="139" height="30"> Resources (R),events (E),and agents (A)...

Question 9

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.

Question 10

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.

Question 11

What are the three main advantages of relational databases?

Accepted Answer

<img  loading="lazy" src="/assets/images/blured-textbook.svg" class="d-inline m-1" alt="blured image" width="139" height="30"> Flexibility and Scalability: relational...

Question 12

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

Question 13

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.

Question 14

In Access,users can edit database information in reports.

Accepted Answer

A) True 
 B)False

Question 15

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.

Question 16

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

Question 17

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.

Question 18

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 19

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 20

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

Exam 4: Relational Databases and Enterprise Systems

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following about cloud computing is incorrect?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In Microsoft Access,we use "Forms" for

Correct AnswerverifiedShow Answer

Explain the three main types of classes in data modeling.

Correct Answerverified Resources (R),events (E),and agents (A)...View AnswerShow Answer

A Query in a program language can be used to

Correct AnswerverifiedShow Answer

In Access,users can edit database information in reports.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are the three main advantages of relational databases?

Correct Answerverified Flexibility and Scalability: relational...View AnswerShow Answer

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).

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Each attribute in a table can have several names.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedSELECT *FROM [Cash ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedFollowing is an example.Students' answer...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Resources (R),events (E),and agents (A)...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Flexibility and Scalability: relational...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
SELECT *
FROM [Cash ...
View Answer

Correct Answer
verified

Correct Answer
verified
Following is an example.Students' answer...
View Answer