A. Project Description (10 degrees) A group in which the number of students - does not exceed 3 The project is comprised of a Design RDB - (lifecycle )same topic

and content (ER .Diagram and convert ER to Schema) If you use any software to draw er - .diagram, you take extra 2 grades Patients are defined by a unique identity. number, a name and a surname, and by a birth- date Doctors are defined a unique SSN, a name, a surname, and a birth-date while additionally they will be characterized by a work start date and a specialty Pharmaceutical companies will be defined by a unique name, and a telephone number Medicines will be defined by a unique. .commercial name and their active ingredient Pharmacies will be defined by a unique name,. an address and a telephone number. Additionally, you should take into account the .following Each patient has one doctor. Each doctor has at least one patient. A doctor can prescribe certain medicines to his patients Each pharmacy sells several medicines, each at a specific price Each medicine can be sold by several• pharmacies possibly at a different price Pharmaceutical companies have contracts with pharmacies Each pharmaceutical company may have. contracts with several pharmacies Each pharmacy may have contracts with several pharmaceutical companies For each contract there is a start date, an end. date, the contract contents Each pharmaceutical company manufactures.. one or more medicines Draw E-R diagram for the following. situation. Specify in the diagram the primary keys, une caramanty and participation A group in of students ot exceed 3 The project is comprised of a Design RDB - (lifecycle )same topic and content (ER .Diagram and convert ER to Schema) Due time The Project is to be submitted as - .pdf to my email by 28 of Jan (Sunday) If you use any software to draw er - .diagram, you take extra 2 grades Patients are defined by a unique identity. number, a name and a surname, and by a birth- date Doctors are defined a unique SSN, a name, a surname, and a birth-date while additionally they will be characterized by a work start date and a specialty Pharmaceutical companies will be defined by a unique name, and a telephone number Medicines will be defined by a unique. .commercial name and their active ingredient Pharmacies will be defined by a unique name,. an address and a telephone number. Additionally, you should take into account the .following Each patient has one doctor. Each doctor has at least one patient. A doctor can prescribe certain medicines to his patients Each pharmacy sells several medicines, each at a specific price Each medicine can be sold by several• pharmacies possibly at a different price Pharmaceutical companies have contracts with pharmacies Each pharmaceutical company may have. contracts with several pharmacies Each pharmacy may have contracts with several pharmaceutical companies For each contract there is a start date, an end. date, the contract contents Each pharmaceutical company manufactures.. one or more medicines Draw E-R diagram for the following. situation. Specify in the diagram the primary keys, the cardinality and participation .constraints .Conver E-R diagram to schema.