Question: Create three Entity - Relationship diagrams based on the specification provided. Ensure that each diagram accurately represents the information from its respective specification, clearly indicating

Create three Entity-Relationship diagrams based on the specification provided. Ensure that
each diagram accurately represents the information from its respective specification, clearly
indicating identifiers and cardinality constraints.
Part 1:
UPS prides itself on having up-to-date information on the processing and current location of
each shipped item. To do this, UPS relies on a company-wide information system. Shipped
items are the heart of the UPS product tracking information system.
Shipped items can be characterized by item number (unique), destination, and delivery date.
Shipped items are received into the UPS system at a single retail center. Retail centers are
characterized by their type, uniquid, and address. Shipped items make their way to their
destination via one or more standard UPS transportation events (i.e., flights, truck deliveries).
These transportation events are characterized by a unique schedule Number, a type (e.g., flight,
truck).
Insert your ERD here.
Part 2:
Car-insurance company wants to construct ER diagram. Customers own one or more cars. Each Customer can be characterized by customer ID, name, and address. Car item is characterized by
car ID, model, year. Accident item is characterized by report number, location, date.
Insert your ERD here.
Part 3:
The Peoria animal clinic has many types of animals and the following specifications:
Every animal type is characterized by type id (unique) and type name like dog or cat.
Every animal must belong to exactly one type, but one type has many animals. Each animal
can be characterized by animal id, age, and gender.
Animals may have diseases and one disease infects many animals. If certain animal has a
disease, the beginning time and the duration of a disease need to be recorded.
A disease is characterized by a unique name.
An employee takes care of only one type of animal, but one animal type may be cared by
many employees.
An employee may or may not be familiar with diseases. But every disease must be handled
by one employee.
Employees are characterized by employee ID, name, SSN, address, and phone number.
All animals must be in a cage. One cage may occupy many animals.
Every cage is characterized by cage ID, space, and height.
Insert your ERD here.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!