Relationship Diagram (ERD) for the following scenario Essay

A sales rep may oversee numerous other salesmen. A salesman is overseen by only one sales reps. A sales rep can be a specialist for some clients. A client is overseen by one sales reps. A client can put in numerous requests. A request can be set by one client. A request records many stock things. At the point when the request is made for number of stock things, the date and the sum is recorded. A stock thing might be recorded on numerous requests. A stock thing is gathered from numerous parts. A section might be amassed into many stock things. Numerous representatives collect a stock thing from numerous parts. While the worker amass, if any deficiency, it is related to blame log-id, flaw log-name. A provider supplies numerous parts. A section might be provided by numerous providers. Draw the Entity-Relationship Diagram (ERD) for the accompanying situation: UPS highly esteems having exceptional data on the preparing and current area of each sent thing. To do this, UPS depends on an all inclusive data framework. Sent things are the core of the UPS item following data framework. Dispatched things can be described by thing number (one of a kind), weight, measurements, protection sum, goal, and last conveyance date. Delivered things are gotten into the UPS framework at a solitary retail place. Retail focuses are described by their sort, uniqueID, and address. Sent things advance toward their goal by means of at least one standard UPS transportation occasions (i.e., flights, truck conveyances) . These transportation occasions are portrayed by an exceptional scheduleNumber, a sort (e.g, flight, truck), and a deliveryRoute. If it's not too much trouble make an Entity Relationship graph that catches this data about the UPS framework. Be sure to demonstrate identifiers and cardinality requirements. Draw the Entity-Relationship Diagram (ERD) for the accompanying situation: The organization is composed into DEPARTMENTs. Every division has a name, number and a representative who deals with the office. We monitor the beginning date of the office administrator. An office may have a few areas. Every division Controls various PROJECTs. Each undertaking has a one of a kind name, novel number and is situated at a solitary area. We store each EMPLOYEE’s government disability number, address, pay, sex, and birthdate. Every representative works for one office however may take a shot at a few ventures. We monitor the quantity of hours out of every week that a representative as of now takes a shot at each task. We additionally monitor the immediate manager of every worker. Every representative may have various DEPENDENTs For every needy, we monitor their name, sex, birthdate, and relationship to the worker. Draw the Entity-Relationship Diagram (ERD) for the accompanying situation: A Bus Company possesses various transports. Each transport is assigned to a specific course, albeit a few courses may have a few transports. Each course goes through various towns. At least one drivers are assigned to each phase of a course, which compares to an excursion through a few or the entirety of the towns on a course. A portion of the towns have a carport where transports are kept and every one of the transports are distinguished by the enlistment number and can convey various quantities of travelers, since the vehicles differ in measure and can be single or twofold decked. Each course is recognized by a course number and data is accessible on the normal number of travelers conveyed every day for each course. Drivers have a worker number, name, address, and some of the time a phone number. Draw the Entity-Relationship Diagram (ERD) for the accompanying situation: An instructor, recognized by their number, name and room number, is liable for sorting out various course modules. Every module has a special code and furthermore a name and every module can include various speakers who convey some portion of it. A module is made out of a progression of talks and in light of financial imperatives and presence of mind, now and again address child a given theme can be a piece of more than one module. A talk hasâ a time, room and dateand is conveyed by a speaker and an instructor may convey more than one talk. Understudies, recognized by number and name, can go to addresses and an understudy must be enlisted for various modules. We likewise store the date on which the understudy initially enlisted for that module. At long last, a teacher goes about as a coach for various understudies and every understudy has only one tutor.†