Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data And Information Quality Dimensions, Principles And Techniques

Authors: Carlo Batini, Monica Scannapieco

1st Edition

3319241060, 9783319241067

More Books

Students also viewed these Databases questions