A salesperson may manage many other salespeople. A salesperson is managed by only one salespeople.
A salesperson can be an agent for many customers. A customer is managed by one salespeople. A customer can place many orders. An order can be placed by one customer. An order lists many inventory items. When the order is made for number of inventory items, the date 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- Relationship Diagram (ERD) for the following scenario:
UPS prides itself on having up-to-date information on the processing 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 product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. 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) .
The Essay on Sunken ship part
So we still have 412 passenger and crew, including 50 kids. The Bird Flu has hit the Shakelton’s ship along with its failing engine. It is going to take 10 man hours to fix, and 8 days to get to a decent port for more help and medications. Just outside of helicopter range, aircraft drop is just at least a day away, it is going to drop down experimental medications for the ships medic to administer ...
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 scenario:
The company is organized into DEPARTMENTs. Each department has a name, number and an employee who manages the department. 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 EMPLOYEE’s 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 scenario:
A Bus Company owns a number of busses. Each bus is allocated to a particular route, although some routes may have several busses. Each route passes through 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 registration 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 available on the average number of passengers carried per day for each route. Drivers have an employee number, name, address, and sometimes a telephone number.
The Review on Employee Engagement Sheme
Chapter 1.INTRODUCTION 1.1 Concept of employee engagement 1.1.1 Defining Engagement One of the challenges of defining engagement is the lack of a universal definition of employee engagement, as a research focus on employees’ work engagement is relatively new. More often than not, definitions of engagement include cognitive, emotional, and behavioral components. The cognitive aspect of engagement ...
Draw the Entity- Relationship Diagram (ERD) for the following scenario:
A 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 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 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 has a 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.”
