Question: The ERD below is associated with an operational database. a) Identify the Transaction Entities. b) For each Transaction Entity, identify its Component Entities, Classification Entities,

The ERD below is associated with an operational database. a) Identify the Transaction Entities. b) For each Transaction Entity, identify its Component Entities, Classification Entities, Hierarchies, Measures (including derived variables), and possible Time dimensions. c) Provide a graphical representation of the corresponding Star Schema model(s). Microsoft Access - [Relationships] Elle Edit View Relationships Tools Window Help 2140X8SXS- Type a question for help Suppliers Shippers Order Details Order Produt) Unit Price Supper Company Contacte Contact Title Company Name Phone Orders Order Customer Employee Order Date RequiredDate Sepete Products Produkt Product Name Suppler CategoryID Quantity Perunt J&& Freight Shame ShipAddress Shipky Ship Region ShippostalCode Ship Country Employees Customers Customer Company Name Contact Name Contact Title Address Units Stock Unison order Reorderlevel Categories Employee LastName Category CategoryName Description Picture Title TitleOfCourtesy Buthate > TimeSheet Employeeld ContractID Date Worked Timeout Contract Contractat Contract Name ont_Start Date Cht_End Date Ready !! start NUM : 8:53 AM C5 Internet... W 2 Microsoft... - Skype-kw... Exam Materials 22 Microsoft... Inbox - Out... The ERD below is associated with an operational database. a) Identify the Transaction Entities. b) For each Transaction Entity, identify its Component Entities, Classification Entities, Hierarchies, Measures (including derived variables), and possible Time dimensions. c) Provide a graphical representation of the corresponding Star Schema model(s). Microsoft Access - [Relationships] Elle Edit View Relationships Tools Window Help 2140X8SXS- Type a question for help Suppliers Shippers Order Details Order Produt) Unit Price Supper Company Contacte Contact Title Company Name Phone Orders Order Customer Employee Order Date RequiredDate Sepete Products Produkt Product Name Suppler CategoryID Quantity Perunt J&& Freight Shame ShipAddress Shipky Ship Region ShippostalCode Ship Country Employees Customers Customer Company Name Contact Name Contact Title Address Units Stock Unison order Reorderlevel Categories Employee LastName Category CategoryName Description Picture Title TitleOfCourtesy Buthate > TimeSheet Employeeld ContractID Date Worked Timeout Contract Contractat Contract Name ont_Start Date Cht_End Date Ready !! start NUM : 8:53 AM C5 Internet... W 2 Microsoft... - Skype-kw... Exam Materials 22 Microsoft... Inbox - Out
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
