• Author / Uploaded
• Alina Mirt

Citation preview

Section 2 Quiz (Answer all questions in this section) 1. Which of the following statements about Entities are true?

Mark for Review (1) Points

(Choose all correct answers) They never have Instances "Something" of significance to the business about which data must be known. (*) They are usually a noun. (*) A name for a set of similar "things" (*) Incorrect. Refer to Section 2 Lesson 2. 2. Entities are usually verbs. True or False?

Mark for Review (1) Points

True False (*) Correct 3. A/an _________'s value can be a number, a character string, a date, an image, a sound

Mark for Review (1) Points

ERD Table Attribute (*) Entity Correct 4. Unique Identifiers:

Mark for Review (1) Points

Distinguish one entity from another

Distinguish nothing Distinguish all entities in a database Distinguish one instance of an entity from all other instances of that entity (*) Correct 5. A/an _________ is a piece of information that in some way describes an entity. It is a property of the entity and it quantifies, qualifies, classifies, or specifies the entity.

Mark for Review (1) Points

Table Process Attribute (*) ERD Correct

6. The word "Volatil e" means:

Mark for Review (1) Points

Limited quantity Static; unlikely to change Large quantity Changing constantly; unstable (*) Correct 7. All of the following could be attributes of an ENTITY called PERSON, except which one?

Mark for Review (1) Points

Haircolor Weight Gender Natacha Hansen (*) Correct

8. A/an _________ is defined as "Something" of significance to the business about which data must be known.

Mark for Review (1) Points

Instance Relationship Entity (*) None of the above Incorrect. Refer to Section 2 Lesson 2. 9. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False?

Mark for Review (1) Points

True (*) False Incorrect. Refer to Section 2 Lesson 1. 10. Data models show users the data that their Physical Model will contain. True or False?

Mark for Review (1) Points

True (*) False Correct 11. Data modelin g is perform ed for the following reasons: (Choose Two)

Mark for Review (1) Points

(Choose all correct answers) It helps discussions and reviews. (*) We draw an ERD solely to please the users; once completed, the ERD is never referred to again as it serves no purpose in the real

world. We do not need datamodels; we can just start coding right away. The ERD becomes a blueprint for designing the actual system. (*) Correct 12. The Physical Model is derived from the Conceptual Model. True or False?

Mark for Review (1) Points

True (*) False Correct 13. Entity Relationship modeling is dependent on the hardware or software used for implementation, so you will need to change your ERD if you decide to change Hardware Vendor. True or False?

Mark for Review (1) Points

True False (*) Correct 14. The purpose of an ERD is to document the proposed system and facilitate discussion and understanding of the requirements captured by the developer. True or False?

Mark for Review (1) Points

True (*) False Correct 15. An Entity Relationship model is independent of the hardware or software used for implementation. True or False?

Mark for Review (1) Points

True (*) False Correct