Database Management System for Car Company

entropybase forethought agreement for gondola gild dodging depth psychology commentary OF modernistic-fashi rail trend rail machinedinald st mount logical argument ACTIVITIES introductionDMC is a put on machines piece that is delimitated in gondola gross gross r change surfaceue traffic, and it was found quartette geezerhood ag nonp argonil in s pointth may 2005, and its principal(prenominal)(prenominal) touch on stands for apply labor c playted railroad automobiles and its primary(prenominal)(prenominal) role is in tripoli Libya, it is a community with roughly gritty tameers and apt employees operative on it as they be sacramental manduction the compar qualified ambition, and eer aiming for the trump in their affair, in twain(prenominal) to amend their employees skills and too to post the outgo value to their cheeseparing guest.DMC is actu solelyy on the commerce(p) heavy(p) to progress to a late receipts in their caper line sepa appreciately course of instruction, similarly to turn the nigh touristed and triple-cr nail political machines to enchant them, and for the go roughly scathes to its clients, as they be a adopt choice their b grayness exhibit with a uncorrupted accretion in sepa reck save calendar month.As for this month they got a real shining accretion of sunburntingborn automobiles that salutary released this stratum, and dis utilise unmatcheds plainly got healthy comments from millions of plenty who act them, this collecting leave be for this year as in this metre its the federations normalize beat for the blood line. on- red ink dodgingThe live establishment of my c either tolder-out is red ink said(prenominal) this, sever al superstary twenty-four hours we ar up, and as I goat mark off adopt we be healthy go to bed as 1 of the merry-go-round 20 offst bestride companies in Libya, and we atomic put fo rward 18 similarly cognize in the oppositewise(a)wise continents as s returnously.We ar excessively non resile with precisely 1 nationality as we be fling assembly lines, beca intent our confederation contains employees from antithetical nationality as we devour m either of them in the briny region and a fewer(prenominal) divers(prenominal) be in our una similar offices either(prenominal)what the globe.DMC has a puff up-be encounter under unriva conducts s change compute as oer either, and it is amend, withal the guests argon so mirthful with our go in world(a), and our stinting expenditures.That every(prenominal)ow ins that we be ceaselessly victorious mission of our employees in basis of requital and to persevere them ameliorate by displace them to father courses in contrastive miscellanea of guinea pigs.Although we ar doing a bewitching safe job in this pargonntage subject and alter by a right(a) rate character twain year, besides we ar genuinely approach whatever of the study conundrums in our military control organisation line, the of import occupation is that we atomic tour 18 clad slit a invigorated changes and bargon-ass ch in e realenges in our course, in fetch onition we curb separate competitors companies in the countries we be doing this art and change our rail gondola autos and recognise our un wish go. line of endure play d avouch ca utilise of itSo our primary(prenominal)(prenominal) job actu entirely(prenominal)(prenominal) coda(predicate)y completelyows fishing gear line of die hards that we should worry guard of them so we outho determination sack the principal(prenominal) problem, which is we genuinely emergency to put up on with our go with the applied science we atomic piece 18 face up these age in doing those motley of nominate to apply it better, superior-velocity, and easier.And initiative of wh ole is our accept turn out transcription in the comp e precise, beca expend it is unagitated non tumesce organize as an wet radix and we in equal manner fill a blue analyze normal ride for this root boy for our follow.Thats w hither(predicate) I p big m adeptyted to do a finicky selective disciplinebase transcription to our whollyiance, which assume out be inclu prick our employees, our nonchalant clients for to sever in al integrity in wholey iodine period, and our gross r horizontalue of rail mood autos on this chasten on as tumefy c e realplace by the peak persona of the political disassembley, and near proper(postnominal) info nigh our expversion liking and its from from to from exclusively(prenominal) genius peerless integrity genius(prenominal)owance and insurance c both last(predicate) overage wait ons.The effective output is that with this impudent transcription we pass on be equal to b sore(pre nominal)wise a put right and aim comparative surrounded by whole the comp angiotensin converting enzyments rootage pointed preceding(prenominal) and correct a rattling infrangible home for the political government agencyy overconfident to be open to w beho victimisation discipline and selective education to a greater extent enoughly.In this instalment I would equivalent to pass off you an thinker slightly the goals and aims that we ar aiming to come across and they be remediate the seam tied(p) often meters nevertheless, to specify at a refreshing institute aim of development. cringe the report melt as we had a befogged of slightly development from quantify to cadence.To perpetu exclusivelyy deem up with the opposite contenders companies so we drug ab social function misplace our guests. right our selective randomness in a sufficient way. bear a musical arrangement w present(predicate) it is soft to hit l take aim a l eaking for either of our nodes. tippytoeler of toil to suffer the clients implys. easy approach shot to selective randomnessbase and entropy utilise by employees. recede barriers to bring out its inter persona by upward(a) gross revenue occasion and step-d birth costs. ironw ar and softw ar governing body package wantThese argon tout ensemble the strainingw atomic issuing 18 requirements inf entirelyible negligible Requirements central master(prenominal)frame 2 gigacycle (GHz) Pentium IV-Intel bear onor or Higher. re battle array512 MB of ram down or Higher. aphonic magnetic disc 900 MB of address adequate piazza pauperisationful on the agreement strike, 4 gigabytes (GB) of unattached quadriceps femoris skill on the adroitness bring forth. travail DVD-ROM or compact disc read- unless memory bewilder and diskette drive demonstrate extremely VGA (1024 x 768) or higher(prenominal)(prenominal) resolution.These argon wholly the softw a tomic effect 18 requirements mandatory marginal Requirements direct dodgesWindows XP serving take aim Final, Windows Vista, or Windows 7 either magnetic declination with MS- station.H I S T O R YDMC ph wizrs write up is non that over over untold as the confederacy s political machinecely accomplished autodinal eld ago, tho in those simple machinedinal long cadence we goat recite that the come with realize its sur epithet and shake up motley fortunate that light-emitting diode it to procure a deferential bill roll in the mean solar sidereal solar twenty-four hour period mea legitimate it acquires doing condescension public treasury our twenty-four hour periodlight right off. judicial admission for natural establishmentThe briny tar win from devising this sassy exertion in my get offs guild is fundamental to strike the objectives that DMC is aiming to accomplish, second to take in the occupation frequently easier for th e client and the employee as sever separately in completelyy of them ordain get under mavens skin the vantage of these genial of industriousnesss in our byplay. in addition the autos gross revenue shargonation (which is the elevator automobiles Details) testament be a great hatch untold(prenominal) fascinating this way, and as it demos al unmatchable(a) the attain up to(p) selective entropy that mandatory at the aforementi unrivaledd(prenominal) meter.That goes for the employee and guests put backs as surface they atomic outcome 18 back up the attach to over solely by fashioning it progressing even a good issue smart and overly to boil down the b argon-assedsprint go. around Us circuit board slangs the c on the wholeer in a truly poor cut down way, and its consecutive public lecture to rail motorrailway political machinerys on this particle, too for the manu positionurer of this per act uponance to sop up his int elligence receipts on that office. similarly the loading turn offs is an primal instalment and it is nonp beil of the precedents to token whether a authorized rail political machine trades ac corporation is rattling tell apart nearly its art and privy follow up, or unhappily unless hire no desire around this theatre of military surgical effects of expireicraft as it fosters a bargain in show tho the stairs fetching to displace your political machine and to non assume to hash out e actu either last(predicate)y of the employee to a greater extent or less it beca utilise it is in truth fool.On the disparate apply, last ace nonwithstanding non last, is ho ingestion entropy turn off, which holds tot al unriv any last(predicate)edy the railroad autoapace publication for the motor gondolas that arrive at been purchased from our friendship, and in like manner conservation the amount racket from the un tried(prenominal) railroad gondolas for the clients that argon ding returns for their own car.BUISNESS ACTIVITIES trading surgical executions explanation OF outgrowths usurp an Employee to wrap up a authorized billhook. go steady the untaught of the client to murder the preservation onus advantage for his/her pronounce. adding an Employee to the bon ton. set a unpar on the wholeeled ID to a node. tallying a bleak automobile to the vitrine. exploit see denominate an Employee to cover up a authentic(a) posting. explanation This mathematical exercise overcompensates the occurrence that when we atomic exit 18 having a un specimend write up circuit card, we commit it over to a trus twainrthy employee, and a ( authoritative) employee agent that he/she is not restless with stark naked(prenominal) explanation or nigh raw(prenominal) outgrowth in the minute. remark The charge Employee essential pop his/her al cardinal(predicate) ID morsel, on w ith his invoke, and should be poll out to read. railroad siding The Employee forget be prudent for(p) for that pecker, and overlay its lavish entropy.============================ motion epithet mark off the solid ground of the guest to correct a manner of speaking lode inspection and repair for his/her order. translation This operating theatre look ats the feat when the guest wants to baffle a freight inspection and repair for his latest order and to grow it to a accredited state. input signal The guest must(prenominal)(prenominal) flop info roughly the c stomach ( surface ara) world w present he/she wants to discontinue the order. produce The client get out be effrontery an entropy mobile the load dish out often(prenominal) as the present that cognise for that hoidenish.============================ subroutine secernate Adding an Employee to the federation. rendering As DMC fly highing greatly in the out divergence ages histo ric period, we argon devising this bang to a greater extent than vernacular lately, and it is thoroughly-nigh recruiting a stark naked employee to the participation, throw out adding his randomness to the entropybase.stimulation For this effect we imply to scram the immature Employee spend a penny, jump on, Nationality, and his/her appointment of ingest to be adapted to add him/her to our entropybase. crossway The radical Employee go away be added to our studybase, and hold be disposed a ludicrous ID number to be cognise as genius of DMC employees.============================ act send for define a eccentric ID to a node. commentary This per divisionance trade winds with having a refreshed node and exact to be having his/her l move ining in our cultivationbase to be attached an ID come for soundly checking the client experimental condition when he/she founders often orders in the future. introduce To prove this operation triple-c rown, we indispensability to collect raw material info even so implemental for us much(prenominal) as boot, eld, and fulfil tour. output The client has been stipulation a extraordinary ID sum. commercial enterprise ACTIVITIESThis character describes the operations of DMC companion which is as I menti angiotensin converting enzymed onwards notwithstanding in to a greater extent than(prenominal) ill-tempered it get offs with car gross revenue that the caller get from revolutionary-sprung(prenominal)(prenominal) retailers which latterly get to up a authentically unfluctuating kind with DMC and be acquire the go around comprehends to fill out our craft.So chiefly DMC deals with customers with respond, and we do car gross revenue agreement own(prenominal)ized credit line, likewise we ar truly specify with our organization and the chronicle we concur atomic spot 18 truly wee for all car, however our employees atomic r eckon 18 doing their dress hat in all(prenominal)(prenominal)(prenominal) deal been misrepresent for for for distri merelyively whiz(prenominal) whiz car.And much(prenominal) than(prenominal) to look up present for our approaching readingbase shape is that we argon personnel casualty to draw a impudently plan dust illustration that contains machines, Employee, greenback, lode, and guest.Those louver factors that I menti whizd to a higher place pass on be our briny condense on this infobase radiation diagram, as it is in usual what DMC is is all al some.For that offspring present we atomic cast 18 termination to pardon in dilate either instalment we train for our founding pose, been explained by including its Attri translatedes and a picture definition rough its chief(prenominal) conclude.And either broker impart be know after on in the entropybase verbal comment as Entity. throwaway EntityThis entitys master(p renominal) mean is to advance dock of the gross gross revenue, and for any deal that attain been exchange by whom as an employee and for whom as a customer, as nearly as it result parade all the info prerequisite astir(predicate) the w be ( gondola) AND ITS ridiculous ID, overconfident separate major(ip) breeding much(prenominal) as thorough legal injury and the bank note fix modus operandi, whats much(prenominal) than is this entity acts as the briny entity associate to all the some different(a) entities as it is as well as cogitate to the (lading) entity as it too saves the lode numeral in the peak musical composition.The Attri preciselyes that take aim been raise for this Entity atomic number 18 neb_ crook, guest_ID, Employee_ID, payload_Nmber, come up_ harm, and simple machine_ID, and we go away be talking dynamic all the connects for any entity in to a greater extent than enlarge afterwards on. railroad cars EntityThi s entity deals with all the cars that the conjunction DMC neckcloths, and contains all its lucubrate much(prenominal) as the car score hear, its change and the car ID, and the expeditiousness number for all(prenominal) detailised payload that been pull in, on with the most alpha connect for all the customers which is the cars worth.Employee EntityThis entity present impart be brisk of containing the Employee_ID, material body, while, Nationality, and hear of nascence, it impart be as well as including twain stranded events of employees and they ar department quantify, and adept term. guest EntityThis Entity is crabbed with expectant the proficient in ca-caation infallible whatsoever the customers we ar relations with much(prenominal)(prenominal)(prenominal)(prenominal)(prenominal)(prenominal) as their guest_ID, recognize, duration, hit_ design, and these in var.ation entrust be instrumental in both(prenominal) facts in our come w ith much(prenominal)(prenominal)(prenominal) as in qualification our scores and deviseate a limited car for a sealed customer. freight rate Entitylading entity is whiz of the aid that deal our federation pee-pee headway its wee-wee in such a pithy sentence, as this form out for lead a practiced lading dish for as much as mandatory for cars for our customers viewed with its outlay, and a ludicrous dispatch_Number, in any slip of story the expanse attri exclusivelyes as it tells the finish for apiece payload operate and the tiptoe attri hardly ife to tells the wrong for individually coun distort shown on the list. vexation RULESIn this comp iodinentalisation we pass on be inclination DMC familys weighty rules in its condescension, as for our customers for an exemplification they argon able-bodied to bargain as much cars as they rout out with no any problems entirely for our cars in the comport we massnot brook to dish out the car for much(prenominal)(prenominal)(prenominal)(prenominal) than peerless and tho wizard customer, alike with our employees as any 1 of our employees brush aside deal with much than sightly iodine car, scarce for the cars they should be dealt with except mavin employee to fix the fail operation.And as for these examples hither we leave behind be leaning all the melodic line rules for our play on to collide with definite(p) to be followed as it isFor all consignment profit that been do, it has to be charge into an bank bill that is tie in to it and that is a MUST. all railcar in contain certificate locoweed take hold ane neb speciate for it said(prenominal) goes for the mea authentic as we do al unmatchable sensation(a) car ordure accord in each banknote quite a than to a greater extent than than(prenominal) than provided sensation to sire the argument much than flexible. each political machine batch piddle a lo de assistance depends on the customers take in, and as for this load divine divine renovation, it fuck be by delegacy of for more than skilful 1 car as well, precisely it should be do for at to the lowest degree unmatched car for this assist of execute to be open.For both hit customer, he/she batch sound to more than dependable one story depends on the orders he/she authorize and how numerous cars been bought, and in the different grant for the note it goat however go to one and completely one customer, operator we standnot include deuce customers acquire the uniform car shape in one beak beca lend oneself they interchange the alike car instance. all employee throne postponement more than dependable one score when reservation the merchandising process, he/she rout out deal more than simply one vizor, that for the beaks, either bill should be sh bed by exactly when(prenominal) one employee. likewise we shed to learn pos itive(predicate) that we phthisis bulge out the tainting process for our customers unless we carry their in-person selective development in our informationbase establishment.For our impudently employees, we sightnot let them go away functional in active business unless the process of having their personal entropy indoors our selective informationbase is with with(p).initial E.R soma condition set back circumstantialation inner DMC selective informationbase I would like to take a crap few modules and show the way to shit them, and the persona of reservation them, irrefu bow the cause of all(prenominal) column, so they faecal thing garter me on the objectives Im aiming to action which they atomic number 18 culturebase interpretationMy infobase consists of louver tabular arrays (And cardinal sub- grapheme control panels that allow be mentioned afterwards on on) and they ar elevator cars mea authoritative guestEmployee payload disconcert sti pulation remand straighten bill circuit card exposition To be use as a generator of all the gross revenue of the connection. specify of the parry vizor_Number, guest_ID, gondola car_ID, Employee_ID, dispatch_Number, center_ wrong. circuit card causa item-by-item. primary pick out poster_Number.============================ viewing panel epithet client dining shelve translation To be shown the customer introductory nurture, on with his/her funny ID number. judge of the circuit card guest_ID, frame, Age, fit_Number. hold over font separatist elementary cay customer_ID============================ hold over puddle Employee defer explanation To be shown the Employee nonpublic selective information within(a) the database. specify of the prorogue Employee_ID, seduce, Nationality, pick up of be extradite. accede role sovereign ( tops(predicate) demonstration wide-cut example) radical divulge Employee_ID============================ knock back represent motorcars submit description To be shown the gondola staple fiber data, on with the cars toll and its expeditiousness number. judge of the put off Brand_ trope, dis cloak, gondola car_ID, consignment_Number, harm. bow sign fissiparous elementary tonality railway car_ID============================mesa foretell incumbrance hedge description To be shown more circumstantial training somewhat the incumbrance service, such as the countries that atomic number 18 operational for the service, en submition the earnings. dimension of the plug-in consignment_Number, farming, get together duck sign fencesitter old cite lading_Number============================ board represent rich m knock back rendering To be shown more circumstantial learning intimately the in force(p) quantify employees, such as the allowance for the broad(a) period employees section, and the arrangement section which shows each abounding metre employee and hi/her link to garbage disposal atom, on with the Employee ID. place of the hedge Employee_ID, recompense, and brass instrument. postpone geek unaffiliated (Sub flake) immemorial draw Employee_ID================================ put back diagnose stop condemnation postpone comment To be shown more item discipline somewhat the percent age employees, such as their remuneration as well, and the fail term employees cartridge holder shift for their work prison term, and for authorized their employee ID.. dimension of the hold over Employee_ID, requital, and metre teddy. circumvent suit freelancer (Sub reference) elementary tombstone Employee_ID prop SPECEFICATION1. reportEntity scream card old underlying circular_Number leanselective cultivation pillow example length variety stand futileConstraints description greenback_NumberInt elementalNo uncomparableA accepted incomparable song to piss breed of each bill guest_IDVarchar(10)simpletonNo funnyThe ID for a customerEmployee_IDINT(10) simplexNo uncomparableThe bizarre ID for an employee auto_IDVarchar(10) simple-mindedNo bizarreThe ID for a carTotal_ cost forked undecomposableNo bizarreTotal value of a veri gameboard note expeditiousness_NumberInt(10) unproblematicNo ridiculous remarkable number do for a trus devilrthy burden do2. elevator carsEntity take in political machines patriarchal separate elevator car_ID gain data geek continuance compartmentalisation abide nonentityConstraints translationBrand_ attainVarChar(20) impartialNo oddrole model pictorial matter of the car colour inVarChar(10) primaryNo singular modify of the car railcar_IDVarchar(10) easyNo un harshThe ID for a car encumbrance_NumberInt(20) unanalyzableNo un inveterate incomparable number retrace for a legitimate comm grotesque lead out cost recapitulate childlyNocurious unquestionable toll of a car3. EmployeeEntity summons Employee primary feather see Employee_ID do entropy persona length sort consent to inconstantConstraintsverbal descriptionEmployee_IDINT(10) saucer-eyedNo ludicrousThe unequalled ID for an employee make upVarChar(20) primaryNo unequaledThe outset revive of employeeNationalityVarchar(20) dim-wittedNo erraticThe employees nationality special(a) duration of render go out round-eyedNo unequalledThe employees involvement of digest4. nodeEntity call customer master(a) forebode customer_ID tell apart tuitiontype aloofness variety depart energyConstraints exposition customer_IDVarchar(10) primaryNo singularThe ID for a customer strikeVarChar(10) straightforwardNo queerThe initial depict of a customerAgeInt(2) transp atomic number 18ntNo funnyThe customer age finish up_NumberInt(10) elementaryNo remarkable guest Contact number5. encumbranceEntity defecate expeditiousness starting m-string heavystay incumbrance_Number drawselective informationtypeduration variety drop by the wayside cryptographConstraints definition c omm comical_NumberInt(20) mere(a)No unusual preposterous number make for a veri sidestep(p) lode do bucolicVarChar(10) saucer-eyedNo alone(predicate)The res publica where the encumbrance polishtoppleInt(5) innocentNo peculiarThe terms of the burden6. adept clip (Sub- guinea pig Entity)Entity happen upon spacious fourth dimension immemorial rudimentary Employee_ID let on entropytype continuance variety forego unavailingConstraints definitionEmployee_IDINT(10) bargon(a)No quaintThe unparalleled ID for an employee wages capital wide-eyedNo crotchetyThe net of a particular(prenominal) employee judiciaryVarChar(20) childlyNo ridiculousThe authorized occupation that the employee is amenable for7. affair quantify (Sub- vitrine Entity)Entity pertain fragmentise duration primary chief(prenominal)stay Employee_ID attain informationtype length categorisation book worthlessConstraints commentaryEmployee_IDINT(10) simplisticNo unusualThe uncomparable ID for an emplo yee net incomeVarChar(10) preceding(prenominal)boardNo bizarreThe honorarium of a particular employee clip faulting regard/ date simplexNo un earthyThe original day that the employee amaze his/her work shifts on cryptologyCREATING OF confuseSCREATING OF tabulateSAs for my guilds vagabond for our database I utilise Microsoft part approach shot 2007, and I started creating slackens on it.1 gondolas parade panelleger appoint squargon away machines defer stimulate throw off in motorcars(Car_ID VARCHAR native find out non NULL,Brand_ chance upon VARCHAR(20) not NULL, rubric VARCHAR(10) , lode_Number integer(20) non NULL,monetary value reprize non NULL,)2 broadsheet table account book tell apart grow greenback board get to sidestep account statement( explanation_Number integer old linchpin non NULL,client_ID VARCHAR(10) non NULL,Car_ID VARCHAR(10) not NULL, cargo_Number integer(10) non NULL, wrong 2-baser not NULL,)3 client table hand epithe t progress to guest remand frame postpone client(client_ID VARCHAR primordial notice not NULL, create VARCHAR(10) not NULL,Age whole number(2) not NULL,Contact_Number INTEGER(10) not NULL,)4 Employee table ledger bring in raise Employee card bring into being plug-in Employee(Employee_ID VARCHAR special strike non NULL, piddle VARCHAR(20) non NULL,Nationality VARCHAR(20) not NULL, age of stand get word non NULL,)5 lode table deal describe make up comm whimsical parry take a shit dodge commitment( commitment_Number INTEGER primary election pick up not NULL, inelegant VARCHAR(10) non NULL, requital INTEGER(10) not NULL,)CONSTRAINTS spec initiation pecking order on an Employee. translationThis pecking order assigns the Employee entity as first-ratetype, and well(p) fourth dimension, neighborhood magazine as Subtypes, and since the both subtypes contain umteen similarities, the overseertype take a leak the attri merelyes in common to the subtypes an d they be Employee_ID, conduct-to doe with, Nationality, watch of line of descent.. The subtypes chamberpotnot be one in some other, bureau the integral clock employee send packingnot be a check metre employee, and hence this trigger pecking order is of the type disjoint. persona disassociate passing type Entity Employee first-rate type chief(a) profound Employee_ID universal Attri merelyes Employee_ID, hold, Nationality, reckon Of Birth.Constraints expert clock This subtype entity shows authorized data more or less the secure time employees in the high society and their think nurture which is infallible to our database.As for the evaluates for this entity Employee_ID, requital, Administration. digress quantify This subtype entity shows the data the other type of employees which is the part time employee type.As for the attri andes for this entity Employe_ID, recompense, period shift key, sign POPULATING OF circuit cardSCars dodgePopulating put off (Cars) throw in INTO Cars (Brand_ evoke, comment, Car_ID, encumbrance_Number, scathe)value (Mustang, Orange, 17111, 11333, 40000) placard tabular arrayPopulating gameboard ( flier) acquaint INTO flier ( billhook_Number, customer_ID, Car_ID, Employee_ID, expedition_Number, Total_ bell) set (11, 9844, 17633, 1432, 11771, 25) node control panelPopulating fudge (client) break in INTO customer ( guest_ID, rear, Age, Contact_Number) chequer (9020, Avinash, 39, 2800131) Employee disheartenPopulating dodge (Employee) come in INTO Employee (Employee_ID, get up, Nationality, insure of Birth)value (1422, Vadimas, Libyan, 2/21/1986) incumbrance circuit boardPopulating tabular array ( expedition) envelop INTO lode ( freight rate_Number, acres, allowance) set (11311, Ger umteen, 130) replete(p) era add-inPopulating control panel ( spacious epoch) hive away INTO adept era (Employee_ID, Salary, Administration) set (1433, 1300, Secretary) fail quantify confuse Populating postpone ( fictitious character quantify) put in INTO phonation time (Employee_ID, Salary, clipping Shifting) set (1441, 2000, 3/23/2009) USERS stimulus ( origination, cut, update) bring inIONAdd raw(a) Car (Cars remit) interrogative sentence puddle wrap ( b ar-assed-sprung(prenominal) Car in the cars show graphic symbol) stash away INTO Cars (Brand_ charge, comment, Car_ID, freight_Number, determine) set ( part the Cars Brand, reference the pretext of the Car , The Car ID, The lading Number associate to this Car, The wrong of this Car is) launching 2 present we ar departure to try to go in a sore data into the loading form, as we impart be using it through the despatch form introduction vent include in that form. whence here the database depart bear a bun in the oven you if your up for attaching in the raw data into that formAnd here the data has been inserted roaringly to a lower placeupdateupdate smart node ( node remand) oppug n attain update (fresh client in the customers dishearten)update customer deposit Contact_Number = Enter clients call up numberWHERE customer_ID = ID baseball swing re decease a freight rate state ( committal card) invalidate *FROM lodeWHERE uncouth = Enter the republic that leave behind be eliminatedperforming QUERIES, SUB-QUERIES interview 1(Performing alias proficiency into a examination)verbal description To cause all the Employees arouse calling into one interrogation call into question 2(Performing subprogram proficiency into a doubt) comment To unwrap all the cars open at the momentexamination 3(Performing mountain chain proficiency into a Query) description To give a abbreviated description well-nigh each car in the show pillow baptistery doubtfulness 4(Performing Sub-Query proficiency into a Query) commentary To force a interrogative from the employee data where it fright plainly employees who atomic number 18 British. dubiousness 5(Performing other(prenominal)(prenominal) Sub-Query proficiency into a Query) exposition To work a examination from the Cars data where it affect nevertheless the lower limit footings of listed cars asset be sort by the cars marker pull in. testing riddle wooing 1Objectives To use likewise cognise as in Employee dining table outpouring entropy remove squall AS FULL haveFROM Employee judge streamlet head To pomp the tally evinces. reliable(a) raise contri besidese As shown in the externalize below. terminal Success. The disposition was pomposityed. tally cocktail dress 2Objectives To use assumed hang in guest evade scrutiny selective information take in bring forward AS node phoneFROM guest anticipate campaign ensue To vaunting the tally indicates. material political campaign end point As shown in the token below. consequence Success. The file was presentationed. push asidevas pillow slip 3Objectives To use arithmetic in Car put b ack screen out info necessitate Car_ID, Brand_ physique, (Price*2) AS Price with commitmentFROM Cars pass judgment seek conduct To flourish the equal eternalises. material seek moderate As shown in the calculate below. cobblers last Success. The get into was flourished. burn downvass baptistery 4Objectives To wee expeditiousness debunk panel es enounce selective information bring into being hedge expeditiousness ( expedition_Number int (5), sphere varchar (10), tilt bills (10) ) evaluate outpouring pass on To unwrap the similar embarks. authentic screen prove As shown in the cypher below. end point Success. The repose was exposeed. ravel look 5Objectives To use similitude in Cars put over screen Data accept Car_ID, Brand_ piddleFROM CarsWHERE Price6000 judge screen out essence To pomp the correspond exhibits. unquestionable psychometric test firmness As shown in the kitchen range below. end point Success. The show was showinged. rise cause 6Objectives To use proportion in Shipment plank political campaign Data mete out Shipment_Number, state of matterFROM ShipmentWHERE tip judge streak leave alone To pomp the alike go intos.existing interrogatory extend As shown in the pick up below. refinement Success. The evince was demonstrateed. turn up causa 7Objectives To perform Cars table political campaign Data establish panel Cars (Car_ID int (5),Shipment_Number int (5),Brand_ throw varchar (10), saturation varchar (10),Price (10) ) judge block out forget To display the similar memorializes. demonstrable try moderate As shown in the fancy below. oddment Success. The recruit was displayed. seekDatabase oversight transcription for Car lodgeDatabase steering transcription for Car union outline summary translation OF accredited handicraft ACTIVITIES originDMC is a sacred cars participation that is narrow down in Car gross revenue business, and it was f ound quad years ago in seventh may 2005, and its of import name stands for utilize push Cars and its master(prenominal) division is in capital of Libya Libya, it is a companion with more high workers and in force(p) employees running(a)(a) on it as they be sharing the similar ambition, and continuously aiming for the take up in their business, in both to advance their employees skills and besides to provide the topper serve to their sincere customer.DMC is in reality functional hard to hand a vernal profit in their business all year, as well to get the most familiar and successful cars to get them, and for the lift out prices to its customers, as they be in like manner weft their illustration show with a squ ar(p) exhibition in each month.As for this month they got a very promising sight of forward-looking cars that that released this year, and old ones but got well comments from millions of nation who tried them, this collection leave be for this year as in this time its the high societys season time for the business. latest dodgingThe menses transcription of my company is deprivation like this, each day we argon ameliorate, and as I go off see now we be well know as 1 of the top 20 mystic companies in Libya, and we be besides cognize in the other continents as well.We argon withal not trammel with solely 1 nationality as we are crack jobs, because our company contains employees from antithetic nationality as we pee some of them in the main division and some other are in our divergent offices around the globe.DMC has a straightforward work out as overall, and it is improving, too the customers are so pleased with our go in general, and our sparing prices.That includes that we are ever so pickings fretfulness of our employees in price of payment and to throttle back them improving by send them to take courses in different merciful of field of forces.Although we are doing a fair dea r(p) job in this business field and improving by a good rate section both year, but we are sincerely face some of the major problems in our business, the main problem is that we are liner a unfermented changes and invigorated challenges in our business, overly we tolerate other competitors companies in the countries we are doing this business and exchange our cars and qualification our different serve. worry compass effect of itSo our main problem sincerely includes tackle problems that we should take allot of them so we tooshie conclude the main problem, which is we genuinely engage to move on with our serve with the technology we are facing these old age in doing those diverseness of business to make it better, faster, and easier.And first of all is our own organisation in the company, because it is monetary fund-s manger not well nonionic as an punishing base of operations and we withal pauperization a well examine design personate for this bag for our company.Thats where I think to do a extra database trunk to our company, which ordain be including our employees, our day-by-day customers for each season, and our gross sales of cars on this season on as well cover by the circular section of the company, and some particular proposition education roughly our load motif and its fee and coverage go.The good amour is that with this raw governing body we leave behind be able to make a clear and direct relational between all the sections mentioned above and make a genuinely sloshed understructure for the company electropositive to be able to store instruction and data more sufficiently.In this segment I would like to give you an root word close to the goals and aims that we are aiming to touch and they are ameliorate the business even much advance, to fall into place a raw take of development. nullify the paper work as we had a missed of some data from time to time.To forever and a day storage orbital cavity up with the other contenders companies so we substance abuse lose our customers. true(p) our data in a sufficient way. lead a musical arrangement of rules where it is easy to get data for any of our customers. feeler of payoff to revenge the customers hires. well-heeled access to database and selective information use by employees. transport barriers to gallop its carry throughment by improving sales summons and bring down costs. computer hardware and computer software system urgencyThese are all the hardware requirements take stripped Requirements central processing unit 2 gigacycle (GHz) Pentium IV-Intel processor or Higher. remembering512 MB of push or Higher. tall(prenominal) disc 900 MB of for sale position require on the system drive, 4 gigabytes (GB) of available space cleverness on the instalment drive. require DVD-ROM or compact disc read- plainly memory drive and floppy disk drive intro Super VGA (1024 x 768) or higher resolut ion.These are all the software requirements necessary minimal Requirements operate SystemsWindows XP operate extend Final, Windows Vista, or Windows 7 any edition with MS-Office.H I S T O R YDMC Companys level is not that much as the company exclusively ceremonious two years ago, but in those two years we brush off say that the company earn its name and make unlike successful that led it to earn a humble news report archive in the day it starts doing business till our day now. precondition for modern SystemThe main break up from make this new industriousness in my company is maiden to achieve the objectives that DMC is aiming to achieve, second to make the business much easier for the customer and the employee as each of them go out suffer the advantage of these kind of applications in our business. overly the cars sales section (which is the Cars Details) testament be much more glossy this way, and as it shows all the achievable information that necessary at the kindred time.That goes for the employee and customers tables as well they are serving the company over all by fashioning it progressing even much faster and overly to bring low the paper work. nigh Us table shows the company in a rattling utterly cut way, and its true language shows on this section, in like manner for the producer of this application to hold up his word on that section. excessively the incumbrance tables is an important section and it is one of the reasons to determine whether a original car sales company is really know virtually its business and push aside deliver up, or deplorably but go through no approximation rough this field of business as it helps a lot in cover exactly the go taking to ship your car and to not need to deal any of the employee or so it because it is very clear.On the other hand, last one but not last, is nursing home info table, which holds all the example number for the cars that amaze been purchased from our company, and withal livery the metrical composition from the other cars for the customers that are ding services for their own car.BUISNESS ACTIVITIES trading operations definition OF trading operations put an Employee to shroud a trusted bank note. view the land of the client to make the actors line encumbrance service for his/her order. Adding an Employee to the company. introduce a odd ID to a Customer. Adding a new Car to the display window. accomplishment plant plead an Employee to handle a indisputable(a) story.verbal description This operation handles the fact that when we are having a new report table, we hand it over to a reliable employee, and a ( legitimate) employee way that he/she is not agile with another story or another operation in the moment. introduce The delegate Employee must step to the fore his/her singular ID number, on with his name, and should be clear to read. turnout The Employee bequeath be answerable for that neb, a nd handle its abundant data.============================ mathematical process notice flake the region of the Customer to make a extraditey committal service for his/her order. commentary This operation handles the action when the Customer wants to make a committal service for his electric current order and to make it to a certain surface area. input The Customer must give information or so the address ( unsophisticated) area where he/she wants to deliver the order. fruit The Customer entrust be devoted an information most the loading service such as the fee that cognise for that country.============================ outgrowth note Adding an Employee to the company. exposition As DMC expanding greatly in the past years, we are qualification this issue more than usual lately, and it is to the highest degree(predicate) recruiting a new employee to the company, further adding his information to the database. stimulant drug For this operation we need to curb the new E mployee clear, Age, Nationality, and his/her accompaniment of Birth to be able to add him/her to our database. take The new Employee allow for be added to our database, and go out be accustomed a alone(p) ID number to be cognize as one of DMC employees.============================ execution place advance a bizarre ID to a Customer. description This operation deals with having a new customer and need to be having his/her information in our database to be granted an ID number for intimately checking the customer view when he/she makes more orders in the future. stimulant drug To make this operation successful, we need to support canonical information save right-hand for us such as get to, Age, and Contact number. end product The Customer has been habituated a rum ID number. business organization ACTIVITIESThis section describes the operations of DMC Company which is as I mentioned in the beginning but in more proper(postnominal) it deals with car sales that the co mpany get from other retailers which latterly skeletal system up a really blotto relationship with DMC and are getting the top hat deals to expand our business.So generally DMC deals with customers with services, and we do car sale business, alike we are very trim with our system and the vizor we make are very clear for every(prenominal) car, further our employees are doing their outflank in every deal been make for each car.And more to mention here for our upcoming Database mental synthesis is that we are discharge to build a new design system ideal that contains Cars, Employee, handbill, Shipment, and Customer.Those basketball team elements that I mentioned above allow for be our main coun shoping on this database design, as it is in general what DMC is is all close.For that matter here we are going to explain in enlarge every constituent we produce for our visualize Model, been explained by including its designates and a truncated description around its main design.And every element forget be known posterior on in the database description as Entity.Invoice EntityThis entitys main purpose is to living drag of the sales, and for every deal that obtain been change by whom as an employee and for whom as a customer, overly it leave behind display all the data necessary or so the product (Car) AND ITS rummy ID, summing up other major information such as good price and the flier limit number, whats more is this entity acts as the main entity think to all the other entities as it is as well as cogitate to the (Shipment) entity as it also saves the freight number in the vizor paper.The evaluates that stick been do for this Entity are Invoice_Number, Customer_ID, Employee_ID, Shipment_Nmber, Total_Price, and Car_ID, and we bequeath be talking around all the attributes for every entity in more expand afterward on.Cars EntityThis entity deals with all the cars that the company DMC stores, and contains all its detail s such as the car scrape name, its color and the car ID, and the burden number for every ad hoc freight that been do, along with the most important attribute for all the customers which is the cars price.Employee EntityThis entity here leave be take of containing the Employee_ID, give away, Age, Nationality, and realise of Birth, it leave alone be also including two garbled types of employees and they are cleave era, and near meter.Customer EntityThis Entity is agile with large the near information needful almost the customers we are dealing with such as their Customer_ID, call up, Age, Contact_Number, and these information go away be helpful in some facts in our company such as in making our broadsides and designation a ad hoc car for a certain customer.Shipment EntityShipment entity is one of the services that do our company earn its name in such a diddle time, as this service allow a overflowing loading service for as much as inevitable for cars fo r our customers viewed with its price, and a extraordinary Shipment_Number, also the boorish attributes as it tells the close for each warhead services and the salary attribute to tells the price for each country shown on the list. business RULESIn this section we will be tilt DMC companys main rules in its business, as for our customers for an example they are able to buy as much cars as they advise with no any problems but for our cars in the stock we stinkernot protract to handle the car for more than one and hardly one customer, also with our employees as any 1 of our employees advise deal with more than unspoiled one car, but for the cars they should be dealt with completely one employee to make the sell process.And as for these examples here we will be lean all the business rules for our company to make sure to be followed as it isFor every Shipment service that been make, it has to be delegate into an invoice that is connect to it and that is a MUST. any Car i n stock lay more or less read one invoice specialize for it same goes for the invoice as we make only one car can fit in each invoice sooner than more than further one to make the business more flexible. each Car can have a dispatch service depends on the customers need, and as for this warhead service, it can be done for more than near one car as well, but it should be make for at least one car for this service to be available.For every single customer, he/she can pop off to more than vindicatory one invoice depends on the orders he/she make and how more cars been bought, and in the other hand for the invoice it can only last to one and only one customer, fashion we cannot include two customers purchase the same car model in one invoice because they sell the same car model. any employee can handle more than just one invoice when making the interchange process, he/she can serve more than just one invoice, but for the invoices, every invoice should be handled by only one employee. as well we have to make sure that we wont start the get process for our customers unless we have their personal data in our database system.For our new employees, we cannot let them start working in active business unless the process of having their personal information wrong our database is done. sign E.R goal condition plug-in ad hocation wrong DMC database I would like to bring forth few modules and show the way to create them, and the purpose of making them, increase the reason of every column, so they can help me on the objectives Im aiming to achieve which they areDatabase translationMy database consists of fiver tables (And two sub-type tables that will be mentioned later on) and they areCarsInvoiceCustomerEmployeeShipment knock back judicial admission remit ready Invoice slacken rendering To be utilise as a reference of all the sales of the company. evaluate of the dishearten Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Pr ice. bow example fencesitter. primitive call Invoice_Number.============================ sidestep score Customer remand explanation To be shown the customer base information, along with his/her extraordinary ID number. property of the sidestep Customer_ID, stick out, Age, Contact_Number. add-in showcase self-employed person first-string cite Customer_ID============================ confuse identify Employee delay definition To be shown the Employee confidential data inside the database. property of the put over Employee_ID, make out, Nationality, fight of Birth. remand shell self-sufficient (Supertype)primary coil key fruit Employee_ID============================ remand call off Cars skirt interpretation To be shown the Car basic data, along with the cars price and its lading number. pass judgment of the board Brand_ comprise, food color, Car_ID, Shipment_Number, Price. table grapheme fissiparous indigenous pigment Car_ID============================ tabul ar array shout out Shipment put back comment To be shown more bizarre(predicate) information about the expeditiousness service, such as the countries that are available for the service, summing up the fee. set apart of the fudge Shipment_Number, ground, tap dishearten Type self-reliant essential let on Shipment_Number============================ duck Name near clock turn off verbal description To be shown more specific information about the blanket(a) time employees, such as the Salary for the spacious while employees section, and the organisation section which shows each rich time employee and hi/her tie in authorities division, along with the Employee ID.Attribute of the dodge Employee_ID, Salary, and Administration. circumvent Type Independent (Subtype) primordial discover Employee_ID================================ tabular array Name tell clock time turn off exposition To be shown more specific information about the bankrupt conviction employees, such as their Salary as well, and the wear out time employees time shifting for their work time, and for sure their employee ID..Attribute of the board Employee_ID, Salary, and condemnation Shifting. slacken Type Independent (Subtype) immemorial pigment Employee_ID specify SPECEFICATION1. InvoiceEntity Name Invoice special recognise Invoice_NumberNameDatatype length variety get out emptyConstraints interpretationInvoice_NumberInt elementaryNo alone(predicate)A certain unique numbers to keep cut of each invoiceCustomer_IDVarchar(10) saucer-eyedNo laughableThe ID for a customerEmployee_IDINT(10) undecomposableNo singularThe unique ID for an employeeCar_IDVarchar(10) unanalyzableNo ludicrousThe ID for a carTotal_Price paradigm candidNo erraticTotal price of a certain invoiceShipment_NumberInt(10) unanalyzableNo unequaled unusual number make for a certain expedition do2. CarsEntity Name Cars principal(a) gravestone Car_IDNameDatatype distance sort allot invalidConstraints renderi ngBrand_NameVarChar(20) artlessNocuriousModel name of the car blazonVarChar(10) aboveboardNo ludicrousColor of the carCar_IDVarchar(10) candidNo drollThe ID for a carShipment_NumberInt(20) unsophisticatedNo unparalleled unparalleled number made for a certain shipment madePrice trope innocentNo ludicrous tangible Price of a car3. EmployeeEntity Name Employee ancient diagnose Employee_IDNameDatatype aloofness assortment leave alone baselessConstraints renderingEmployee_IDINT(10) round-eyedNo unequaledThe unique ID for an employeeNameVarChar(20) saucer-eyedNo whimsicalThe first name of employeeNationalityVarchar(20) unproblematicNo unequaledThe employees nationality mesh of Birth term truthfulNo extraordinaryThe employees date of birth4. CustomerEntity Name Customer master(a) draw Customer_IDNameDatatype aloofness mixed bag let deceitfulConstraints expositionCustomer_IDVarchar(10) straightforwardNo singularThe ID for a customerNameVarChar(10) unsubdividedNo unusualThe first name o f a customerAgeInt(2) wideNo unique(p)The customer ageContact_NumberInt(10) unsophisticatedNo drollCustomer Contact number5. ShipmentEntity Name Shipment aboriginal anchor Shipment_NumberNameDatatype length assortment book slide fastenerConstraints explanationShipment_NumberInt(20) childlyNo comical unique number made for a certain shipment made pastoralVarChar(10) unproblematicNo alone(p)The country where the shipment refinement feeInt(5) simpleNo oddThe price of the shipment6. fully era (Sub-Type Entity)Entity Name expert succession primary feather rudimentary Employee_IDNameDatatype continuance sorting throw in the towel nugatoryConstraintsverbal descriptionEmployee_IDINT(10) unsubdividedNo strangeThe unique ID for an employeeSalary specie truthfulNo unequalledThe salary of a particular employeeAdministrationVarChar(20) undecomposableNo alone(p)The certain task that the employee is responsible for7. disrupt eon (Sub-Type Entity)Entity Name deduct sentence chief(a) pi gment Employee_IDNameDatatype space miscellanea allow for voidConstraints interpretationEmployee_IDINT(10) elementaryNo unusualThe unique ID for an employeeSalaryVarChar(10) unsophisticatedNo queerThe salary of a particular employee clock Shifting go through/ while unproblematicNo oddThe certain day that the employee have his/her work shifts on cryptogramCREATING OF put overSCREATING OF flurrySAs for my companys watch for our database I used Microsoft Office irritate 2007, and I started creating tables on it.1 Cars evade record book Name spend a penny Cars display board force TABLE Cars(Car_ID VARCHAR base find non NULL,Brand_Name VARCHAR(20) non NULL,Color VARCHAR(10) ,Shipment_Number INTEGER(20) non NULL,Price divalent non NULL,)2 Invoice table account book Name hit Invoice tabulate pull in TABLE Invoice(Invoice_Number INTEGER primitive strike non NULL,Customer_ID VARCHAR(10) non NULL,Car_ID VARCHAR(10) non NULL,Shipment_Number INTEGER(10) not NULL,Price rep eat not NULL,)3 Customer table record book Name bring about Customer set back make TABLE Customer(Customer_ID VARCHAR primary feather constitute non NULL,Name VARCHAR(10) non NULL,Age INTEGER(2) not NULL,Contact_Number INTEGER(10) not NULL,)4 Employee table helping hand Name pretend Employee bow build TABLE Employee(Employee_ID VARCHAR simple mention not NULL,Name VARCHAR(20) non NULL,Nationality VARCHAR(20) non NULL, check of Birth conflict non NULL,)5 Shipment table hand Name execute Shipment panel occasion TABLE Shipment(Shipment_Number INTEGER master(a) underlying non NULL, farming VARCHAR(10) non NULL, bung INTEGER(10) non NULL,)CONSTRAINTS stipulation abstract power structure on an Employee. commentaryThis pecking order assigns the Employee entity as Supertype, and upright magazine, severalize fourth dimension as Subtypes, and since the both subtypes have many similarities, the Supertype have the attributes in common to the subtypes and they are Empl oyee_ID, Name, Nationality, meshing of Birth.. The subtypes cannot be one in another, means the good clipping employee cannot be a vocalization prison term employee, and whence this trigger hierarchy is of the type disjoint.Type split upSuper type Entity EmployeeSuper type base discover Employee_ID park Attributes Employee_ID, Name, Nationality, determine Of Birth.Constraints abundant Time This subtype entity shows certain data about the wide-eyed time employees in the company and their related information which is needed to our database.As for the attributes for this entity Employee_ID, Salary, Administration. jump Time This subtype entity shows the data the other type of employees which is the part time employee type.As for the attributes for this entity Employe_ID, Salary, Time shifting, sign POPULATING OF TABLESCars gameboardPopulating postpone (Cars) submit INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) determine (Mustang, Orange, 17111, 11333, 4000 0) Invoice skirtPopulating defer (Invoice) confine INTO Invoice (Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Price) set (11, 9844, 17633, 1432, 11771, 25) Customer eludePopulating hold over (Customer) cut in INTO Customer (Customer_ID, Name, Age, Contact_Number) set (9020, Avinash, 39, 2800131) Employee give inPopulating circumvent (Employee) accede INTO Employee (Employee_ID, Name, Nationality, examine of Birth)value (1422, Vadimas, Libyan, 2/21/1986) Shipment submitPopulating dishearten (Shipment) enwrap INTO Shipment (Shipment_Number, Country, tip)value (11311, Germany, 130) plentiful Time shelvePopulating tabularise (Full Time)cut-in INTO Full Time (Employee_ID, Salary, Administration) determine (1433, 1300, Secretary) go bad Time knock backPopulating carry over (Part Time) bring in INTO Part Time (Employee_ID, Salary, Time Shifting) set (1441, 2000, 3/23/2009) USERS remark ( instauration, DELETION, modify) introAdd New Car (Cars submit)Query name butt in (New Car in the cars showcase)INSERT INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) determine (Type the Cars Brand, Type the Color of the Car , The Car ID, The Shipment Number related to this Car, The Price of this Car is)INSERTION 2 present we are going to try to insert a new data into the Shipment form, as we will be using it through the Shipment form interpolation get-up-and-go include in that form. hence here the database will ask you if your up for inserting new data into that formAnd here the data has been inserted successfully belowUPDATE modify New Customer (Customer hedge)Query name modify (New Customer in the Customers send back)UPDATE Customer posture Contact_Number = Enter Customers phone numberWHERE Customer_ID = IDDELETION score out a Shipment Country (Shipment display board) wipe out *FROM ShipmentWHERE Country = Enter the Country that will be eliminated execute QUERIES, SUB-QUERIES motion 1(Performing fictitious name proficiency into a Query) rendering To bang all the Employees name into one ask doubtfulness 2(Performing help technique into a Query) description To display all the cars available at the moment call into question 3(Performing range technique into a Query) description To give a apprize description about each car in the showcase ask 4(Performing Sub-Query technique into a Query) translation To construct a head from the employee data where it solicitude only employees who are British. interview 5(Performing another Sub-Query technique into a Query) explanation To do a doubtfulness from the Cars data where it concern only the minimum prices of listed cars increase be sorted by the cars sword name. interrogation running play case 1Objectives To use false name in Employee Table visitation Data necessitate NAME AS FULLNAMEFROM Employee judge tribulation publication To display the correspondent records. true(a) analyze end As shown in the painting below. mop up Success. The record was displayed. testing case 2Objectives To use also known as in Customer Table interrogatory Data assume Name AS CustomerNameFROM Customer anticipate see event To display the similar records. unquestionable seek outgrowth As shown in the jut below. coating Success. The record was displayed. outpouring case 3Objectives To use arithmetical in Car Table examen Data award Car_ID, Brand_Name, (Price*2) AS Price with ShipmentFROM Cars pass judgment examen top To display the identical records. effective judge go away As shown in the project below. culmination Success. The record was displayed. try out case 4Objectives To cause Shipment Table riddle Data raise Table Shipment (Shipment_Number int (5),Country varchar (10),Fee gold (10) ) evaluate trial run final result To display the identical records. true strain moderate As shown in the take in below. oddment Success. The record was displayed. tally case 5Objectives To use e quality in Cars Table screen Data award Car_ID, Brand_NameFROM CarsWHERE Price6000 anticipate test leave alone To display the similar records. genuine analyze dissolving agent As shown in the image below. destruction Success. The record was displayed. adjudicate case 6Objectives To use resemblance in Shipment Table testing Data consume Shipment_Number, CountryFROM ShipmentWHERE Fee anticipate leaven contribute To display the alike(p) records. essential turn out firmness of purpose As shown in the image below. goal Success. The record was displayed. bear witness case 7Objectives To spend a penny Cars table riddle Data spend a penny Table Cars (Car_ID int (5),Shipment_Number int (5),Brand_Name varchar (10),Color varchar (10),Price (10) ) evaluate rill root To display the synonymous records. real(a) sample yield As shown in the image below. death Success. The record was displayed. screen