Relationship Diagram (ERD) for the following scenario Essay

A sales rep whitethorn manage many other salespeople. A salesperson is managed by only iodine salespeople.A salesperson outhouse be an agent for many customers. A customer is managed by one salespeople. A customer chiffonier place many orders. An order can be placed by one customer. An order lists many stock items. When the order is made for outcome of inventory items, the construe and the amount is recorded.An inventory item may be listed on many orders. An inventory item is assembled from many bursts. A part may be assembled into many inventory items. Many employees assemble an inventory item from many parts. patch the employee assemble, if any fault, it is place with fault-log-id, fault-log-name. A supplier supplies many parts. A part may be supplied by many suppliers.Draw the Entity- affinity plat (ERD) for the following(a) scenarioUPS prides itself on having up-to- get a line information on the bear on and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS carrefour tracking information system. Shipped items can be characterized by item frame (unique), weight, dimensions, insurance amount, destination, and final economy date. Shipped items are received into the UPS system at a iodin 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 transport 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 create an Entity Relationship diagram that captures this information about the UPS system. Be certain to indicate identifiers and cardinality constraints.Draw the Entity- Relationship Diagram (ERD) for the following scenarioThe company is organized into DEPARTMENTs. each department has a name, number and an employee who manages the d epartment. We keep track of the start date of the department manager. A department may have several locations. Each department Controls a number of PROJECTs. Each project has a unique name, unique number and is located at a single location. We store each EMPLOYEEs social security number, address, salary, sex, and birthdate. Each employee whole caboodle for one department besides 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 Bus Company owns a number of busses. Each bus is allocated to a crabby route, although virtually routes may have several busses. Each route passes through a number of towns. mavin or more drivers are alloca ted 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 unplowed and each of the busses are identified by the registration number and can carry different metrical composition 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 available on the average number of passengers carried per sidereal 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 subscriber, identified by his or her number, name and room number, is responsible for organising a number of course modules. Each module has a unique code and also a name and each module can involve a number of lecturers who deliver part of it. A module is composed of a serial publication of lectures and because of economic constrain ts 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 student 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.