Draw e-r diagrams and state the relationship

Assignment Help Database Management System

Reference no: EM13670873

Draw E-R diagrams demonstrating each of the following relationships (create three meaningful examples for each relationship): One-to-One, One-to-many, One-to-Optional Many, Optional Many-to-One, Optional Many-to-Optional Many. Show the relationships horizontally.

For each E-R diagram, state the relationship in words (for both, the forward path and the backward path).

1052_E-R diagram.png

A. Each employee is assigned to one and only one office. Each office is occupied by one and only one employee.
B. Each cargo aircraft will serve from one to many distribution centers. Each distribution center is served by one and only one cargo aircraft.
C. One systems analyst is assigned to anywhere from zero to many projects. Each project will be developed by one and only one systems analyst.
D. One machine is undergoing anywhere from zero to one scheduled maintenance. Scheduled maintenance is being done to one and only one machine.
E. Each salesperson is assigned to anywhere from one to many customers. Each customer may have from one to many salespersons.
F. One home office has one to many employees. Each employee may be assigned from zero to one home office.
G. Each passenger is flying to many destinations. Each destination will be visited by many passengers.

Reference no: EM13670873

Questions Cloud

Find at what distance from the center of the planet : A satellite is found to be in an orbit about Planet X such that the period of the orbit matches the rotational period of the planet about its axis, namely 25.2 days. find at what distance from the center of the planet is the satellite orbiting

Obtain the distance traveled by jet as the observer watches : A jet is circling an airport control tower at a distance of 18.0 kilometer. An observer in the tower watches the jet cross in front of the moon. Obtain the distance traveled by the jet as the observer watches

Find the acceleration of object with represent to the train : A net force of 20 Newton is applied to an object of a mass 5 kilogram. Find the acceleration of the object with represent to the train

Compare the estimated acceleration of the porsche : A Porsche 914 accelerates uniformly from 0 to 60 mph in5 s. Assuming a frictionless air track and a glider mass of 550 g, find the mass M2 that one must hang from the glider

Draw e-r diagrams and state the relationship : Draw E-R diagrams demonstrating each of the following relationships (create three meaningful examples for each relationship): One-to-One, One-to-many, One-to-Optional Many, Optional Many-to-One, Optional Many-to-Optional Many

Calculate how much time does take for bike to come to rest : The wheels of a bicycle have an angular velocity of +20.0 rad/s. Then the brakes are applied. Find how much time does it take for the bike to come to rest

Obtain the distance traveled by the jet : A jet is circling an airport control tower at a distance of 18.0 kilometer. An observer in the tower watches the jet cross in front of the moon. Obtain the distance traveled by the jet as the observer watches the nose of the jet cross from one sid..

Find the velocity of his rocket relative to the earth : Captain Kirk wants to go to a distant star which is five light years away. Find the velocity of his rocket relative to the Earth therefore that the time as measured by Spock's clock is one Earth year

Find velocity of the electron as seen from laboratory frame : A radioactive nucleus travels at a velocity 0.1c. When it decays it ejects an electron which has a velocity relative to the nucleus of 0.8c. Find the velocity of the electron as seen from the laboratory frame

User Account

All Pages