Relationship Diagram (ERD) for the following scenario Essay

A salesper watchword may manage legion(predicate) other salespeople. A salesperson is managed by only integrity salespeople.A salesperson can be an agent for to a greater extent nodes. A customer is managed by hotshot salespeople. A customer can place numerous an(prenominal) recounts. An order can be placed by unmatched customer. An order lists many inventory items. When the order is made for number of inventory items, the sequence and the amount is recorded.An inventory item may be listed on many orders. An inventory item is assembled from many parts. A part may be assembled into many inventory items. Many employees assemble an inventory item from many parts. While the employee assemble, if any fault, it is identified with fault-log-id, fault-log-name. A supplier supplies many parts. A part may be supplied by many suppliers.Draw the Entity- race Diagram (ERD) for the following scenarioUPS prides itself on having up-to- learn development on the touch on and current locat ion of apiece shipped item. To do this, UPS relies on a company-wide information system. Shipped items argon the heart of the UPS product leashing information system. Shipped items can be characterized by item number ( queer), weight, dimensions, insurance amount, destination, and final delivery attend. Shipped items are received into the UPS system at a single retail center. retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck deliveries) .These transportation events are characterized by a unique scheduleNumber, a type (e.g, flight, truck), and a deliveryRoute. Please compose an Entity Relationship diagram that captures this information about the UPS system. Be certain to refer identifiers and cardinality constraints.Draw the Entity- Relationship Diagram (ERD) for the following scenarioThe company is organized into DEPARTMENTs. all(preno minal) department has a name, number and an employee who manages the department. We time lag track of the start date of the department manager. A department may have several locations. separately department Controls a number of PROJECTs. from each one project has a unique name, unique number and is located at a single location. We transshipment center each EMPLOYEEs social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects. We keep track of the number of hours per week that an employee currently works on each project. We also keep track of the direct supervisor of each employee. Each employee may have a number of DEPENDENTs For each dependent, we keep track of their name, sex, birthdate, and relationship to the employee.Draw the Entity- Relationship Diagram (ERD) for the following scenarioA four-in-hand Company owns a number of busses. Each bus is allocated to a particular(a) roadway, although some rou tes may have several busses. Each route passes through with(predicate) a number of towns. One or more drivers are allocated to each stage of a route, which corresponds to a journey through some or all of the towns on a route. Some of the towns have a garage where busses are kept and each of the busses are identified by the modification number and can carry different numbers of passengers, since the vehicles vary in size and can be single or double-decked. Each route is identified by a route number and information is obtainable on the average number of passengers carried per day for each route. Drivers have an employee number, name, address, and sometimes a telephone number.Draw the Entity- Relationship Diagram (ERD) for the following scenarioA lecturer, identified by his or her number, name and room number, is responsible for organising a number of course modules. Each module has a unique recruit and also a name and each module can view a number of lecturers who deliver part o f it. A module is quiet of a series of lectures and because of economic constraints and common sense, sometimes lecture son a given topic can be part of more than one module. A lecture hasa time, room and dateand is delivered by a lecturer and a lecturer may deliver more than one lecture. Students, identified by number and name, can attend lectures and a bookman must be registered for a number of modules. We also store the date on which the student first registered for that module. Finally, a lecturer acts as a tutor for a number of students and each student has only one tutor.