Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what is normalization and tell us why it is 3NF? this is all the list of my tables according to this tell me what is

what is normalization and tell us why it is 3NF?

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

this is all the list of my tables according to this tell me what is normalization and why it is 3NF

and i want unique answer please

Data Tables: 1. Administrator Table: Fields Data Type int(5) Varchar(20) gender Varchar(10) a id Relationships Primary Key Not Null Not Null a name 2. Doctor Table: Fields Doctor id Doctor name Dept a id Data Type int(5) Varchar(15) Varchar(15) Int(5) Relationships Primary Key Not Null Not Null Foreign Key 3. Staff Table: Fields s name s id Data Type Varchar(15) Int(5) Int(12) Int(5) Int(5) Relationships Not Null Primary Key Not Null Not Null Foreign Key NID salary a id 4. Lab table: Fields lab_no Patient id weight Doctor_id date Data Type int(5) int(5) int int(5) Date/Time[6] Varchar(15) Varchar(15) Int(10) Relationships Primary Key Not Null Not Null Foreign Key Not Null Not Null Not Null Not Null category patient_type amount 5. Inpatient Table: Fields Patient id name gender address room no Data Type int(5) Varchar(20) Varchar(10) Varchar(20) int(5) Date/Time[ 6] Date/Time[6] Int(10) int(5) Int(5) Relationships Primary Key Not Null Not Null Not Null Not Null Not Null Not Null Not Null Foreign Key Foreign Key date of admit date of discharge advance lab_no Doctor_id disease Varchar(20) Not Null 6. Outpatient Table: Fields Patient_id Data Type int(5) Date/Time Relationships Primary Key Not Null Foreign Key date lab no int(5) 7. Room Table: Fields room no room type status Patient id Data Type Int(5) Varchar(10) Varchar(10) Int(5) Relationships Primary Key Not Null Not Null Foreign Key 8. Bill Table: Data Type int(50) int(5) Varchar(10) int Fields bill no Patient id patient_type doctor_charge medicine_charge room charge operation charge number of days nursing charge advance int Relationships Primary Key Foreign Key Allow Null Not Null Not Null Not Null Allow Null Allow Null Allow Null Allow Null int int int int int health_card lab_charge bill Varchar(50) int Allow Null Allow Null Not Null int

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Technology And Management Computers And Information Processing Systems For Business

Authors: Robert C. Goldstein

1st Edition

0471887374, 978-0471887379

More Books

Students also viewed these Databases questions