CIST 1220 QUIZ 7

The explanation below is an example of which constraint type? A primary key must be unique, and no part of the primary key can be null.

A) Entity integrity

What do you create when you transform a Many-to-Many relationship from your ER diagram into a physical design?

A) Intersection table

A table does not have to have a primary key. True or False?

A) True

Attributes become columns in a database table. True or False?

A) True

When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?

A) True

A foreign key always refers to a primary key in the same table. True or False?

B) False

Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?

B) False

The explanation below is an example of which constraint type? The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table.

B) Referential integrity

In a physical data model, an entity becomes a/an _____________.

B) Table

In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?

B) You cannot have spaces between words in a table name