01.tut3-ans-1

01.tut3-ans-1 - SEMESTER 1 2010/2011 WXES2103 DATABASE...

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

View Full Document Right Arrow Icon
SEMESTER 1, 2010/2011 WXES2103 DATABASE TUTORIAL 3: ER Diagram SCHEMA 1. Create an ERD model, using the following requirements. An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. An INVOICE may include many detail lines (LINE) which describe the products bought by the customer. The product information is stored in a PRODUCT entity. The product's vendor information is found in a VENDOR entity. 2. Given the following summary of business rules for the ROBCOR catering service, draw the ERD. Make sure to include all appropriate entities, relationships, connectivities, and cardinalities. (1,N) (1,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
Note: Limit your ERD to entities and relationships based on the business rules shown here. In other words, do NOT add "realism" to your design by expanding or refining the business rules! However, make sure that you include the attributes
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.

This note was uploaded on 10/23/2011 for the course DATABASE 211 taught by Professor Wilson during the Spring '11 term at IIPM.

Page1 / 4

01.tut3-ans-1 - SEMESTER 1 2010/2011 WXES2103 DATABASE...

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