answer questions with explanation

by

(2 points for each question)

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

Never use plagiarized sources. Get Your Original Essay on
answer questions with explanation
Hire Professionals Just from $11/Page
Order Now Click here

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   

Chat Now
Lets chat on via WhatsApp
Powered by Tutors Gallery
Hello, Welcome to our WhatsApp support. Reply to this message to start a chat.