Database Design Based on the given model answer the followin

Database Design

Based on the given model, answer the following questions:

a) Can a pharmaceutical company have multiple phone numbers? If not,
what needs to be donw to allow this?
b) What happens to the drugs if the pharmaceutical company is deleted
from the database?
c) What happens to the drugs if the pharmacy is deleted rather than
pharmaceutical company?

phone price address name pharmacy drug tradeName formula makes takes name phone Pharmaceutical Company address

Solution

a. yes a pharmaceutical company have multiple phone numbers as it is shown as multiple valued attribute.

b. If pharmaceutical company entity is deleted from the database then the information of manufacturing drug company is missing so it is impossible to identify the drugs uniquely as drug is a week entity.

c. if pharmacy is deleted then database is not effected as price attribute can be club with the drug entity.