DeVrY BIS 245 / BIS 245 Week 3 Quiz

Question
Question 1. Question (TCO 2) In a relational database entities are
events.
persons.
things.
All of the above
Instructor Explanation: Chapter 3: Frost section of book
Points Received: 4 of 4
Comments:
Question 2. Question : (TCO 2) Logical design refers to
developing a database model that will support company operations.
developing a thorough understanding of what needs to be done in developing a database.
translating the conceptual design into the selected model for use in a database system.
understanding the business and its functional areas or business processes.
Instructor Explanation: Week 3 Lecture
Points Received: 4 of 4
Comments:
Question 3. Question : (TCO 3) Database design refers to
developing a database model that will support company operations.
focusing on understanding the business and its functional areas or business processes.
selecting the specific hardware characteristics based on data storage and data access requirements.
the process of converting your ERD into tables and defining your rows and columns based your entities and attributes.
Instructor Explanation: Week 3 Lecture
Points Received: 4 of 4
Comments:
Question 4. Question : (TCO 2) A crow’s foot
$ is a Boolean field.
is used to describe attributes.
points to the child table.
points to the parent table.
Instructor Explanation: Chapter 3: Frost section of book
Points Received: 0 of 4
Comments:
Question 5. Question : (TCO 2) A one-to-many relationship is
a relationship that guarantees that a record is unique.
an association between a record and its fields.
used to describe attributes.
when a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.
Instructor Explanation: Chapter 3: Frost section of book
Points Received: 4 of 4
Comments:
Question 6. Question : (TCO 2) An associative table is
used to identify primary keys between tables.
a child of two parent tables that are in a many-to-many relationship.
an integrity element within a table relationship.
a tool that allows you to locate an excel file.
Instructor Explanation: Chapter 2: Grauer section of book
Points Received: 4 of 4
Comments:
Question 7. Question : (TCO 3) Data validation refers to
a set of constraints that helps control illegal data entry.
correcting data errors after they are entered into a table.
duplicating a primary key in a table.
typing data accurately into a table.
Instructor Explanation: Chapter 2: Grauer section of book
Points Received: 4 of 4
Comments:
Question 8. Question : (TCO 4) What Access data type would you use to store $23.58?
Calculated
Currency
Money
Number
Instructor Explanation: Chapter 1: Grauer section of book
Points Received: 4 of 4
Comments:
Question 9. Question : (TCO 4) Which is NOT true of validation rules?
They enforce a size limit.
They check authenticity of data entered in a field.
An error message will appear if a rule is violated.
They protect from fraudulent practices.
Instructor Explanation: Chapter 2: Grauer section of book
Points Received: 4 of 4
Comments:
Question 10. Question : (TCO 4) Which question is part of a requirements analysis?
What is the organization’s structure and core business?
What are the existing problems with the current database?
Will the database interface with other systems?
All of the above.
Instructor Explanation: Week 3 Lecture
Points Received: 4 of 4
Comments: