Database Design Multiple Choice This question is based on the ER/EER model we le
ID: 3866663 • Letter: D
Question
Database Design Multiple Choice
This question is based on the ER/EER model we learned during the CLP class sessions and in the PowerPoint lecture-note files. Please refer to the following conceptual schema. How can we identify a particular entity in CHILD in the whole system, not just within the same associate who is the parent? (a) Through the attribute value of S-ID. (b) Through the attribute values of C-DOB and C-name combined. (c) Through the relationship IN. (d) Through the attribute values of A-ID and C-name combined. (e) None of (a) through (d) is a correct answer.Explanation / Answer
a) False
SiD is just the scholarship id; it cannot determine the child entity in the whole system.
b) False
C-DOB and C-name are not composite keys so it cannot uniquely identify a child value in the system.
c) False
In relationship IN is just an inheritance relation to should how two tables are related, it cannot determine the uniqueness of a child value.
d) False
A-ID and C-name cannot uniquely identify the child record, as S-ID will be missing from a record.
e) True
A-ID, C-name, S-ID in combination can uniquely identify a child record.
Hope your question has been resloved now. Please do not forget to give a positive like to the answer. Thank you.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.