2.
A vaccine manufacturing company prides itself on having up-to-date
information on the manufacturing, storage and shipping of vaccines. To do this,
the company relies on a company-wide information system. The shipped units
of vaccines can be characterized by V_No. (unique), V_name, Vol_dose,
shipping_location, price, and delivery date. The shipped vaccines are received
at a hospital. The hospital is characterized by their type, Hosp_ID, and address.
These vaccines are distributed to the vaccination centres via one or more
transportation events such as flights, truck deliveries, and vans. These
transportation modes are characterized by a unique Schedule_number, type
(flight, truck, van), and a delivery_Route.
Create an Entity Relationship diagram that captures this information about the
vaccine manufacturing company. Be certain to indicate identifiers and
cardinality constraints.
Also answer the following questions.
identify an attribute in the above ER diagram that might represent a
composite attribute and why it is a composite attribute.
identify an attribute in the ER diagram that could represent a derived
attribute and why it is a derived attribute?
Answers
Answered by
0
Answer:
temperatures recommended by vaccine manufacturers ... vaccines can be stored at refrigerator temperature between. 35°F and ... name and contact information of the person or company.
I hope this will help you
Similar questions