Marks SECTION B.Data Modeling(Total 80.) Question 1:(total 40 marks) You are supplied with the following information. Safe Rentals, a private rental company which rents out vehicles (cars and vans). The Company has various outlets (garage/offices) throughout the city of Toowoomba. Each outlet has a member, address, phone number, fax number, and a manager who supervises the operation of the garage and offices at each site. Each site is allocated a stock of vehicles for rent; however, individual vehicles may be moved between outlets, as required. Only the current location for each vehicle is stored. The registration number uniquely identifies each vehicle for rent and is used when hiring a vehicle to a client. Clients may rent vehicles for various periods of time (minimum 1 day to maximum 1 year). Each individual rent agreement between a client and the Company is uniquely identified using a rent number. Information stored on the vehicles for rent include: the vehicle registration number, model, make, engine size, capacity, current mileage, date registration due, daily rent rate, and the current location (outlet) of each vehicle. The data stored on a rent agreement includes the rent number, the client's number, name, address and phone number, date the client started the rent period, date the client wishes to terminate the rent period, the vehicle registration mumber, model and make, the mileage before and after the rent period. After Enphase Heading 1 1 Normal Strong Sutte Paragraph number, name (first and last name), home address, home phone number, date of birth (DOB), gender, National Insurance Number (NIN), date joined the Company, job title and salary. Each staff member is associated with a single outlet but may be moved to an altemative outlet as required, although only the current location for each member of staffis stored. Prepare the following: a) An ER diagram for the system. Show all entities relationships. cardinalities and optionalities also include all intersection entities. You must use the finkelstein methodology as per the lecture and tutorials. b)A list of relations(equivalent to finkelstein entity list).produce complete relations for all entities and attributes show all primary and foreign keys. include all attributes that are specifically mentioned and all key attributes you may need to create primary and foreign keys that are not specifically mentioned. You must use the linkelstein methodology as per the lecture and tutorials Question 2:(total 30 marks) Normalise the following unnornalised relation to 3NE. TEACHER(tid, name, address.((certificateid.name date of get), facultvid, Marks SECTION B.Data Modeling(Total 80.) Question 1:(total 40 marks) You are supplied with the following information. Safe Rentals, a private rental company which rents out vehicles (cars and vans). The Company has various outlets (garage/offices) throughout the city of Toowoomba. Each outlet has a member, address, phone number, fax number, and a manager who supervises the operation of the garage and offices at each site. Each site is allocated a stock of vehicles for rent; however, individual vehicles may be moved between outlets, as required. Only the current location for each vehicle is stored. The registration number uniquely identifies each vehicle for rent and is used when hiring a vehicle to a client. Clients may rent vehicles for various periods of time (minimum 1 day to maximum 1 year). Each individual rent agreement between a client and the Company is uniquely identified using a rent number. Information stored on the vehicles for rent include: the vehicle registration number, model, make, engine size, capacity, current mileage, date registration due, daily rent rate, and the current location (outlet) of each vehicle. The data stored on a rent agreement includes the rent number, the client's number, name, address and phone number, date the client started the rent period, date the client wishes to terminate the rent period, the vehicle registration mumber, model and make, the mileage before and after the rent period. After Enphase Heading 1 1 Normal Strong Sutte Paragraph number, name (first and last name), home address, home phone number, date of birth (DOB), gender, National Insurance Number (NIN), date joined the Company, job title and salary. Each staff member is associated with a single outlet but may be moved to an altemative outlet as required, although only the current location for each member of staffis stored. Prepare the following: a) An ER diagram for the system. Show all entities relationships. cardinalities and optionalities also include all intersection entities. You must use the finkelstein methodology as per the lecture and tutorials. b)A list of relations(equivalent to finkelstein entity list).produce complete relations for all entities and attributes show all primary and foreign keys. include all attributes that are specifically mentioned and all key attributes you may need to create primary and foreign keys that are not specifically mentioned. You must use the linkelstein methodology as per the lecture and tutorials Question 2:(total 30 marks) Normalise the following unnornalised relation to 3NE. TEACHER(tid, name, address.((certificateid.name date of get), facultvid