Entity-Relationship Diagram Assignment Draw the associated E-R Diagram and signify which components need to be included to meet the defined needs. 1) The user is a director of research for a large

Entity-Relationship Diagram Assignment

Draw the associated E-R Diagram and signify which components need to be included to meet the defined needs.

1)     The user is a director of research for a large foundation. Approximately three hundred facilities are staffed by the foundation’s twelve-hundred employees. Over seventeen hundred projects are currently underway, with some three-hundred and fifty waiting to be worked on in the future.

The system is responsible for information regarding the current state of affairs only. Requests for information are:

·      List all current employees in name sequence

·      List all employees who work at a particular facility

·      Determine which facility has the most employees; which has the fewest

·      Display the names of all employees currently working on a particular project

·      Display all projects an employee is currently working on

·      Locate inactive (no employee assigned) project

·      Determine the ratio of active to inactive projects

2)     The user is responsible for all shared hardware devices in the building. Approximately five-hundred and twenty-five devices are installed in three-hundred offices. Each device can be shared by any number of users.

The system is responsible for keeping track of:

·      The office in which each device is installed

·      The date the device was installed

·      The users authorized to employ the device

·      The ten devices that have the largest number of users; and the ten witch have the fewest

·      The total number of devices currently installed

·      The average number of devices per office; the office with the most devices; and the office with the fewest

·      Users who are authorized to use devices in more than one office

·      A list of all offices without a device of some sort

3)   The user is a manager of a growing air freight service. Seven-hundred routes are traveled by some of the firm’s eight-hundred and fifty planes each day. Customer packages are assigned to a particular route. Each route is assigned to a particular plane each day.

The system is responsible for the following operations:

·      Display the plane for a given route

·      Display the route for a given plane

·      Determining how many packages are on each route, the average number of packages per route, the route with the most packages and the route with the fewest

·      Keeping track of the total number of unavailable (route assigned) and available (no route assigned) planes

·      Displaying all the packages given a customer name

·      Locating the customer for a particular package

·      Calculating the percentage of currently available planes

4) The user is a manager of a large taxi cab service. Seven hundred cabs are manned by about fourteen-hundred drivers on two shifts. The city of operation is divided into nine-hundred square areas, each consisting of a number of streets. All streets are straight and run either east/west or north/south. A street may be in more than one area. Street names are unique. Each driver is assigned to a particular cab and area when they arrive for work. The driver reports to the dispatcher by radio upon pick-up (“cab 47, in use”) and delivery of customers at their destination (“cab 47, available”). The driver also reports area changes (“cab 47, area 13”).

The system is responsible for the following operations:

·      Locating the area, given the names of two intersecting streets

·      Locating an available cab in a given area

·      Determining how many cabs are in each area, the average number of cabs per area, the area with the most cabs and the area with the fewest cabs

·      Keep track of the total “in use” and “available” cabs

·      Locating a driver given his name

·      Calculating the percentage of currently “available” cabs.

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10