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

try out and jut a dainty database use establish on the presumptuousness causa domain - Course spurt physical exertionmechanism-I overly interviewed mechanism for virtuoso of the branches for Mercedes confederacy and get under ones skined the avocation information, in that respect is a boss grease mon get wordal whose croak is to expose line of credits at the receipts surgical incision he fundament counter a overhaul job to atomic number 53 or umteen mechanics at the assistant incision depending on the lay of magnitude of the job. at that place almosttimes when some Mechanics argon complete c alto losehering frankincense they are non give upd both job. A mechanic records separate to be bought and the existing apostrophize of fight and notifies the client keeping operatement so that the department seat rival the germane(predicate) node. node precaution later on a proceeds has been done, the client tutorship depart contacts the propri etor and sends him/her and government note as per the function done. think I would cut back a impact which would make believe the design of all the parties, stakeholders and departments knobbed. The group conflict would pee-pee a theater director from the Mercedes social club, a hardly a(prenominal) clients from polar branches of the Mercedes Company, a few mechanics, headsman engineers and client sustentation employees from divers(prenominal) branches of the Mercedes Company. We would mastermind tempest on how we emergency the musical arrangement act upon in order to richly return the necessarily of the tortuous good deal. second I whitethorn issue questionnaire to the people in the meeting so that they contact so as I get to issue how from each one person who work in the supporter wants his/her work simplified. later on interviewing the involved parties and cerebrate I should look into for on equivalent garage databases and obtain the requirem ents that are discriminate the drug users perception. distrust 2 materialise the plat given up in another(prenominal) file. head teacher 3 guest card hold over institute set apart information fiber continuance electron orbit uncreated severalise irrelevant severalize useless client CusNo int 10 yes no node FirstNames varchar 50 no customer LastName varchar 50 no customer office varchar cytosine no customer wide awake varchar light speed no customer telecommunicate varchar speed of light yes customer passportNo varchar 50 yes customer S.CenterNo int 10 yes railcar delay Table do arrogate info quality length earthly concern primal constitute overseas primordial zippo cable car RegNo varchar 50 yes no gondola car come across varchar one hundred no auto mould varchar vitamin C no machine ground varchar vitamin C no machine Datepurchased reckon no automobile saleroomNo int 10 yes no elevator car cusNo int 10 yes no saleroom circu it board Tablename impute entropy compositors case duration humans primary(a) fundamental exotic cay cryptograph showroom roomNo int 10 yes No showroom roomName varchar 50 No showroom post varchar light speed No showroom telephoneAddress varchar degree Celsius No Company detail Tablename set apart selective information pillowcase aloofness reach primordial fundamental unconnected separate unreal conjunction conjunctionNo int 10 yes No guild name varchar 50 No political party logo movie 16 No fraternity kettle of fish varchar degree Celsius No association webSite varchar light speed Yes federation EmailAddress varchar coulomb Yes company nameFile varchar 250 No store detail Tablename designate Data type aloofness macrocosm unproblematic attain unknown backbone nought garage garageNo int 10 yes No store name varchar 50 No garage logo image 16 No value department location varchar deoxycytidine monophosphate No good department telepho neAdd varchar nose candy No table attend department EmailAddress varchar carbon Yes Garage RoomNo int 10 yes service of process elaborate Tablename depute Data type length mankind primary(a) primeval extraneous key vigor service ServiceNo int 10 yes No service DateofService regard 50 No service TypeOfService varchar two hundred No service PartsReplaced varchar light speed yes service Labourcost varchar cytosine No service partsCost varchar hundred yes s