Use the relational schema and functional dependencies (FDs) in Figure 1 to answer the following questions....

 

Transcribed Image Text:

Use the relational schema and functional dependencies (FDs) in Figure 1 to answer the following questions. Figure 1. Hospitel_Patient = (hospital_name, hospital_district, hospital_province, hotel_name. hotel_district, hotel_province, patient_name, citizen_id. patient_app_id, admitted_date, check_out_date, symptom_code) hospital_name →→ hospital_destrict, hospital_province hotel_name → hotel district, hotel_province, hospital_name, hospital_destrict, hospital_province citizen_id →→ patient_name, patient_app_id patient app_id→→ citizen_id, patient_name Remark: All explicit (but not implicit) functional dependencies are given. a. Use the definition of the 2nd normal form to perform normalization on the relational schema and FDs in Figure 1. In addition, specify which functional dependency (ies) violates each normal form which causes normalization (if any). Also specify the foreign key constraints (if any) in the decomposed relations. b. Use the definition of the 3rd normal form to perform normalization on the relational schema and FDs in Figure 1. In addition, specify which functional dependency (ies) violates each normal form which causes normalization (if any). Also specify the foreign key constraints (if any) in the decomposed relations. c. Use the definition of Boyce-Codd normal form to perform normalization on the relational schema and FDs in Figure 1. In addition, specify which functional dependency (ies) violates each normal form which causes normalization (if any). Also specify the foreign key constraints (if any) in the decomposed relations. Use the relational schema and functional dependencies (FDs) in Figure 1 to answer the following questions. Figure 1. Hospitel_Patient = (hospital_name, hospital_district, hospital_province, hotel_name. hotel_district, hotel_province, patient_name, citizen_id. patient_app_id, admitted_date, check_out_date, symptom_code) hospital_name →→ hospital_destrict, hospital_province hotel_name → hotel district, hotel_province, hospital_name, hospital_destrict, hospital_province citizen_id →→ patient_name, patient_app_id patient app_id→→ citizen_id, patient_name Remark: All explicit (but not implicit) functional dependencies are given. a. Use the definition of the 2nd normal form to perform normalization on the relational schema and FDs in Figure 1. In addition, specify which functional dependency (ies) violates each normal form which causes normalization (if any). Also specify the foreign key constraints (if any) in the decomposed relations. b. Use the definition of the 3rd normal form to perform normalization on the relational schema and FDs in Figure 1. In addition, specify which functional dependency (ies) violates each normal form which causes normalization (if any). Also specify the foreign key constraints (if any) in the decomposed relations. c. Use the definition of Boyce-Codd normal form to perform normalization on the relational schema and FDs in Figure 1. In addition, specify which functional dependency (ies) violates each normal form which causes normalization (if any). Also specify the foreign key constraints (if any) in the decomposed relations.

Answer rating: 100% (QA)

STEP 1 Answer Here is the required answer with brief explanation for all the three PARTS Given table HospitelPatient hospital district hoteldistrict hotelprovince citizen id patientappid checkoutdate ... View the full answer