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    

 

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

Step: 1

The text provided appears to be incomplete and contains a mixture of f... 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

Fundamentals Of Law Office Management

Authors: Pamela Everett-Nollkamper

5th Edition

1133280846, 978-1133280842

More Books

Students also viewed these General Management questions

Question

What is the correct approach and goal of negotiation?

Answered: 1 week ago

Question

assess the infl uence of national culture on the workplace

Answered: 1 week ago