Question: Hello I am having some trouble with this database question can someone please help Read the following specification of a sample database domain. hospital would

Hello I am having some trouble with this database question can someone please help

Hello I am having some trouble with this database question can someone

Read the following specification of a sample database domain. hospital would like to create a medical database with the health records patients. Information recorded in the database supposed to include a medical insurance number that identifies each patient, first name, last name, a list of admission dates to the hospital, list of illnesses cured during each admission, and a list of children. Assume, that more than one illness can be cured during each admission to the hospital. Also assume, that a child is described by the first name and a type of relation to its parent, i.e. either son or daughter. A database designer created the following relational schema. MRECORD (insurance, fname, lname,adate,illness, child,relation) Determine what the highest valid normal form a relational schema MRECORD sin ? Justify your choice. next task is to decompose the relational schema into the smallest number of relational schemas each one in 4NE and to prove that each schema is in 4NF To prove, that the relational schemas obtained from the decomposition are in 4NF you must find all functional and multivalued dependencies valid in each relational schema, you must find the minimal keys, and then apply the definitions. Note, that a relational schema is in 4NF when it is in BCNF and it does not have any nontrivial multivalued dependencies. It means, that first, you have to prove that a schema is in BCNF and later show that it has no nontrivial multivalued dependencies. Please keep in mind that smallest number of 4NF relational schemas is expected

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!