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]

solution 5.1

Branch Company Production Date ID: INT ID: INT NO_OF_UNITS: INT NAME: VARCHAR NAME: VARCHAR BACKUP TIME: TIME AREA: VARCHAR ADDRESS: VARCHAR BACKUP DATE: DATE ZIPCODE: INT ZIPCODE: INT EMAIL: VARCHAR Location Product Product Line LOCATION_ID: INT ID: INT BRAND: VARCHAR NAME: VARCHAR NAME: VARCHAR PRICE: INT ZIPCODE: INT PRICE: VARCHAR DEMOGRAPHIC: VARCHAR AREA: VARCHAR QUANTITY: INT COUNTRY: VARCHAR