Can you please help me with database question:

Based on the description in question a, Draw the dependency diagram of DOC_DRUG_PRES system highlighting Partial Dependency, Transitive Dependency, and Full Dependency in 1NF (also highlighted in yellow)

a) A given doctor is treating many patients, and may prescribe a list of drugs to his patient. A patient could be treated by many doctors depending on the diagnostic. The doctors cannot prescribe any drug which is not listed in the list of drugs Moreover, the system assumes that each doctor is affected to one hospital which might employ many physician doctors. We call the Unnormalized table as DOC DRUG PRES Enumerate all Business Rules of DOC DRUG PRES . What is the type of Relationship between doctor and patient entity sets? . Edit the instance of data of the Unnormalized table DOC DRUG PRES using data of yours. Notice and determine the composite primary key (candidate key) of DOC DRUG PRES table. Hint: See the CK in Bold Draw the dependency diagram of DOC_DRUG PRES system highlighting Partial Dependency, Transitive Dependency, and Full Dependency in INF Define the corresponding tables in 2NF . Define the corresponding tables in 3NF Draw the entity relationship E-R Diagram of the above system. b) Create the Entity-Relationship Diagram for the above tables derived from 3NF, include the cardinality. a) A given doctor is treating many patients, and may prescribe a list of drugs to his patient. A patient could be treated by many doctors depending on the diagnostic. The doctors cannot prescribe any drug which is not listed in the list of drugs Moreover, the system assumes that each doctor is affected to one hospital which might employ many physician doctors. We call the Unnormalized table as DOC DRUG PRES Enumerate all Business Rules of DOC DRUG PRES . What is the type of Relationship between doctor and patient entity sets? . Edit the instance of data of the Unnormalized table DOC DRUG PRES using data of yours. Notice and determine the composite primary key (candidate key) of DOC DRUG PRES table. Hint: See the CK in Bold Draw the dependency diagram of DOC_DRUG PRES system highlighting Partial Dependency, Transitive Dependency, and Full Dependency in INF Define the corresponding tables in 2NF . Define the corresponding tables in 3NF Draw the entity relationship E-R Diagram of the above system. b) Create the Entity-Relationship Diagram for the above tables derived from 3NF, include the cardinality