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

Analyse and design a small database application based on the given case study - Coursework Examplemechanism-I similarly interviewed mechanics for one of the branches for Mercedes Company and obtained the following information, there is a chief mechanic whose work is to let go jobs at the garage he can issue a benefit 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 guest care set aboutment so that the department can contact the relevant customer. Customer care after a serve well 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 trunk 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 think I should research for on similar garage databases and obtain the requirements that are behold the users perception. Question 2 Find the diagram tie in another file. Question 3 Customer table Table name associate Data type Length earthly concern Primary describe Foreign key Null customer CusNo int 10 yes no customer FirstNames varchar 50 no customer LastName varchar 50 no customer Location varchar c no customer Mobile varchar cytosine no customer Email varchar 100 yes custome r passportNo varchar 50 yes Customer S.CenterNo int 10 yes Car table Tablename proportion Datatype Length Domain Primary key Foreign key Null Car RegNo varchar 50 yes no Car carname varchar 100 no Car pretense varchar 100 no Car Make varchar 100 no Car Datepurchased date 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 location 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 role 16 No company location varchar 100 No company webSite varchar 100 Yes company EmailAddress varchar 100 Yes company imageFile varchar 250 No Garage 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 Service 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 200 No service PartsReplaced varchar 100 yes service Labourcost varchar 100 No service partsCost varchar 100 yes s