1.If you were designing a database to record the transaction that takes place be

Question

1.If you were designing a database to record the transaction that takes place between a customer and a "store", what would the likely relationship be between the customer and the store? a).M:1 :b)1:M; c) 1:1 ; d) 1:M

2.You have started normalizing an ERD, and notice that one of the relations has attributes that are only partially dependent on part of a composite primary key. This means that the table can only be in ____ normal form.
a)1st,b)2nd,c)3rd ,d)4th

3.Which relation cannot be implemented in the relational model, properly? a) M:1 ,b) 1:M ,c) 1:1, d) M:N

4).Ernie comes to you for help on an ER Model that he is creating. He is looking at the manufacturing process, and the relationship that exists between products and the bins that they are stored in. What would most likely be the relationship between the products and the bins? Products - Bins
a) M:1,b). 1:M,c). 1:1, d). M:N

Explanation / Answer

1.) d) 1:M, One customer can do many transactions

2.) b) 2nd normal form, This means that proper set of candidate key is not dependent on non prime attribute that is why it is in 2nd normal form

3.) d) M:N, Relation M:N is implemented using 1:M relationship in relational model

4.) 1:M, Relationship is there because Bin is a product.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.