Create an entity-relationship diagram using conceptual data

Assignment Help Database Management System

Reference no: EM13810481

Your supervisor has asked you to create a new entity-relationship diagram for a company called Moonlight Distributors for what would be a customized shipment tracking system. Use the information below to develop the diagram.

Conceptual Model

Pickup Manifest

Customer information

Pickup details

Consignee information

Payment methods

Delivery Truck Details

Route number

Driver's name

Employee ID

Time logged out

List of delivery manifests

Delivery Manifest

Consignee information

Delivery details

Payment methods

Condition of goods delivered

Date of delivery

Consignee signature

Problems with delivery

Create an entity-relationship diagram using the conceptual data model located in the assignment description.

Reference no: EM13810481

Questions Cloud

Security percent of portfolio beta : Security Percent of portfolio Beta. Calculate the beta portfolio

Use a spreadsheet to calculate the upper and lower control : Determine a proper control chart. Use a spreadsheet to calculate the upper and lower control limits for the control chart and draw it.Suppose that the next carpet sample of 100 yards has 14 flaws. What can you say about the process?

What is the NPV of investing in the new technology : Silver Bear Golf (SBG) is a manufacturer of top quality golf clubs with a specialty of putters. Currently, each putter they sell brings in $280 of revenue at a cost of $200. This past year, they sold 900 putters and they expect this number to grow ea..

Growing concern for organisations : Sustainability is a growing concern for organisations but organisational success in this area often depends upon the conditions in their organisational environment. Discuss.

Create an entity-relationship diagram using conceptual data : Create an entity-relationship diagram using the conceptual data model located in the assignment description

A project is expected to create operating cash flows : A project is expected to create operating cash flows of $29,500 a year for three years. The initial cost of the fixed assets is $61,000. These assets will be worthless at the end of the project. An additional $4,500 of net working capital will be req..

Describe compare and critique one published quantitative : Use the library databases to identify, describe, compare, and critique one published quantitative study and one published qualitative study in a global context regarding the variables that affect employees'' organizational commitment. Provide a compa..

Fresh off excitement-investment using straight line method : Fresh off the excitement of the 2012 London Olympic Games, you decide that you want your firm to take advantage of the profits to be made for the 2016 games in Rio de Jeneiro. This $6 million is the after-tax terminal value that is in year 4 (that is..

Discuss fact-based evidence about how interest groups : Discuss fact-based evidence about how interest groups, political party loyalty, or campaign money may influence your representative. Can these influences weaken his or her effectiveness as a true "representative" of the district

User Account

All Pages