1- Two classes exist in separate views as follows Customer (CustID, Name, PhoneN
ID: 2406085 • Letter: 1
Question
1- Two classes exist in separate views as follows
Customer (CustID, Name, PhoneNum)
Customer (CustID, Name, EyeColor, Gender)
Which attributes should be assigned to the merged Customer class?
A.
CustID and Name
B. CustID, Name, and PhoneNum
C. CustID, Name, EyeColor, and Gender
D.CustID, Name, EyeColor, Gender, and PhoneNum
2- Two members of a database design team at Large U.S. University assigned different primary keys to the Student class in their models. One member used Student ID, an internally generated unique number the university assigns to each student upon enrollment. The other chose social security number or other equivalent identifier assigned to each student by the U.S. government. This is an example of:
Class name conflict
Attribute conflict
Multiplicity conflict
Association name conflict
A.
CustID and Name
B. CustID, Name, and PhoneNum
C. CustID, Name, EyeColor, and Gender
D.CustID, Name, EyeColor, Gender, and PhoneNum
Explanation / Answer
1. Option A,( Customer id and name should be assigned to merged class)
2. Option D , (association name conflict)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.