Hi, I need help with essay on Analyse and design a small database application based on the given case study. Paper must be at least 3000 words. Please, no plagiarized work!Download file to see previou

Hi, I need help with essay on Analyse and design a small database application based on the given case study. Paper must be at least 3000 words. Please, no plagiarized work!

Mechanics-I also interviewed mechanics for one of the branches for Mercedes Company and obtained the following information, there is a chief mechanic whose work is to issue jobs at the garage. he can issue a service job to one or many mechanics at the garage depending on the magnitude of the job. There sometimes when some Mechanics are off duty thus they are not issued any job. A mechanic records parts to be bought and the actual cost of labor and notifies the customer care department so that the department can contact the relevant customer. Customer care – after a service has been done, the customer care depart contacts the owner and sends him/her and invoice as per the service done. Brainstorming I would hold a meeting which would have the representation of all the parties, stakeholders and departments involved. The meeting would have a director from the Mercedes Company, a few customers from different branches of the Mercedes Company, a few mechanics, chief engineers and customer care employees from different branches of the Mercedes Company. We would brain storm on how we want the system work in order to fully satisfy the needs of the involved people. Secondly I may issue questionnaire to the people in the meeting so that they fill so as I get to know how each person who works in the service wants his/her work simplified. After interviewing the involved parties and brainstorming I should research for on similar garage databases and obtain the requirements that are behold the user’s perception. Question 2 Find the diagram attached in another file. Question 3 Customer table Table name Attribute Data type Length Domain Primary key Foreign key Null customer CusNo int 10 yes no customer FirstNames varchar 50 no customer LastName varchar 50 no customer Location varchar 100 no customer Mobile varchar 100 no customer Email varchar 100 yes customer passportNo varchar 50 yes Customer S.