6.

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

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

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

4.l State and briefly clarify six factors that are likely to affect the cost of maintaining a software system. [06]

-

• Corrective Maintenance - This includes modifications and updations done in order to correct or fix problems, which are either discovered by user or concluded by user error reports.
• Adaptive Maintenance - This includes modifications and updations applied to keep the software product up-to date and tuned to the ever changing world of technology and business environment.
• Perfective Maintenance - This includes modifications and updates done in order to keep the software usable over long period of time. It includes new features, new user requirements for refining the software and improve its reliability and performance.
• Preventive Maintenance - This includes modifications and updations to prevent future problems of the software. It aims to attend problems, which are not significant at this moment but may cause serious issues in future.
• Market Conditions - Policies, which changes over the time, such as taxation and newly introduced constraints like, how to maintain bookkeeping, may trigger need for modification.
• Client Requirements - Over the time, customer may ask for new features or functions in the software.