Relationship Diagram (ERD) for the following scenario Essay

Free Essay Database Online

Relationship Diagram (ERD) for the following scenario Essay

A sales representative may pull off many other sales representative. A sales representative is managed by merely one sales representative.

A sales representative can be an agent for many clients. A client is managed by one sales representative. A client can put many orders. An order can be placed by one client. An order lists many stock list points. When the order is made for figure of stock list points. the day of the month and the sum is recorded.

An stock list point may be listed on many orders. An stock list point is assembled from many parts. A portion may be assembled into many stock list points. Many employees assemble an stock list point from many parts. While the employee assemble. if any mistake. it is identified with fault-log-id. fault-log-name. A provider supplies many parts. A portion may be supplied by many providers.

Pull the Entity- Relationship Diagram ( ERD ) for the undermentioned scenario:

UPS prides itself on holding up-to-date information on the processing and current location of each shipped point. To make this. UPS relies on a company-wide information system. Shipped points are the bosom of the UPS merchandise tracking information system. Shipped points can be characterized by point figure ( alone ) . weight. dimensions. insurance sum. finish. and concluding bringing day of the month. Shipped points are received into the UPS system at a individual retail centre. Retail centres are characterized by their type. uniqueID. and reference. Shipped points make their manner to their finish via one or more standard UPS transit events ( i. e. . flights. truck bringings ) .

These transit events are characterized by a alone scheduleNumber. a type ( e. g. flight. truck ) . and a deliveryRoute. Please make an Entity Relationship diagram that captures this information about the UPS system. Be certain to bespeak identifiers and cardinality restraints.

Pull the Entity- Relationship Diagram ( ERD ) for the undermentioned scenario:

The company is organized into DEPARTMENTs. Each section has a name. figure and an employee who manages the section. We keep path of the start day of the month of the section director. A section may hold several locations. Each section Controls a figure of PROJECTs. Each undertaking has a alone name. alone figure and is located at a individual location. We store each EMPLOYEE’s societal security figure. reference. salary. sex. and birthdate. Each employee works for one section but may work on several undertakings. We keep path of the figure of hours per hebdomad that an employee presently works on each undertaking. We besides keep path of the direct supervisor of each employee. Each employee may hold a figure of DEPENDENTs For each dependant. we keep path of their name. sex. birthdate. and relationship to the employee.

Pull the Entity- Relationship Diagram ( ERD ) for the undermentioned scenario:

A Bus Company owns a figure of coachs. Each coach is allocated to a peculiar path. although some paths may hold several coachs. Each path passes through a figure of towns. One or more drivers are allocated to each phase of a path. which corresponds to a journey through some or all of the towns on a path. Some of the towns have a garage where coachs are kept and each of the coachs are identified by the enrollment figure and can transport different Numberss of riders. since the vehicles vary in size and can be individual or double-decked. Each path is identified by a path figure and information is available on the mean figure of riders carried per twenty-four hours for each path. Drivers have an employee figure. name. reference. and sometimes a telephone figure.

Pull the Entity- Relationship Diagram ( ERD ) for the undermentioned scenario:

A lector. identified by his or her figure. name and room figure. is responsible for organizing a figure of class faculties. Each faculty has a alone codification and besides a name and each faculty can affect a figure of lectors who deliver portion of it. A faculty is composed of a series of talks and because of economic restraints and common sense. sometimes lecture boy a given subject can be portion of more than one faculty. A talk has a clip. room and dateand is delivered by a lector and a lector may present more than one talk. Students. identified by figure and name. can go to talks and a pupil must be registered for a figure of faculties. We besides store the day of the month on which the pupil foremost registered for that faculty. Finally. a lector acts as a coach for a figure of pupils and each pupil has merely one coach. ”