midterm_solutions

midterm_solutions - CSE 412/598 Database Management Midterm...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CSE 412/598 – Database Management – Midterm Exam March 12, 1:45 - 2:55pm (1hr 10mins) Name: ASU ID: Circle One: 412 598 Instructions: Write your Name and ASU ID. The exam is open notes, open books and closed mouth. Duration : 70 mins Pages : 5 pages Use only space provided on each page to solve the problems. We will not read solutions that spill over to the next page. Do not use this booklet as draft – use scrap paper. Write neatly. If we cannot decipher your handwriting, we will not grade it. Total Points : 110, (with 10 points bonus). Good Luck! Problem 1 - (25 points) ER Design Perform the ER design for the following simple enterprise. List all entities and relationships with all their attributes/roles and constraints. Especially indicate key constraints and participation constraints. No need to convert the ER design into the relational model. The Enterprise: A small part of a university enrolment system. There are students who take courses, and there are professors who teach them. Your design should allow for the fact that not
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 5

midterm_solutions - CSE 412/598 Database Management Midterm...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online