Unformatted text preview: the mapping constraints. 2. Question 6.3 of the text book: Consider a database used to record the marks that students get in different exams of different course offerings. a. Construct an E-R diagram that models exams as entities, and uses a ternary relationship, for the database. b. Construct an alternative E-R diagram that uses only a binary relationship between students and course_offerings . Make sure that only one relationship exists between a particular student and course_offering pair, yet you can represent the marks that a student gets in different exams of a course offering....
View Full Document
- Fall '08
- Databases, Entity-relationship model