Recent orders
Information Systems Engineering
1. The following E-R model describes data about customers. Common data for all customers are
ID, Name, Address, and Contact including Phone and Emai. Special data for online customers
are LoginName and Password.
(a) Perform specialization to the E-R model to produce an E-R model with the superclass entity,
Customer, and a subclass entity, OnlineCustomer.
(b) Give at least one instance of the superclass and the subclass entity in part (a).
Information Systems Engineering
Instructions
Develop an E-R model to organize the following data of pharmacies including pharmacyID,
name, address, phone number, medicine inventory (including medicineID, medicine name,
medicine description, unit price, current inventory level, and minimum inventory level).