Hospital care management database Arrange the tables are in 3rd normal form . Ar
ID: 3690508 • Letter: H
Question
Hospital care management database
Arrange the tables are in 3rd normal form . Arrange the tables in 3rd Normal form in a step by step process.
Like first start with
1.First normal Form
2.Second normal Form
3.Third Normal Form
Arrange them in this step by step process
The below are the tables:-
Hospital Table:
S.no
Hospital_ID
Hospital_Name
Address_1
Address_2
City
State
Country
Contact
Doctor Table:
S.no
Doctor_ID
Doctor_name
Doc_Specialization_code
Patient Table:
S.no
Patient_ID
Patient_name
Address_1
Address_2
City
State
Patient_type
Visits Table:
S.no
Visit_ID
Visit_date
Hospital_ID
Doctor_ID
Patient_ID
Doc_specia
lization_code
Patient_type
Patient_Type Table:
S.no
Patient_Type
Type_Description
Doc_Specialization Table:
S.no
Doc_Specialization_code
Specialization_Description
Review data model to make sure data model is in at least 3rd normal form (as defined by the normalization process).
S.no
Hospital_ID
Hospital_Name
Address_1
Address_2
City
State
Country
Contact
Patien Hospital Patient ID (PK) Patient Type(FK) VARCHAR(50) Patient _name Address Address_2 Ci State Contact eger(10 Hospital _ID (PK) Hospital_name VARCHAR(70) Address Address 2 City State Country Contact eger(10 VARCHAR(60) VARCHAR(60) VARCHAR(50) VARCHAR(70) VARCHAR(70) VARCHAR(70) VARCHAR(60 VARCHAR(60 VARCHAR(50 VARCHAR(70 eger(10 eger (10 is Visit ID(PK) Visit Date Hospital_ID(FK) Doctor_ID (FK) Patient ID(FK) Doc_Specialization_code(FK)VARCHAR(50 Patient Type eger(10 DATE eger(10 nteger (10) nteger(10) VARCHAR(50 Patient Type Patient Type (PK) VARCHAR(50) Type_DescriptionVARCHAR(70) or Doctor ID(PK) Doctor Name Doc Specialzation_code(FK)VARCHAR(50) eger (10 VARCHAR(50) Doc Specialization Doc Specialization_code(PK) VARCHAR(50) Specialisation_Description VARCHAR(50)Explanation / Answer
first normal form: no two Rows of data must contain repeating group of information i.e each set of column must have a unique value
second normal form:Second Normal Form there must not be any partial dependency of any column on primary key
third normal form:it applies that every non-prime attribute of table must be dependent on primary key
hospital:
hospitalid name address are in one tabel
addrees table will have address city state
doctor:it is in 3rd NF
patient:patient id,name,type,address are in one table
remain are in another table
patient type and visit table are comes under the seperate tables have the common one field with before tables.so there is no transitive dependency
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.