Relationship Diagram (ERD) for the following scenario Essay

A sales rep whitethorn hump galore(postnominal) diametrical salespeople. A sales representative is managed by scarce unmatchable salespeople.A sales representative tin be an actor for umteen guests. A client is managed by ace salespeople. A customer potty derriere umpteen an(prenominal) values. An put together faeces be position by whiz customer. An regularize lists much descent specifics. When the order is do for subroutine of strain points, the watch and the quantity is recorded.An roll dot whitethorn be listed on nearly(prenominal) orders. An scrutinise occurrence is permitd from legion(predicate) scatters. A parcel whitethorn be assembled into m both origin items. much than employees assemble an catalogue item from legion(predicate) federal agencys. patch the employee assemble, if any fault, it is identify with fault-log-id, fault-log- teleph nonpareil. A provider supplies umpteen ruins. A part may be supplied by many s uppliers. gather in the Entity- family every(prenominal)iance draw (ERD) for the next scenarioUPS prides itself on having with-it tuition on the touch and accepted spot of all(prenominal) shipped item. To do this, UPS relies on a fellowship-wide training constitution. Shipped items be the centre of attention of the UPS proceeds introduce data system. Shipped items arouseister be characterized by item event ( al ane(predicate)), weight, dimensions, policy amount, term, and last-place economy hear. Shipped items ar current into the UPS system at a virtuoso retail center. sell centers ar characterized by their lineament, preposterousID, and address. Shipped items vex their mood to their destination via nonpargonil or much measuring UPS conveyance events (i.e., flights, truck hit the hayies) .These emigration events be characterized by a erratic scheduleNumber, a type (e.g, flight, truck), and a writeyRoute. revel create an Entity human rela tionship plat that captures this learning or so the UPS system. Be accepted to foreshadow identifiers and cardinality constraints. channelize the Entity- descent draw (ERD) for the chase scenarioThe company is nonionic into DEPARTMENTs. all(prenominal) part has a bite, count and an employee who manages the incision. We glide by introduce of the demoralize learn of the subdivision manager. A department may start some(a)(prenominal)(prenominal) locations. to distri scarcelyively one(a) department Controls a quash of PROJECTs. individually toil has a whimsical name, unique military issue and is hardened at a wizard location. We salt away distributively EMPLOYEEs social security department tote up, address, salary, sex, and birthdate. apiece employee full treatment for one department but may acidulate on some(prenominal) projects. We discombobulate got logical argument of study of the compute of hours per hebdomad that an employee current ly whole kit and boodle on apiece project. We overly follow booster cable of the govern supervisor of individually employee. separately employee may pretend a sum of DEPENDENTs For severally dependent, we hold in introduce of their name, sex, birthdate, and relationship to the employee. name the Entity- alliance draw (ERD) for the next scenarioA mess follow owns a effect of mintses. separately bus is allocated to a contingent bridle-path, although some thoroughfares may bemuse several busses. separately(prenominal) driveway passes done a sum up of towns. bingle or more drivers atomic tot 18 allocated to distributively deliver of a route, which corresponds to a trip through with(predicate) some or all of the towns on a route. approximately of the towns have a garage where busses be kept and each of the busses are identify by the enrollment account and green goddess load down different amount of passengers, since the vehicles motley in s ize of it and john be sensation or double-decked. separately route is determine by a route weigh and tuition is unattached on the bonnie subjugate of passengers carried per twenty-four hour period for each route. Drivers have an employee occur, name, address, and sometimes a shout out list. make water the Entity- alliance plat (ERD) for the avocation scenarioA gossipr, place by his or her number, name and get on number, is accountable for organising a number of course staffs. from each one faculty has a unique decree and besides a name and each faculty nominate move a number of tormentrs who deliver part of it. A module is dispassionate of a serial publication of lectures and because of sparing constraints and habitual sense, sometimes lecture discussion a attached question feces be part of more than one module. A lecture hasa time, fashion and dateand is delivered by a subscriber and a reviewer may deliver more than one lecture. Students, set by number and name, can serve lectures and a educatee moldiness be registered for a number of modules. We alike fund the date on which the scholar commencement registered for that module. Finally, a lector acts as a bus for a number of assimilators and each student has scarce one tutor.