1 / 4

Order

Problem 1. Part description. Order id. Order date. Part number. Order time. Inventory. Contains. Order. Parts. Contact name. Contact email. Contact phone. Sold by. Supplier PN. Supplier. Supplier Phone. Supplier Acct. Mgr. Supplier ID. Supplier Name. Supplier Address.

gil
Download Presentation

Order

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Problem 1 Part description Order id Order date Part number Order time Inventory Contains Order Parts Contact name Contact email Contact phone Sold by Supplier PN Supplier Supplier Phone Supplier Acct. Mgr. Supplier ID Supplier Name Supplier Address

  2. Problem 1: Schema

  3. Problem 2 UnitID Living Room? Stories Move in date Move out date HouseholdID Kitchen? Location Year Opened HouseholdDescription* Contains Lived in by Housing development Housing unit Household Bathrooms Name Bedrooms Has Units Square footage DevelopmentID Resident Head of household? Birthdate Resident ID * Not part of original scenario Name Gender

  4. Problem 1: Schema

More Related