You have been provided with the requirements for a database to support a disease

tracking service. Given the rapid global spread of certain viruses, it is essential to establish a system that effectively monitors and prevent the risk of infection. Therefore, you are tasked with designing the database

infrastructure for this service to protect public health.

$1.$Instructions

$$Each User has a unique $$email$,$name$,$surname$$and $$phone$.$

$$Users are going to be Public Servant and Doctor. $$department$$of each public servant must be stored. Additionally, $$degree$($i$.$e$.$assoc$,$ prof$)$of each doctor must be stored.

$$Each Country has a unique $$cname$$and $$population$.$

$$Each Disease has a unique $$disease code$,$pathogen$($anything that can produce disease such as virus, bacterium, parasite, fungus, etc.$)$and $$description$.$

$$Each Disease Type has a unique $$id$$and a $$description$$such as infectious diseases, deficiency diseases, hereditary diseases $($including both genetic diseases and non$-$genetic hereditary diseases$),$and physiological diseases.

$$Each Protein Sequence has a unique $$protein id$$and a $$sequence$($amino acid sequence$).$

$$Each Drug has a unique $$drug id$$and $$drug name$.$

$$Each Document has a $$document no$$and $$content$.$document no$$is unique only for a given Public Servant. Each public servant may write a document with the same $$document no$.$

$$Each user has to live in exactly one country, and there could be multiple users that live in the same country.

$$Each disease is first discovered in at least one country, and there could be multiple diseases that are discovered in a country. $$First encounter date$$of each discovery must be stored

$$Public servants could create records about patients of a certain disease in a specific country. In this case, you should store the $$number of patients$,$number of deaths$,$the disease and the country that patients

are in$,$as well as information about which public servant creates this record. There could be multiple patient records in a country, and multiple countries could have patient records of the same disease. A public servant could create many of such records.

$$Doctors are specialized in at least one disease type, and there could be many doctors who are specialized in the same disease type.

$$Each disease should belong to exactly one disease type, but there could be multiple diseases of the same type.

$$A mutation in a protein sequence may cause several diseases, and disease may arise as a result of several mutations $($in protein sequences$).$A drug can cure several mutations in a protein sequence that causes disease. A mutation that causes the disease can be treated by several drugs.

$2.$Submission

$$Draw an ER diagram

Do not forget to underline primary keys of the tables and show the foreign keys.

E$.$g: Employee$($ssn$,$name$,$ lot$)$

Dept Mgr$($did$,$dname$,$ budget, ssn$,$since$)$REFERENCES Employee$($ssn$)$

$!!$Draw the ER diagram on a paper with relationships $,$ attributes and mandatory structure!!