Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT.
What is the relationship between BUILDING and RESIDENT?
A.
1:N
B.
N:1
C.
M:N
D.
1:1
What is the relationship between BUILDING and RESIDENT?
Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT.
What is the relationship between BUILDING and RESIDENT?
I would think the answer would be A because you have 1 building and Many residents. Therefore, 1:N. If the answer said between Resident and Building, I would say B.
How far off am I?
I’m no expert, but i also think its “A”
I agree, the answer is A and as evidence, I submit the following:
From the CIW Database Design Specialist, Student Guide (Lesson 4, page 11)
“When you’re using an IE diagram, the cardinality of the relationships is indicated in the ending of the lines that connect the entities. The characters used at the end of the lines are as follows:”
|| = One and only one
0| = Zero or one
>| = One or more
>0 = Zero, one, or more
Even if the tables where flipped it would be 1:n. It is never n:1 that I have seen. Remember these are good at testing your knowledge but on occasion they provide the wrong answer.
Wrote my CIW Database Design Specialist 1D0-541 exam few days ago and passed with 92%! About 5 new questions, but not difficult at all. Total 50 questions, many questions on Normalization and Database Design/Structured Query Language (SQL), and DBMS/DDL/DML/DCL are still the most important objectives of the exam. BTW, the passing score now is 75%, and I learned all questions from passleader 1D0-541 dumps (http://www.passleader.com/1d0-541.html)
Sure it is 1:n ! So A