Quiz 3 Database Foundation Sesi 1 PDF [PDF]

Citation preview

Section 3 Quiz (Answer all questions in this section) 1. The transformation from an ER diagram to a physical design involves changing terminology. Primary Unique Identifiers in the ER diagram become __________ and relationships become ____________.



Mark for Review (1) Points



Primary keys, Foreign keys (*) Foreign keys, Primary keys Unique Keys, Primary keys Foreign keys, mandatory business rules Correct 2. _____________ are converted to rows in the physical design.



Mark for Review (1) Points



entities columns instances (*) attributes Correct 3. Table names can contain all of the following except:



Mark for Review (1) Points



Numbers Some special characters Letters Spaces (*) Correct 4. When is an entity in 2nd Normal Form?



Mark for Review (1) Points



When all non-UID attributes are dependent upon the entire UID. (*) When attributes with repeating or multi-values are removed. When no attritibutes are mutually independent and all are fully dependent on the primary key. None of the Above. Correct 5. Would it be a good idea to model age as an attribute of STUDENT?



Yes



Mark for Review (1) Points



Yes, it would prevent our having to calculate someone's age every time we need it. Sometimes, but not all of the time No - it is a volatile attribute (*) Correct Section 3 Quiz (Answer all questions in this section) 6. Which of the following is not true regarding normalization:



Mark for Review (1) Points



It helps with the performance of the database. It is the process of organizing the attributes and tables of a relational database to minimize redundancy. It does not impact the performance of the database. (*) It assists in handling insert, update and delete anomalies. Correct 7. A table is in 2NF if the table is in 1NF and what other condition is met?



Mark for Review (1) Points



There are no attributes that are not functionally dependent on the relation's entire primary key. (*) There are no repeating groups. There are no null values in primary key fields. There are no functional dependencies. Correct 8. Sources of business rules include all of the following except:



Mark for Review (1) Points



Standards Operational manuals Word of mouth (*) Procedures Correct 9. An arc can also be modeled as Supertype and Subtypes. True or False?



Mark for Review (1) Points



True (*) False Correct 10. Intersection Entities are at the ______ end of the newly created 1:M (Parent:Child) relationship;



Mark for Review



(1) Points Parent Single Barred Child (*) Incorrect. Refer to Section 3 Lesson 1. Section 3 Quiz (Answer all questions in this section) 11. A non-transferable relationship means the detail _____ be changed to point to a new master.



Mark for Review (1) Points



sometimes can can can not (*) Correct 12. You can only create relationships to a Supertype, not to a Subtype. True or False?



Mark for Review (1) Points



True False (*) Correct 13. Another name for a "barred relationship" is ________________.



Mark for Review (1) Points



Hierarchical Relationship Identifying Relationship (*) Supertype Relationship Recursive Relationship Incorrect. Refer to Section 3 Lesson 1. 14. Modeling historical data can produce a unique identifier that includes dates. True or False?



Mark for Review (1) Points



True (*) False Correct 15. Modeling historical data is optional. True or False?



True (*)



Mark for Review (1) Points



False Correct