MGM'l' 329: Database Management PROJECT TASK 6: DATA LOADING Overview of Project The class project will require students to apply the knowledge they learn in class in a practical manner. Each student will develop an ECommerce database used to maintain customers, products and sales information. You are required to 1) gather and analyze requirements 2) design logical structure of the database 3) create stored procedures to develop the tables and insert the data 4) write SQL statements for data extraction and reporting. All work for this project MUST be done on your own. This is an individual assignment, not group assignment. Anybody caught copying the work of others will receive a zero for the project. Project Task 6: Background In project task 5, you were asked to write the stored procedures to create the entities, attributes and relationships in your database. The stored procedure should have created each table in in an order that took referential integrity constraints into consideration. One possible order to creating these tables is as follows: customer shippingAddress paymentInfo department category product orders orderItems . shippingMethods 10. up sells 11. crossSells wwsewewvr Since the shippingAddress, paymentInfo and orders tables depend on the customer table, you should create the customer table before creating these three. Same is true for the hierarchy of department to category and category to product. Once the product table has been created, you can then add the orders table followed by the orderItems and shippingMethods table. Last would be to create the upSells and crossSells tables. When creating the upSells and crossSells tables, the order of these two doesn't matter as long as the customer, orderItems and product tables are created first. To ensure that everybody has the same database, your tables were dropped and re-created with the correct solution. If you were successful with Task 5 then your tables will be the same as you created. If you had some issues with your tables in task 5 or could not complete the task, then your database will be populated with the correct solution so that you can move forward and work on task 6