3. Proceed with formal normalizatio Doctor Prescription of Drug System. n form to show all required steps to normalize the following treating many patients, and may prescribe a list of drugs patient. A patient could be treated by many doctors dependi loreover, the system assumes that each doctor might employ many physician doctors. doctors cannot prescribe any drug which is not listed in the list of drugs to his on the diagnostic. is affected to one hospital which 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 . Define the corresponding tables in 2NIF . Draw the entity relationship E-R Diagram of the above system. Dependency, Transitive Dependency, and Full Dependency in INF Define the corresponding tables in 3NF b) Create the Entity-Relationship Diagram for the above tables derived from 3NF Proceed with formal normalization form to show all required steps to normalize the following a) A given passenger might book flight from different air-line companies. The system include the cardinality. 4. Flight Ticket Reservation System. will register all flights for all airliners, their available seats of different service classes (business, economy class) along with their corresponding prices. Then, passenger should be able to get a bill for her flight reservation showing her the price and seat number. We call the Unnormalized table as FLIGHTRESERVATION Enumerate all Business Rules of FLIGHTRESERVATION What is the type of Relationship between passenger and flight entity sets? Edit the instance of data of the Unnormalized table FLIGHTRESERVATION using data of yours . . Notice and determine the composite primary key (candidate key) of . Draw the dependency diagram of FLIGHTRESERVATION system highlighting . Define the corresponding tables in 2NF. e Draw the entity relationship E-R Diagram of the above system. FLIGHTRESERVATION table Partial Dependency, Transitive Dependency, and Full Dependency in INF Define the corresponding tables in 3NF c) Create the Entity-Relationship Diagram for the above tables derived from 3NF, include the cardinality 3. Proceed with formal normalizatio Doctor Prescription of Drug System. n form to show all required steps to normalize the following treating many patients, and may prescribe a list of drugs patient. A patient could be treated by many doctors dependi loreover, the system assumes that each doctor might employ many physician doctors. doctors cannot prescribe any drug which is not listed in the list of drugs to his on the diagnostic. is affected to one hospital which 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 . Define the corresponding tables in 2NIF . Draw the entity relationship E-R Diagram of the above system. Dependency, Transitive Dependency, and Full Dependency in INF Define the corresponding tables in 3NF b) Create the Entity-Relationship Diagram for the above tables derived from 3NF Proceed with formal normalization form to show all required steps to normalize the following a) A given passenger might book flight from different air-line companies. The system include the cardinality. 4. Flight Ticket Reservation System. will register all flights for all airliners, their available seats of different service classes (business, economy class) along with their corresponding prices. Then, passenger should be able to get a bill for her flight reservation showing her the price and seat number. We call the Unnormalized table as FLIGHTRESERVATION Enumerate all Business Rules of FLIGHTRESERVATION What is the type of Relationship between passenger and flight entity sets? Edit the instance of data of the Unnormalized table FLIGHTRESERVATION using data of yours . . Notice and determine the composite primary key (candidate key) of . Draw the dependency diagram of FLIGHTRESERVATION system highlighting . Define the corresponding tables in 2NF. e Draw the entity relationship E-R Diagram of the above system. FLIGHTRESERVATION table Partial Dependency, Transitive Dependency, and Full Dependency in INF Define the corresponding tables in 3NF c) Create the Entity-Relationship Diagram for the above tables derived from 3NF, include the cardinality