This is a Hospital Care Management Database Like first start with 1.First normal

Question

This is a Hospital Care Management Database

Like first start with

1.First normal Form

2.Second normal Form

3.Third Normal Form

Arrange them in this step by step process

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

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.