Given the simple SalesRep-Worksin-SalesArea database schema that contains three files described as follows, answer the following questions with regards to this database.

SalesRep (SRid: integer, SRname: string, SRage: integer, salary: real)

Worksin (SRid: integer, Arid: integer, hours: integer)

SalesArea (Arid: integer, Aname: string, city: string, budget: real, managerid: integer) Note : SRid, SRname, SRage, salary are the sales rep id, name, age and salary respectively. Also, hours is the number of hours worked by sales rep in the sales area. The rest of the attributes Arid, Aname, city, budget and managerid are the area id, name, location, budget and managerid respectively. A manager is a sales rep.

2. Recall that a database has many types of users, each of whom may require a different view of the database. For example, one user of the SalesRep-Worksin-SalesArea database of question 1 may be accessing and printing the details and salaries of each Sales rep frequently and thus a view for this user is created. Another view for this database is checking that Sales area has available budget before expenditure such as paying salaries.

1. Using this SalesRep-Worksin-SalesArea database, give 2 additional views that may be needed by other user groups for the database. (5 marks)
2. Give 5 examples from many of the different types of key, domain, foreign key, entity and semantic integrity constraints that you think can apply to the SalesRep-Worksin-SalesArea database of question 1