answer questions with explanation

(2 points for each question)

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

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

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

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

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