Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an ER diagram based on the following user requirements for the database. Show entities, relationships, and attributes. (*l Please use the ERDPIus to create

image text in transcribed
image text in transcribed
Create an ER diagram based on the following user requirements for the database. Show entities, relationships, and attributes. (*l Please use the ERDPIus to create your ER diagram for this question. Packages-R-Us, a shipping company keep track of: . For each branch: brlocaon, unique brid . For each package: paweight, padate_shipped, padestinaon, unique patrackid. . For each employee: empname, multiple empphonenumbers, unique empid . For each tracking device: tddate_bought, tddate_serviced, tdid (tdid is unique within the branch that owns the tracking device but not across the entire Packages-R-Us company). Additional requirements: . Each employee works in one branch. Each branch has multiple employees (up to 80 of them). . Each package was shipped-out by one employee. Each employee can ship-out many packages, but does not have to ship any. . Each package was delivered by one employee. Each employee can deliver many packages, but does not have to deliver any. . Each employee can supervise many other employees, but does not have to supervise any. Each employee either has no supervisors or is supervised by one employee. . Each branch owns one or more tracking devices Each tracking device is owned by one branch . Each tracking device is assigned to exactly one employee. Each employee either has one or no tracking devices assigned to him/ her

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foodservice Management Principles And Practices

Authors: June Payne Palacio, Monica Theis

13th Edition

0133801101, 9780133801101

More Books

Students also viewed these General Management questions

Question

Are summer stipends available?

Answered: 1 week ago

Question

n = 150, d = 80 and PT= 2000 months. What is , hat{}, and SE(hat{})

Answered: 1 week ago

Question

5. Give some examples of hidden knowledge.

Answered: 1 week ago