Course Solutions Uncategorized (Solved) : Explain System Implemented Data Warehouse Would Differ Oltp System Current System Differen Q32646053 . . . .

(Solved) : Explain System Implemented Data Warehouse Would Differ Oltp System Current System Differen Q32646053 . . . .

 

Explain how if this system was implemented as a data warehouseit would differ from the OLTP system of the current system. Some ofthe differences you should address include (but should not belimited to) data structure and types of queries users would addressto each system. (for example, the data structure as a starschema).

Customer custlD [PK), firstname lastname Purchase custID [PK FK) itemID PK] [FK) purchasedate (PK) Email Optin custstadd 1..1 0 deliverystreetaddress deliverycity deliverypostcode employeeD(FK) storename custpostcode Item 1..1 itemID [PK) 1..1 Employee temname employeelD (PK) employeefirstname employeelastname

Customer custlD [PK), firstname lastname Purchase custID [PK FK) itemID

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post