Deck 4: Relational Databases and Enterprise Systems

Question 1

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

Answer 1

False

Question 2

Classes could be grouped into Resources (R),Entity (E),and Assets (A)in data modeling.

Answer 2

False

Question 3

SQL is based on relational algebra and allows a user to query and update the database.

Answer 3

True

Question 4

Three types of data models used today are: the hierarchical model,the network model and the relational model.

Question 5

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

Question 6

The "Where" SQL clause can be used to link two tables.

Question 7

In Access,users can edit database information in reports.

Question 8

Which of the following correctly describes the Referential Integrity Rule?

A) The primary key of a table must have data values (cannot be null)
B) Each attribute in a table must have a unique name
C) The data value for a foreign key could be null
D) Values of a specific attribute must be of the same type

Question 9

In a hierarchical data model,data elements are related in many-to-many relationships.

Question 10

Which type of data models allows each record to have multiple parent and child records?

A) The hierarchical mode
B) The network model
C) The relational model
D) None of the above

Question 11

Which of the following tasks cannot be performed through queries in access?

A) Retrieve and display data
B) Calculations of data
C) Data sorting
D) Enter data into tables

Question 12

In Microsoft Access,we use tables in a database for:

A) Data entry
B) Data storage
C) Data retrieval
D) Two of the above are correct.

Question 13

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

Question 14

Each attribute in a table can have several names.

Question 15

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations.Which of the following systems is most effective for this application?

A) A decision support system.
B) An executive support system.
C) An office automation system.
D) An enterprise resource planning system.

Question 16

Access offers modules,which are defined by users to automate processes like opening a specific form.

Question 17

The SQL command "Group by" can be used to order an amount in a descending order.

Question 18

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

Question 19

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

Question 20

The asterisk (*)following the SELECT SQL statement is a wild card indicating all columns should be selected.

Question 21

An enterprise resource planning system has which of the following advantages over multiple independent functional systems?

A) Modifications can be made to each module without affecting other modules.
B) Increased responsiveness and flexibility while aiding in the decision-making process.
C) Increased amount of data redundancy since more than one module contains the same information.
D) Reduction in costs for implementation and training.

Question 22

Which of the following resources is usually not modeled as an entity (table)in an REA data model?

A) Cash
B) Inventory
C) Accounts receivable
D) Property, plant and equipment

Question 23

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

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

Question 24

In Microsoft Access,we use "Forms" for

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

Question 25

What is the main purpose of using foreign keys in a relational database design?

A) It provides useful financial data value in the table.
B) It is required in all tables.
C) It is used to link tables.
D) None of the above is correct.

Question 26

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

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 27

The property of the primary key in a table in Microsoft Access should be set to:

A) The required field = "Yes", the Indexed field = "Yes (No Duplicates)"
B) The Required field = "NO" and the Indexed field = "Yes (No Duplicates)"
C) The Required field = "Yes" and the Indexed field = "Yes (Duplicated)"
D) The Required field = "NO" and the Indexed field = "No (Duplicates)"

Question 28

What kind data model is most commonly used as a basis for today's enterprise systems?

A) The hierarchical mode
B) The network model
C) The relational model
D) None of the above

Question 29

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

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

Question 30

Which of the following about SQL is incorrect?

A) SQL is a language designed to query data in a relational database.
B) SQL is based on relational algebra and allows a user to query and update the database.
C) SQL is very user-friendly.
D) SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query.

Question 31

Which SAP modules would a manufacturing company use to create a delivery order for a sales transaction?

A) Materials Management
B) Sales and Distribution
C) Production Planning and Control
D) Logistics Execution

Question 32

In Microsoft Access,we use "Tables" for:

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

Question 33

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

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

Question 34

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

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

Question 35

Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales?

A) Cash Collection (1..1) - Sale (1..N)
B) Cash Collection (1..N) - Sale (1..1)
C) Cash Collection (1..N) - Sale (1..1)
D) Cash Collection (1..1) - Sale (1..1)

Question 36

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

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 37

Which of the following is not a type of data model?

A) Hierarchical data model
B) Network data model
C) Normalization data model
D) Relational data model

Question 38

Which of the following about cloud computing is incorrect?

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 39

Which of the following is considered as class in the relational database model?

A) Customer
B) Sale
C) Cash
D) All of the above are correct

Question 40

A Query in a program language can be used to

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

Question 41

List the seven objects and their functions that are used to implement relational databases using Microsoft Access.

Question 42

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

Question 43

Discuss the challenges of enterprise system implementation?

Question 44

Explain the three main types of classes in data modeling.

Question 45

What are the three main advantages of relational databases?

Question 46

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.

Question 47

Using the Cash Receipt Table below,show the output if the following SQL command is given:
Cash Receipt:
SELECT SUM (Amount)
FROM [cash receipt]
Where [Customer Number] ='C-2'

Question 48

What are the benefits of implementing the enterprise systems in companies?