Data Processing Practice Tests – Entity Relationship Model

The following are components of Entity-Relationship Diagrams EXCEPT _______

A. Entities      B. employee ID      C. Attributes      D. Relationships

If a SCHOOL is an entity in an Entity-Relationship Diagram, one of the attributes of SCHOOL will be ______

A. number of market in the community
B. number of men in the LGA
C. student’s identification number
D. employee identification number

The STUDENT ID in TABLE II is known as ________

A. primary key        B. foreign key        C. normal key      D. composite key

What type of relationship exist between TABLE I and TABLE II

A. one-to-many       B. many-to-many     C. many-to-one     D. one-to-one

What type of relationship exist between the Department Table and Course Table?

A. one-to-many        B. many-to-many      C. many-to-one      D. one-to-one