SP2009_310_sample_midterm

SP2009_310_sample_midterm - DEVICE WITH AN ON/OFF SWITCH...

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

View Full Document Right Arrow Icon
Y DEVICE WITH AN ON/OFF SWITCH MUST BE TURNED OFF FOR THE DURATION OF THE TEST. U MAY NOT LEAVE THE CLASSROOM UNTIL YOU HAVE HANDED IN YOUR TEST. GEORGE MASON UNIVERSITY SCHOOL OF MANAGEMENT MIS 310 INTRODUCTION TO DATABASE MANAGEMENT Sample Mid Term SP2009 (CLOSED BOOK) _Name:__________________________________________________________________ Q1 [15 points] Convert the ER diagram shown above to relations. Draw the relations in tabular form. For each relation, clearly show the primary and foreign keys. Do not skip any attributes shown in the ERD . In other words, all attributes that show up in the ERD must show up somewhere in your relations. Page 1 of 7
Background image of page 1

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

View Full DocumentRight Arrow Icon
[25 points] For each of the following narratives, determine the entities and relationships implied in the narrative, and then draw the corresponding ERD. Make sure you show at least a couple of attributes for each entity and underline the identifying attribute. Also, do not forget to show the cardinalities of each relationship. In all cases, you will have to think up appropriate attributes on your own.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

SP2009_310_sample_midterm - DEVICE WITH AN ON/OFF SWITCH...

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