This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: ANY DEVICE WITH AN ON/OFF SWITCH MUST BE TURNED OFF FOR THE DURATION OF TH YOU 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 _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 8 Q2. [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. (a) an employee may hold zero or more academic degrees, and an academic degree can be held by zero or more employees (b) An employee manages zero or one stores and a store is managed by exactly one employee Page 2 of 8 (c) one movie star...
View Full Document
This note was uploaded on 02/21/2011 for the course MIS 310 taught by Professor Staff during the Spring '08 term at George Mason.
- Spring '08