Homework_6_solution

Homework_6_solution - Name: _ Homework 6 ISE 382...

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

View Full Document Right Arrow Icon
Name: _______ Homework 6 ISE 382 Introduction to Computer Systems 15 points Due Date – Friday March 31 st Answer Marcia’s Dry Cleaning - Parts A and B on page 170. Answer your questions in MS Word. Draw an E-R diagram using Visio. Insert your model in your Word document as an image. Hint: Use the data model for a standard Sales Order as shown in Figure 5.35. You will need to modify it to add the discount. Except for the addition of the Discount Award program, this is a basic Sales Order model as shown in Figure 5-35. The Item entity shown in that model is created as the Service entity in this model because Marcia offers dry cleaning services to her customers. Application logic will be needed to implement the Discount Award tracking in the database.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Entities, entity types, attributes and identifiers are shown in the ER diagram. Relationships and relationship names are also shown in the ER diagram. The following table details the relationships, their type and cardinalities:
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 06/05/2008 for the course ISE 382 taught by Professor Kale during the Spring '08 term at USC.

Page1 / 3

Homework_6_solution - Name: _ Homework 6 ISE 382...

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