Assignment 3 Solutions - must have a primary key specified,...

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

View Full Document Right Arrow Icon
Assignment 3 Solutions  Textbook:  Page 100-101, Summary Questions  14  A 15  B 16  C 17  A 18  D Project Manual: Project 3.5, pgs. 47-49. Use Visio to create the ERD for the equipment rental company.  Indicate  cardinality and modality  on your diagram for all relationships (do not use ARROWS!) and  create associative  entities  if required. (Associative entities are required when a relationship is M:M). Remember that all entities 
Background image of page 1

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

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

Unformatted text preview: must have a primary key specified, including associative entities. Employee PK EmpID LastName FirstName Address HireDate FK1 Manager Customer PK CustomerID Contact Address Phone FK1 EmpID Rental Contract PK ContractNumber RentalDate ReturnDate FK1 CustomerID FK2 ItemID Equipment PK ItemID VendorSKU PurchaseDate Rate has a has a has manages Rental Contract Company If you created a contract with more than one item:...
View Full Document

This note was uploaded on 09/21/2011 for the course CGS 2545 taught by Professor Markllewellyn during the Summer '10 term at University of Central Florida.

Page1 / 3

Assignment 3 Solutions - must have a primary key specified,...

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