Instructions
This week, you learned how to write data definition language in SQL Server by writing SQL CREATE statements. In this assignment, you will reference the entity-relationship diagram (ERD) from Week 3 to build your database using the QUERY function in SQL Server Management Studio Express. For this assignment, complete the following:
1. Write a single SQL scriipt, called CREATE.sql that includes the CREATE statements needed to build the schema in the third normal form. Make sure the statements are in the correct order, starting with the creation of the database itself, then the tables in the correct order of dependency based on the relationships between tables.
2. Sample data is needed to test the design of the database. Write a SQL scriipt called INSERT.sql to add at least 15 customers, each with 3 orders with no less than 3 items on each order. There should be 20 products and a minimum of 5 product categories. Be sure that orders span over 3 months provide a representative test data set for the first quarter of the year.
3. Describe the process of creating the scriipts for each of the required elements in the assignment and embed annotated screenshots of the process.
4. Test the design and prove that the schema is in 3NF by showing that all constraints have been tested. Verify that no INSERT, UPDATE, or DELETE anomalies are present. Provide annotated screenshots of the results of each part of the process.
Length: 5 to 7-page explanatory paper, plus 1 ready-to-execute SQL (.sql) file
References: Include a minimum of 2 scholarly resources.
The completed assignment should address all of the assignment requirements, exhibit evidence of concept knowledge, and demonstrate thoughtful consideration of the content presented in the course. The writing should integrate scholarly resources, reflect academic expectations and current APA standards, and adhere to Northcentral University’s Academic Integrity Policy.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|