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 EntityRelationship 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 :
UPS prides itself on having uptodate information on the processing and current location of
each shipped item. To do this, UPS relies on a companywide 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 ie flights, truck deliveries
These transportation events are characterized by a unique schedule Number, a type eg flight,
truck
Insert your ERD here.
Part :
Carinsurance 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 :
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
