1. Stated four features of data warehouse.(3 marks) 2. Why is it say that Data warehouse...

Transcribed Image Text:

1. Stated four features of data warehouse.(3 marks) 2. Why is it say that Data warehouse is Time-variant Data. (5 marks) 3. What could be the reason why the application of the 5 rules of transformation from Entity-Relation to Relation would not produce a collection of relations in 3rd Normal Form. Back your proposal with examples. (6 marks) 4. Describe the rule of third normal form without make reference to first and second normal form. (5 marks) 5. Describe the rule that enable the transformation of this E-R diagram below to relational model. (5 marks) CUSTOMER [N:M] Customer_id BOUGHT CustomerFname (1,N) (1,M) ARTICLE ArticleName CustomerLname Quantity date CustomerDOB Unit-price Cust.address 1. Stated four features of data warehouse.(3 marks) 2. Why is it say that Data warehouse is Time-variant Data. (5 marks) 3. What could be the reason why the application of the 5 rules of transformation from Entity-Relation to Relation would not produce a collection of relations in 3rd Normal Form. Back your proposal with examples. (6 marks) 4. Describe the rule of third normal form without make reference to first and second normal form. (5 marks) 5. Describe the rule that enable the transformation of this E-R diagram below to relational model. (5 marks) CUSTOMER [N:M] Customer_id BOUGHT CustomerFname (1,N) (1,M) ARTICLE ArticleName CustomerLname Quantity date CustomerDOB Unit-price Cust.address