Question: 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?

Data Tables: 1. Administrator Table: Fields a id a name gender Data

Type int(5) Relationships Primary Key Varchar(20) Not Null Varchar(10) Not Null 2.

Doctor Table: Fields Data Type Doctor id int(5) Relationships Primary Key Doctor

name Varchar(15) Not Null Dept Varchar(15) Not Null a_id Int(5) Foreign Key

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    

 

Data Tables: 1. Administrator Table: Fields a id a name gender Data Type int(5) Relationships Primary Key Varchar(20) Not Null Varchar(10) Not Null 2. Doctor Table: Fields Data Type Doctor id int(5) Relationships Primary Key Doctor name Varchar(15) Not Null Dept Varchar(15) Not Null a_id Int(5) Foreign Key

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

What is Normalization Normalization is a stepbystep process in database design that organizes data efficiently by eliminating redundancy and ensuring data integrity The goal of normalization is to Rem... View full answer

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 General Management Questions!