Transcription of Midterm Exam: Introduction to Database Systems: Solutions
{{id}} {{{paragraph}}}
Example: quiz answers
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.)
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.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Introduction to Object-Oriented Databases, Database, Introduction to Object-Oriented Databases and Database Systems, INTRODUCTION, Database Systems, SYSTEMS SOLUTIONS, Introduction to Database Systems, Chapter 1: Introduction, Systems, AN INTRODUCTION TO RELATIONAL DATABASES, Introduction to Database Design, Lecture Notes in Computer Science