answer questions with explanation

(2 points for each question)

(1)  Consider the following entity-relation diagram. Please select the correct statement. 

Provider

Visit

1:N

(a)  A single record in the Provider table is associated with multiple records in the Visit table

(b)  Multiple records in the Provider table are associated with a single record in the Visit table

(c)  A single record in the Provider table is associated with a single record in the Visit table

(d)  Multiple records in the Provider table are associated with multiple records in the Visit table 

(2)  Consider the following design of a table with the records populated. Please identify the problem with this design. 

(a)  Inconsistent data in certain records

(b)  Missing data in certain records

(c)  Redundant data in certain records

(d)  Wrong data in certain records

(3)  For the problem identified in Question (2), the technique in database design to eliminate it is called:

(a)  Abstraction  

(b)  Normalization

(c)  Randomization

(d)  Standardization

(4)  Consider the following table. Please select the incorrect statement.

(a)   is a field

(b)   is a key

(c)   is a record

(d)   is a view 

(5)  Consider the following design of a table with the records populated. Please identify the problem in the data fields of this table:

(a)  Calculated field

(b)  Multipart field

(c)  Multivalued field

(d)  Normalized field