Describe what kinds of analyses your design will allow the business to carry out

Question

Describe what kinds of analyses your design will allow the business to carry out. Are there questions that this design wouldn't be able to answer?

Employee Dimension Employee Key Position EmpFirst Name EmpLastName Phone Number Wage Rate Customer Dimension CustFirst Name Cus LastName EmailAddress Customer ype Product Dimension ProductKey Product Size Product Price Product Name Sales Fact Table EmployeeKey (FK) Customer Key (FK) Product Key (FK) Store Key (FK) Ownerkey (FK) Calendarkey (FK) order LineKey (FK) TotalAmount TimeOfSale OrderLine Dimension OrderLineKey Purchase Key (FK) Product Key (FK) Quantity Store Dimension StoreKey Store Location Phone Number Owner Dimension Own First Name Own LastName Phone Number Calendar Dimension Calendarkey FullDate Day Of Week Day OfMonth Month Quarter Year

Explanation / Answer

If this diagram is a class diagram of a model, you cannot answer about the cardinality between the tables

Kind of analysis :

Sales Fact table is the center table ehich keeps all the information of the other tables by storing their PK as FK in its table.

Every different other table has no link between each other except Sales Fact table.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---