mtExamFA2005

mtExamFA2005 - CSE 412/598 Database Management Systems...

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

View Full Document Right Arrow Icon
Database Management Systems Mid-Term Exam Fall 2005 NAME_______________________________ ASU ID: ________________________ Problem 1 - (25 points) ER Design and Relational Modeling 1) (15 points) 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. A database is to contain information concerning sales representatives, sales areas, and products.  Each representative is responsible for sales in one or more areas; each area has one or more  responsible representatives. Similarly, each representative is responsible for sales of one or more  products, and each product has one or more responsible representatives. Every product is sold in  every   area;   however,   no   two   representatives   sell   the   same   product   in   the   same   area.   Every  representative   sells   the   same   set   of   products   in   every   area   for   which   that   representative   is  responsible. 1
Background image of page 1

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

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

Page1 / 5

mtExamFA2005 - CSE 412/598 Database Management Systems...

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