DataBase using SQL -- 2

The Final Project will contain a database with at least 7 tables. Each table must have a primary key. Foreign keys should be defined where appropriate. 7 User views should be created, normalized to 3rd normal form. Stored procedures will be required for the creation of the database. A cover page, project description and an Entity Relation diagram for your project will be required. DB project includes: 1. Title Page (Title, Course Number, Date, and Your Name) 2. Project Description 3. User Views (6-8) 4. Normalization Steps for user views. 5. Combined View or Conceptual Data Model expressed as ER diagram. 6. Atrribute-Domain listing - data types of attributes. This is a 2_D table containing attributes listed in the left column, and the data type on the right column. example: Attributes Data type --------------------------------------------------------------- prodID integer prodDesc character length 20 unitPrice money quantOnHand integer 7. Attribute-User View Matrix. This is a 2_D table containing attributes listed in the left column, and Use Views on the top row. If an attribute is used in a user view, an 'X' is placed in the intersection of that row and column. example: Attributes User View1 User View2 User View3 User View4 User View5 User View6 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- prodID x x prodDesc x x unitPrice x x quantOnHand x custID x x x ... assuming that the following is true: prodID is used in User View1 and User View3 prodDesc is used in User View1 and User View3 unitPrice is used in User View1 and User View5 quantOnHand is used in User View4 custId is used in User View1, User View2 and User View6. 8. Listing of any business rule that may apply to the database. If there are any rules your database must know about, such as quantity on hand should not be less than 0 and unit price should not be less than 0.0 dollars and not more than 200.00 dollars, etc. 9. Place SQL files that will create the database for this application in a zipped folder with your name: It should contain: a. [login to view URL] (explaining how to implement this DB) If you are using foreign key constraints, I would need to know which create sql files to run first, and order of execution becomes important. You need to relate this to me in a read me file, in order that I can easily generate your database. b. SQL folder containing all the files to implement the DB and run reports to create most or all of the views you created. c. Label the sql files that creates reports as [login to view URL] so I can identify them quickly. I want all your sql scripts that create the tables and insert records into the tables, as well as the SELECT statements that will select the attributes for each user view. I plan to generate your database myself and see if your sql create & insert as well as the select query statements give me your user view data. So if you have 6 user views, I should see 6 sql files (the ones you call [login to view URL] for user view1, [login to view URL] for user view2.. etc up to [login to view URL] for user view 3) that will have select statements in them that will generate the data for your views.