CHAPTER 1: DATABASES AND DATABASE USERS 1. Given the simple SalesRep-Worksin-SalesArea database schema that contains three files described as follows, answer the following questions with regards to this database. (Total for que 1 is 10 marks) 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. i) ii) Create a valid instance of this database containing values for its records with at least four records in each file. (3 marks) Provide 2 informal English (not SQL) queries from this database with their answers. Each query should involve at least 2 of the files in the database and your answer should indicate the files (e.g., SalesRep, Worksin) needed to answer each query and specify what fields (attributes) are being retrieved as the result (e.g., SRname, SRage). Please, provide your solution in the 3 column table below. (4 marks) Specify at least 3 relationships (one for each of the 3 database files) among the records of the database. For each file (e.g., SalesRep), list any relationships it has with other files through its fields (e.g., SRid). Provide your solution using the table below. (3 marks) iii)