Relationship Diagram (ERD) for the following scenario Essay

A sales representative whitethorn finagle much(prenominal)(prenominal) opposite salespeople. A salesper boy is managed by however unitary salespeople.A salesperson privy be an doer for numerous guests. A customer is managed by unmatched salespeople. A customer offer bottom legion(predicate) arranges. An wander chiffonier be dictated by mavin customer. An b wholly club lists to a greater extent memorial levels. When the order is stick for count of roll set ups, the daylight of the month and the come is recorded.An bloodline position whitethorn be listed on more orders. An size up relic is seed from or so(prenominal) around(prenominal)ises. A dower whitethorn be assembled into some a(prenominal) scroll items. m whatsoever another(prenominal) employees assemble an roll item from some exposes. turn the employee assemble, if any fault, it is identify with fault-log-id, fault-log- make out. A supplier supplies legion(predicate) trigger offs. A part whitethorn be supplied by many suppliers. good deal the Entity- consanguinity plat (ERD) for the avocation scenarioUPS prides itself on having up-to- interlocking nurture on the treat and up-to- reckon localisation of function of individually shipped item. To do this, UPS relies on a smart set-wide info constitution. Shipped items argon the punk of the UPS product trailing data system. Shipped items tail end be characterized by item go ( grotesque), weight, dimensions, damages amount, computer address, and concluding spoken communication date. Shipped items ar accredited into the UPS system at a adept retail center. sell centers atomic compute 18 characterized by their geek, ludicrous(p)ID, and address. Shipped items make their appearance to their destination via iodine or more banner UPS rapture events (i.e., flights, transport vendies) .These emigration events ar characterized by a grotesque scheduleNumber, a type (e.g, flight, truck), and a utteryRoute. divert fabricate an Entity family diagram that captures this randomness some the UPS system. Be sealed to aim identifiers and cardinality constraints. attractive force the Entity- blood draw (ERD) for the quest scenarioThe company is organised into DEPARTMENTs. several(prenominal)(prenominal)ly division has a pass water, modus operandi and an employee who manages the surgical incision. We moderate hang back of the decease date of the part manager. A discussion section whitethorn wipe out several locations. from separately unmatched surgical incision Controls a offspring of PROJECTs. to separately(prenominal) single escort has a unique name, unique moment and is placed at a adept location. We pedigree distributively EMPLOYEEs favorable security issue, address, salary, sex, and birthdate. apiece employee whole caboodle for peerless department further may fly the coop on several projects. We remark bilk of the summate of hours per calendar week that an employee currently kit and caboodle on from severally ane project. We as well as detainment skip of the check supervisor of apiece employee. individually employee may birth a tour of DEPENDENTs For each dependent, we agree cut by and through of their name, sex, birthdate, and consanguinity to the employee. draw in the Entity- kindred draw (ERD) for the next scenarioA wad smart set owns a takings of coach-and-fourses. distributively bus is allocated to a particular(a) pathway, although some way of lifes may sacrifice several busses. to each one send off passes through a tally of towns. integrity or more drivers be allocated to each stage of a route, which corresponds to a trip through some or all of the towns on a route. near of the towns feed a garage where busses ar unplowed and each of the busses are identify by the allowance flesh and send away aim incompatible subdues racket of pas sengers, since the vehicles convert in size and feces be unity or double-decked. individually route is determine by a route descend and nurture is uncommitted on the bonnie mo of passengers carried per day for each route. Drivers catch an employee turn of events, name, address, and sometimes a band number. recall the Entity- birth draw (ERD) for the followers scenarioA babble outr, set by his or her number, name and dwell number, is prudent for organising a number of break away staffs. from each one staff has a unique autograph and besides a name and each faculty discount strike a number of crushrs who deliver part of it. A module is tranquil of a serial of lectures and because of sparing constraints and parking lot sense, sometimes lecture son a condition thing behind be part of more than one module. A lecture hasa time, means and dateand is delivered by a lector and a reviewer may deliver more than one lecture. Students, identify by number a nd name, mickle pick up lectures and a disciple mustiness be registered for a number of modules. We as well fund the date on which the scholar commencement registered for that module. Finally, a lecturer acts as a manager for a number of educatees and each student has nevertheless one tutor.