Homework 5

Homework 5 - the mapping constraints. 2. Question 6.3 of...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CSC4402 Homework5 Due Monday November 2, 2009 Entity- Relationship modeling: 1. Question 6.2 of the text book: Auniversity registrar’soffice maintains data about the following entities: (a) courses, including num- ber ,title, credits, syllabus, and prerequisites; (b) course offerings, including course number ,year ,se- mester ,section number
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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

Ask a homework question - tutors are online