You are requested to draw the EERD diagram for the described system You are required to write down any assumptions made from your side You should add the attributes and cardinality for all the entities You are required to model the EERD into relational model
Computer Science
It is needed to design a
different items. Items may be products or medicines. Medicines are classified into different types
either bills, injection, capsule or drugs or any combination of them. An item must be supplied by
only one supplier. A supplier may supply many type of items. A customer may order many
items. The pharmacy has a unique name, address and more than one telephone.
The doctor can prescribe one or many medication, injections can not be bought without a
doctor prescription.
You are requested to draw the EERD diagram for the described system
You are required to write down any assumptions made from your side
You should add the attributes and cardinality for all the entities
You are required to model the EERD into relational model
Step by step
Solved in 2 steps with 2 images
