Midterm Exam: Introduction to Database Systems: Solutions

cs186 Midterm Solutions , Spring 2010 Page 1 UNIVERSITY OF CALIFORNIA College of Engineering Department of EECS, Computer Science Division cs186 J. Hellerstein Spring 2010 Midterm #1 Midterm Exam: Introduction to Database Systems: Solutions 1. Entity-Relationship Model [16 points] Below is the preferred solution: The following variants were also accepted: a. [12 points] Complete the diagram above to be a valid E-R diagram reflecting the following constraints. (Be sure to make your bold lines very bold!) A student, uniquely identified by her SID, takes an exam (for example, Midterm #1) on exactly one date. A student may take any number of exams (for example, Midterm #1, Midterm #2, and a final exam), and every exam is taken by at least one student. An exam is uniquely identified by the combination of a course and a semester. cs186 Midterm Solutions , Spring 2010 Page 2 Every exam has at least one overseer (for example, Prof. Hellerstein, Derrick, and Bill).

CS186 Midterm Solutions, Spring 2010 Page 3 • [2 points] The figure with ovals and circles below illustrates a relationship set between two entity sets. Each circle is an entity or relationship, and the edges connect them. The ER diagram right below that

Loading..

Tags:

  Database, Cs186

Information

Related search queries