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 Example 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 cu stomer 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.CenterNo int 10 yes Car table Tablename Attribute Datatype Length Do main 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 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 image 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 EmailAddr ess 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