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?

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



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Jay

Jay

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?

anon1

anon1

I’m no expert, but i also think its “A”

Paul

Paul

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

TC

TC

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.

Karen

Karen

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)

Bogdan

Bogdan

Sure it is 1:n ! So A