Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone help me with creating the programming code for this shipping methods table? Thank you! In project task 5, you were asked to write
Can someone help me with creating the programming code for this shipping methods table? Thank you!
In project task 5, you were asked to write the stored procedures to create the enti s, attributes tie 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: 1. customer 2. shippingAddress 3. payment Info 4. department 5. category 6. product 7. orders S. orderItems 9. shipping Methods 10. upsells 11. crossSells Since the shippingAddress, paymentlnfo and orders tables depend on the customer table, you should create the customer table before creating these three. Same is true for the hierarchy o department to category and category to product. Once the product table has been created, you can then add the orders table followed by the orderltems and shippingMethods table. Last would be to create the upsells and crossSells tables. When creating the upsells and cross Sells tables, the order of these two doesn't matter as long as the customer, orderltems and product tables are created first
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started