HW 5 - 3. PRICE QUOTE (Quote_Quantity, Price, Item_Number,...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Michael Knutson Sarker 27 April 2011 MIS 322 Homework #5 2. ITEM (Item_ID, Item_Name, Product_ID, Product_Quantity, Production_Plan_ID, Shipment_ID, Supplier_ID) PRODUCT (Product_ID, Product_Name, Item_ID, Master_Schedule_ID) MASTER SCHEDULE (Master_Schedule_ID, Master_Schedule_Name, Product_ID, Production_Plan_ID) PRODUCTION PLAN (Production_Plan_ID, Production_Plan_Name, Item_ID, Master_Schedule_ID) SHIPMENT (Shipment_ID, Shipment_Name, Volume, Item_ID, Supplier_ID)SUPPLIER (Supplier_ID, Supplier_Name, Item_ID, Shipment_ID)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3. PRICE QUOTE (Quote_Quantity, Price, Item_Number, Vendor_ID, Order_Number) PART (Item_Number, Description) VENDOR (Vendor_ID, Address) PART RECEIPT (Order_Number, Date, Order_Quantity) 6.a APPLICANT (Applicant_ID, Applicant_Name, Applicant_Address) POSITION (Position_ID, Position_Title, Date_Position_Opens, Department, Applicant_ID) INTERVIEW (Date_Interviewed, Date_Applied, Applicant_ID, Position_ID, Offer)...
View Full Document

Ask a homework question - tutors are online