Analyse and design a small database application based on the given Coursework

Analyse and design a small database application program based on the given case study - Coursework ExampleMechanics-I also interviewed mechanics for one of the branches for Mercedes order 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 occupation thus they are not issued any job. A mechanic records parts to be bought and the actual somebodyify of labor and notifies the guest care department so that the department can contact the relevant node. guest 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 opposition which would have the representation of all the parties, stakeholders and departments involved. The meeting would have a director from the Mercedes Com pany, 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 social club 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 users perception. Question 2 regard the diagram attached in another file. Question 3 Customer table Table defecate portion Data type space Domain prime mark extraneous key unavailing customer CusNo int 10 yes no customer FirstNames varchar 50 no customer LastName varchar 50 no customer Location varchar one hundred no customer Mobile varchar light speed no customer Email varchar 100 yes customer passportNo varchar 50 yes Customer S.CenterNo int 10 yes Car table Tablename Attribute Datatype Length Domain Primary key Foreign key Null Car RegNo varchar 50 yes no Car carname varchar 100 no Car model varchar 100 no Car Make varchar 100 no Car Datepurchased find no Car showroomNo int 10 yes no Car cusNo int 10 yes no Showroom table Tablename Attribute Datatype Length Domain Primary key Foreign key Null Showroom roomNo int 10 yes No showroom roomName varchar 50 No showroom post varchar 100 No showroom telephoneAddress varchar 100 No Company details Tablename Attribute Data type Length Domain Primary key Foreign key Null company companyNo int 10 yes No company name varchar 50 No company logo image 16 No company location varchar 100 No company webSite varchar 100 Yes company EmailAddress varchar 100 Yes company imageFile varchar 250 No service department details Tablename Attribute Data type Length Domain Primary key Foreign key Null Garage GarageNo int 10 yes No Garage name varchar 50 No Garage logo image 16 No Garage location varchar 100 No Garage telephoneAdd varchar 100 No Garage EmailAddress varchar 100 Yes Garage RoomNo int 10 yes serve up details Tablename Attribute Data type Length Domain Primary key Foreign key Null service ServiceNo int 10 yes No service DateofService date 50 No service TypeOfService varchar two hundred No service PartsReplaced varchar 100 yes service Labourcost varchar 100 No service partsCost varchar 100 yes s