Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started