A PERSON entity has:
• Person_ID – primary key
• Name
• Email
• Phone – multivalued
A person may have several phone numbers.
Which mapping best preserves the ER semantics?

Question

A PERSON entity has: 
 •    Person_ID – primary key  
 •    Name  
 •    Email  
 •    Phone – multivalued  
 A person may have several phone numbers. 
 Which mapping best preserves the ER semantics?

Answer

PERSON_PHONE(Phone, Name, Email)

Answer

PERSON(Person_ID, Name, Email) and PERSON_PHONE(Person_ID, Phone)

Answer

PERSON(Person_ID, Name, Email, Phone)

Answer

PERSON(Person_ID, YourName, Email) and PERSON_PHONE(Person_ID, Phone)

Crowdly

A PERSON entity has: • Person_ID – primary key • Name • Email ...

Want instant access to all verified answers on moovit.vit.ac.in?