This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: payment which is not tied to invoices such as a prepayment? Homework: a. Reading : i. Lecture Note 4 (Chapter 6) ii. Chapter 6 of Mannino b. Design : 1. The following tables were converted from an ERD that has been lost (underlined fields indicate the primary key). Please recover the ERD based on all the information given: Par t: PartNo , Description, Quantity, UnitPrice Bi n: BINNO , Capacity, Location, PartNo Departmen t: Name , Phone, Contact, Account, Balance Supplie r: Name , Address, City, State, Zip, Phone SPL_Par t: FK_Name, FK_Partno Dept_Par t: Department, Part 2. Convert the following ERD into a relational model:...
View Full Document
- Fall '10
- Entity-relationship model, Relational model, relational models