Accy 310 Chapter 4 Study Questions
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
A Query in a program language can be used to
A. Update data B. Report data C. Retrieve data D. All of the above
Which of the following items can best be described as an "Agent" in the REA data model?
Accounts payable clerk.
Which of the following resources is usually not modeled as an entity (table) in an REA data model?
Accounts receivable
Which of the following statements about the requirements of table design is incorrect?
All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key.
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?
An enterprise resource planning system.
Which of the following items can best be described as a "Resource" in the REA data model?
Cash
Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales?
Cash Collection (1..1) - Sale (1..1)
Which of the following items can best be described as an "Event" in the REA data model?
Cash collection.
Which of the following about cloud computing is incorrect?
Clients using cloud computing do not need to periodically backup data.
To convert a conceptual model with a maximum Multiplicities relationship of "many to many" into relationship database tables, one must
Create a relationship table to handle the many-to-many relationship.
In Microsoft Access, we use "Forms" for
Data entry
In Microsoft Access, we use "Tables" for:
Data storage
In Microsoft Access, we use tables in a database for:
Data storage
Which of the following tasks cannot be performed through queries in access?
Enter data into tables
Access offers modules, which are defined by users to automate processes like opening a specific form.
FALSE
Classes could be grouped into Resources (R), Entity (E), and Assets (A) in data modeling.
FALSE
Each attribute in a table can have several names.
FALSE
In Access, users can edit database information in reports
FALSE
In a hierarchical data model, data elements are related in many-to-many relationships
FALSE
Queries in Access are utilized by users to enter data into tables and view existing records
FALSE
The SQL command "Group by" can be used to order an amount in a descending order
FALSE
An enterprise resource planning system has which of the following advantages over multiple independent functional systems?
Increased responsiveness and flexibility while aiding in the decision-making process.
What is the main purpose of using foreign keys in a relational database design?
It is used to link tables.
Which of the following is not a type of data model?
Normalization data model
What kind of data models is most commonly used in today's business environment?
Relational data model
Which of the following about SQL is incorrect?
SQL is very user-friendly.
Which SAP modules would a manufacturing company use to create a delivery order for a sales transaction?
Sales and Distribution
Access is a simple database management system that can be used to run databases for individuals and small firms.
TRUE
Cloud computing is an internet-based computing where shared resources, software, and information is provided to firms on demand.
TRUE
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).
TRUE
SQL is based on relational algebra and allows a user to query and update the database.
TRUE
The "Where" SQL clause can be used to link two tables
TRUE
The asterisk (*) following the SELECT SQL statement is a wild card indicating all columns should be selected
TRUE
Three types of data models used today are: the hierarchical model, the network model and the relational model.
TRUE
While hierarchical and network data models require relationships to be formed at the database creation, relational data models can be made up as needed
TRUE
Which of the following correctly describes the Referential Integrity Rule?
The data value for a foreign key could be null
Which type of data models allows each record to have multiple parent and child records?
The network model
What kind data model is most commonly used as a basis for today's enterprise systems?
The relational model
The property of the primary key in a table in Microsoft Access should be set to:
The required field = "Yes", the Indexed field = "Yes (No Duplicates)"