Database Design Final Exam

Database Design Final Exam

Examine the following entity and decide which attribute breaks the 2nd Normal Form rule:

ENTITY: RECEIPT

ATTRIBUTES:

   #CUSTOMER ID

   #STORE ID

   STORE LOCATION

   DATE

   

Database Design Midterm Exam

Database Design Midterm Exam

Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?  

                                               

                True (*)

Answer Section 9 Quiz Database Design 2019 Learner - English

Section 9

A barrred Relationship will result in a Foreign Key column that also is part of: 

                                               

                The Primary Key (*)

                                               

                The Check Constraint

Answer Section 4 Quiz Database Design 2019 Learner - English

Section 4

A Supertype can have only one subtype. True or False? 

                                                                               

                                               

                True

Answer Section 8 Quiz Database Design 2019 Learner - English

Section 8

When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False? 

                                                                               

                                               

                True

                                               

                False (*)

  

Answer Section 7 Quiz Database Design 2019 Learner - English

Section 7

Arcs model an Exclusive OR constraint. True or False?  

                                               

                True (*)

                                               

                False

Answer Section 6 Quiz Database Design 2019 Learner - English

Section 6

Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:
ENTITY: RECEIPT
ATTRIBUTES:
   #CUSTOMER ID
   #STORE ID
   STORE LOCATION
   DATE 

Answer Section 5 Quiz Database Design 2019 Learner - English

Section 5

When you resolve a M:M by creating an intersection entity, this new entity will always inherit:

                                                                               

                                               

                The UID's from the entities in the original M:M.

                                               

                The attributes of both related entities.

       

Answer Section 3 Quiz Database Design 2019 Learner - English

Section 3

Which of the following are true about Relationship Optionality? (Choose two) 

                                                                               

                                               

                Optionality answers "may or must". (*)

Answer Section 2 Quiz Database Design 2019 Learner - English

Section 2

All of the following could be attributes of an ENTITY called PERSON, except which one?                            

                Haircolor

                                               

                Weight

Answer Section 1 Quiz Database Design 2019 Learner - English

Section 1

The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False?  

                                               

                True (*)

                                               

                False