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. PS 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
