Question# 1 Draw an ER-Diagram for the given scenario. Write your assumptions in case of any. Properly mention each components of ERD. [10 M) You are required to design a database for THE MEDIX pharmacies. The requirements for the database system are: A social security number (SSN) is used to identify the patients. The name, age, gender and address of the patient must be recorded. SSN number is also used for the identification of doctors. Record the name, age, professional ID, specialty and experience years for each doctor. The database also holds the name, address and contact number for each pharmaceutical company. The trade name is used to uniquely identify the drug among the products of a particular company and a specific drug is sold by every pharmaceutical company. The database should hold the trade name and the formula for every drug. The records of all the products by any manufacturing company must be removed if the pharmaceutical company is closed or its medicines are removed from the pharmacy. Each branch of THE MEDIX pharmacy has its own name, official pharmacy ID, address and phone number. A drug has its own price which may vary from pharmacy to pharmacy and numerous drugs are sold at each pharmacy. All patients have their own basic health physicians. Every physician has a minimum of one patient to take care of. ceptable. WAT University of Management and Technology Patients are subscribed drugs by their doctors who can prescribe one or more drugs to many patients. Subscriptions can be obtained from several doctors by a patient. The prescription has a date and a drug quantity written on it. You only need to store the last prescription in case the doctor prescribes the same drug more than once to the same patient. Long term contracts are signed between the pharmacy and the pharmaceutical company. A pharmaceutical company can sign a contract with many pharmacies at a time and vice versa. For a contract you have to store the start date, end date, names of the persons who signed the contract and the text of the contract. Each contract has a supervisor who can change during the duration of the contract. This supervisor is appointed by the pharmacy itself for each contract Question# 1 Draw an ER-Diagram for the given scenario. Write your assumptions in case of any. Properly mention each components of ERD. [10 M) You are required to design a database for THE MEDIX pharmacies. The requirements for the database system are: A social security number (SSN) is used to identify the patients. The name, age, gender and address of the patient must be recorded. SSN number is also used for the identification of doctors. Record the name, age, professional ID, specialty and experience years for each doctor. The database also holds the name, address and contact number for each pharmaceutical company. The trade name is used to uniquely identify the drug among the products of a particular company and a specific drug is sold by every pharmaceutical company. The database should hold the trade name and the formula for every drug. The records of all the products by any manufacturing company must be removed if the pharmaceutical company is closed or its medicines are removed from the pharmacy. Each branch of THE MEDIX pharmacy has its own name, official pharmacy ID, address and phone number. A drug has its own price which may vary from pharmacy to pharmacy and numerous drugs are sold at each pharmacy. All patients have their own basic health physicians. Every physician has a minimum of one patient to take care of. ceptable. WAT University of Management and Technology Patients are subscribed drugs by their doctors who can prescribe one or more drugs to many patients. Subscriptions can be obtained from several doctors by a patient. The prescription has a date and a drug quantity written on it. You only need to store the last prescription in case the doctor prescribes the same drug more than once to the same patient. Long term contracts are signed between the pharmacy and the pharmaceutical company. A pharmaceutical company can sign a contract with many pharmacies at a time and vice versa. For a contract you have to store the start date, end date, names of the persons who signed the contract and the text of the contract. Each contract has a supervisor who can change during the duration of the contract. This supervisor is appointed by the pharmacy itself for each contract