Design Assignment A pharmacy database system is keeping data about pharmacy customers, drugs, suppliers, customers' orders, purchasing orders, and medical insurance companies. For each Customer, his number, name, address, gender, and telephone numbers are stored. For each DRUG, the system keeps its code, name, expiry date, avail_quantity, and price. Drugs companies' data (suppliers) is kept by the system. For each SUPPLIER, system keeps its number, name, address, and telephone numbers. The pharmacy system generates for suppliers PURCHASING ORDERs and keeps its data in the database. For each purchasing order, the system keeps purchasing order no, purchasing order date, ordered drugs data (drug no, ordered required quantity). Each drug supplier supplies many drugs for the pharmacy. A customer may make several orders. For each ORDER, order number, date, ordered drugs data (no, name, ordered quantity, price), insurance company id, coverage percent, order subtotal, sales_tax, and order total are stored in the system. The system keeps track of each INSURANCE COMPANY, its number, name, address, telephone numbers, and credit balance. An insurance company may cover percentage of several orders total, whereas an order may be covered by only one insurance company. 

Draw the ERD before and after normalization for the conceptual design of the pharmacy database.