Save Question 3 (5 points) A dimensional model for a data warehouse that contain

Question

Save Question 3 (5 points) A dimensional model for a data warehouse that contains dimensions that are normalized or partly normalized is referred to as a(n): O Aggregate star schema Family of stars nowfiake schema Simple star schema OLTP star schema Question 4 (5 points) Imagine that an organization s first attempt at data warehousing starts by creating a data mart for their customer relationship management. After this data mart proves to be successful, they decide to create another data mart for their logistics operations. Later, they create another data mart for their manufacturing department. Eventually, they integrate all of these data marts into a data warehouse so that data can be shared. Whose methodology for data warehouse development does this most closely resemble? Inmon

Explanation / Answer

In simple star scheme the dimensions are highly denormalized while in family of star scheme the the stars have common dimensions but they too are denormalized

In Aggregate star scheme the dimensios are aggregated not normalized like a summary report

In snow flake scheme the dimensions are highly normalized they cant be partly nomalized

In OLTP star scheme dimentions can be normalized upto 3NF or partly upto 1NF

so the answer is OLTP Star scheme

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.