Question: I have customer order table with columns CustomerOrderid as a primary key, customerid, orderstatusid,shipmentmethodid,shippingaddressid as a forien key, Orderdate, datepaid, estdateshippes, actualdateshipped, datemodified. I have

I have customer order table with columns CustomerOrderid as a primary key, customerid, orderstatusid,shipmentmethodid,shippingaddressid as a forien key, Orderdate, datepaid, estdateshippes, actualdateshipped, datemodified. I have another table shipmentmethod with columns shipmentmethodid as a primary key, shipmentmode, shipmentclass, shipmenttime, freighcost, datemodified. I have another table orderstatus with columns orderstatusid as a primarykey, description, datemodified. I have another table shippingaddress with columns, shippingaddressid as a primarykey, customerid and countryid as as foreign key, streetnumber, streetname, streettype, postalcode, city, notes. Now give the answer that youve goen the model built, I need you to move onto wring out the script to build the tables for our new data mart. P.S. Also, I really hate to bother you with this again, but dont forget to set the composite key for the fact table, last me you skipped this and it became a big mess... Addionally, while you did set the constraints last me you forgot to ensure you didnt allow updates or deletes through the connecons. We need the key connecons, but referenal integrity obviously isnt going to work here. So just...follow instrucons this me? Okay? Forward the .SQL file to me so I can pass it off to our DBA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!