DAT 380 Wk 3 - Practice: Knowledge Check

Click Here To Download Your Files :

http://www.onlinehelp123.com/dat-380

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You can buy more tutorials from the below link

http://www.onlinehelp123.com/dat-380

DAT 380 Wk 3 - Practice: Knowledge Check

Repeating groups must be eliminated by ensuring that each row defines a single entity.

       True

      False

The purpose of an entity _____ is to simplify an entity-relationship diagram (ERD) and thus enhance its readability.

•      interface
•      cluster
•      constraint
•      discriminator

Within a specialization hierarchy, every subtype can have _____ supertype(s) to which it is directly related.

•      one or many
•      zero
•      only one
•      many

A subtype contains attributes that are common to all of its supertypes.

•      True
•      False

In the context of total completeness, in a(n) _____, every supertype occurrence is a member of only one subtype.

       foreign key constraint

       nonunique constraint

      overlapping constraint

       disjoint constraint

A table that is in 2NF and contains no transitive dependencies is said to be in _____.

•      2NF
•      3NF
•      1NF
•      4NF

To model time-variant data, one must create a new entity in an M:N relationship with the original entity.

•      True
•      False

In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other.

       transitive dependency

       multivalued dependency

       functional dependency

      partial dependency

One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.

•      True
•      False

One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their supertype.

•      natural
•      foreign
•      primary
•      surrogate