(Solved): Database systems - draw EER For the following case studies, draw an ER or EER diagram to represent t ...

For the following case studies, draw an ER or EER diagram to represent the data requirements as following: - Identify the main entity types. - Identify the main relationship types between the entity types. - Identify attributes and associate them with entity or relationship types. - Determine primary (or partial) key attributes for each entity type. - Determine the multiplicity constraints for each relationship. - Your EER diagram may or may not include features such as specialization / generalization, aggregation, and composition. - State any assumptions necessary to support your design. 1. Pharmacy information System: - There are patients that identfed by a patient 1D, patient names, addrass, date of birth and age. - Each patient has at least one of more than one prescription. - Each preserption belongs to a single patient. - A prescription indudes a prescription number, and date. - Aprescription intudes one or many medicines. - A medicire included in one of more prescriptions - For each medicine, the trade name must be recooded. There are many types of medicines: - Pewder we thould retard the Weight in grams of, - Lipuid or, - Solid we should recort tablet auantity \( \propto c_{\text {, }} \) - There are other types of medicises. - Prescription prepared by one pharmaciat. - Each pharmacist can prepares more than one prescription. Pharmacists are identified by a pharmacist iD, pharmacist names, and years of