3 - ERD exercise

Successful database design is, first and foremost, based on ____ requirements.

• designer

• programmer

• end-user

• system

A ____ attribute is one that cannot be subdivided.

• composite

• multivalued

• single-valued / simple

Which attribute(s) make up the primary key in the table definition:

CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)

• CRS_CODE

• CLASS_SECTION

• CRS_CODE and CLASS_SECTION

• There is no primary key

A relationship is an association between ____.

• classes

• entities

• databases

• fields

Cardinality expresses ____ number of entity occurrences associated with one occurrence of the related entity.

• an undetermined

• the specific

• a pre-determined

• a programmed

Knowing the ____ number of entity occurrences is very helpful at the application software level.

• maximum

• minimum

• exact

• maximum and minimum

Which is is not a possible type of relationship?

• one-to-one

• many-to-one

• one-to-many

• many-to-many

• All the above are possible