DATA MODELS INTO DATABASE DESIGNS QUIZ

Which of the following situation requires the use of ID-dependent entities?

Archetype/instance relationships only

Association relationships only

All of these

Multivalued attributes only

TRUE ANSWER : ?
YOUR ANSWER : ?

When the parent entity is required, a new parent row can always be inserted.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The DBMS allows surrogate keys to be changed.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In a 1:1 relationship, the primary key placement is arbitrary.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

For every relationship, there are six possible sets of minimum cardinalities.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In 1:N relationships, which entity becomes the parent entity is arbitrary.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

For every relationship, how many possible sets of minimum cardinalities are there?

Six

Four

Three

Two

TRUE ANSWER : ?
YOUR ANSWER : ?

The identifier of an entity will become the ________ of the new table.

primary key

identity key

main attribute

foreign key

TRUE ANSWER : ?
YOUR ANSWER : ?

Intersection tables are ID-dependent on both their parent tables.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A foreign key is:

a column containing the primary key of another table.

used to define null status.

All of these

used to define data types.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑