Dear Teachers please help me with these questions thank you so much big thumb up to you

pls do the questions in the images of word document below thanks

Case Background Spock Service Centre has been servicing cars over the last 40 years. They started storing data in a file-based system and then transitioned into using spreadsheets. As years progressed, the number of cars they service has grown exponentially leading to an increase in number of branches and volume of data. Spock Service Centre finds it quite difficult to manipulate and share the data across branches. You are employed to develop a database model to replace the current You have been provided with the following business rules about Spock Service Centre Each customer is provided with a unique identifier. Details of a customer include: name, address, phone number and email address. A customer could sign up for the loyalty program. A loyal customer would get a set discount rate which is recorded along with the signup date. e . Some details about a car would include: registration number, model, type (sedan/hatchback), number of doors (two/four) are stored. Each car manufacturer has their own unique identifier. Details of a manufacturer include- name, hotline, primary contact person name are also stored. . Every branch of Spock Service Centre is provided with a unique identifier. Details of a branch include: name, address, and phone number. Branches employ two different types of employees- Managers and Mechanics. Each employee is provided with a unique identifler. This identifier is used across the all of the branches. Details of an employee would include: name, address, phone number, and annual salary. If the employee is a manager, then their start date is stored. If the employee is a mechanic, then their highest qualification is stored. A mechanic may either work full time or part time. For part time mechanics, the number of hours they work per week is also recorded. The "salary" stored for the part time mechanic is the annual amount they would earn based on the number of hours they are working per week. A service can be one of many different types. Each type of service has a unique identifier Any service type that is offered is available at any branch. Each service type needs to include: a name, a description and cost of service . A customer must make a booking to service their car. A unique booking id is generated when the customer makes a booking. As part of the booking process, there are some details which need to be included such as: the car to be serviced, the branch that service will happen at, the type of service, the primary mechanic who services the car, and the date and time of service. Policy dictates that a booking is for one service type only eOnly one payment is carried out for a booking. Each payment has a unique identifier. The mode of payment and payment date are also recorded. A customer can own many cars. However, a car belongs to one customer only. A car is manufactured by a single manufacturer A manager can work for one branch only. A branch is managed by one manager only e