5.1

7.

Carefully study your solution for question 5.1, and then answer the following questions:

7.1 Construct a logical view that connects (joins) all the tables in your proposed schema for question 5.1. Identify two benefits that such a view would provide. Identify one drawback to keeping such a view in the database. [25]

7.2 Construct a materialized view that connects (joins) all the tables in your proposed schema for question 5.1. Describe one scenario where such a database object would be applicable. Identify one drawback to keeping such an object in the database. [25]

Branch ID: Int Name: Varchar * Area: Varchar Zipcode: Int Company ID: Int + Name: Varchar t Address: Varchar ZipCode: Int Email : Varchar! Production Data No-of-Units: Int Backup- -Time: Time Backup Date: Date Product Line Brand : Varchar Price: Int product ID: Int Location Location ID: Int Name: Varchar Ziplode: Int Area: Varchar Name: Varchar Price: Int Demographic : Varchar Country: Varchar Quantity: Int