CSIS3310 – quiz # 2

1) What are the four major components of an E-R Diagram ?

Solution: Entities, Relationships, Cardinalities, Attributes

2) Draw an E-R diagram for Physicians Prescribe Drugs to Patients ?

Solution: Ternary Relationship (Three Entities + 1 Relationship)

3) 3NF and BCNF are practically equivalent. However, when we have

(A, B) -> C and C -> B

We can say that the table satisfies 3NF requirements, but does not satisfy BCNF requirements.

Using Instructor, Course and Student, indicate which one should be A, which should be B and which could be C.

Solution: There are multiple correct solution. As long as you do not say something like Course -> Student (which means

a Course can have only one student, you solution may be fine).