cs411-s09-mt-sol

cs411-s09-mt-sol - NetID: CS411 Database Systems Spring...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: NetID: CS411 Database Systems Spring 2009, Midterm Exam Solutions Problem 1 ( 11 points ) Misc. Concepts (1) False (2) True (3) False (4) False (5) True (6) False (7) False (8) False (9) False (10) False (11) False Problem 2 ( 16 points ) ER Model and Relational Model (a) There can be multiple solutions for this problem, depending on students assumptions. If the assumptions are reasonable and the ER diagram is drawn correctly based on the assumptions, we will give full credit. E-R diagram: Assumptions: 1 NetID: The name of each series is unique, so name is a key for Series. The name of actors/actresses is unique, so name is a key for Cast. userID is unique, so userID is a key for Users. Many actors/actresses can star in one series. One actor/actress can star in multiple different series. Hence, Act is many-many. Many users can comment on one episode. One user can comment on different episodes. Hence, Comment is many-many....
View Full Document

Page1 / 3

cs411-s09-mt-sol - NetID: CS411 Database Systems Spring...

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

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