Project 2

In a nutshell, the requirement for Project 2 is to transform the logical database model you designed in Project 1 to the phyiscal model.  You are required to use your ERD design from project 1 for project 2.  Project 2 also requires you to create several SQL script files which must also be submited to me in the .sql & .LST extensions so attach them as well.

Project 1 Feedback (NOT GRADED AS BOTH WILL BE DONE TOGETHER):

Feedback:

ERD looks good. I'm not saying it's perfect, but it captures most of the information.  Genre is not captured.

You can begin building the physical model which is project 2.

NOTE: All SQL script & SPOOL files need to be attached!

the requirement for Project 2 is to transform the logical database model you designed in Project 1 to the phyiscal model.  You are required to use your ERD design from project 1 for project 2.  Project 2 also requires you to create several SQL script files.

Project 1 instructions & answers are attached just as directions for project 2 is as well. Use directions from Project 2 to do the assignment and make the needed files based on Project 1 answers which is file name WRC_PROJECT1.

Please ask questions of anything you don't understand.