Sunday, July 4, 2010

Exercise 4.1-Logical Database Design


Direction: Below is an ER Diagram of a typical Sales System. Convert it to a Relational Schema.Try to do a research about the ER Diagram and the Relational Schema. Write your answer on a 1 whole sheet of paper. 


 

Exercise 4.2-Logical to Physical Database Design
Direction: Using MS SQL SERVER 2005, implement the ER Diagram of a typical Sales System (refer Exercise 4.1). Named your database as SALES. Save a copy of a SALES.sql file to your account.