Decide what form these tables are in (1nf,2nf,3nf) and explain why: Customer Col

Question

Decide what form these tables are in (1nf,2nf,3nf) and explain why:

Customer Columns Attributes Description Type Keys 1 cust_id customer id int PK 2 cust_name customer name varchar 3 phone_no phone number int 4 email email id varchar 5 address house address varchar 6 dob date of birth date 7 license_detail driving license details varchar 8 age age of customer int Location Columns Attributes Description Type Keys 1 loc_id Location id int PK 2 loc_name location name varchar 3 store_name store name varchar 4 store_address store address varchar 5 store_phone_no store phone int

Explanation / Answer

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Normalization : Normalization is a process of decomposing of large and complex data into simple and smaller tables.Before normalization data can be a row data or can be in the text file. By normalizing a table will get the advantages like removel of duplicate data , incorrect data can be avoided etc. In normalization forms are 1NF , 2NF , 3NF , BCNF , 4NF.

FIRST NORMAL FORM (1NF) :

All the columns in the table should be automic in nature, that means each column should contain one value & each row should contain the same number of columns. Repeating groups or duplicative columns are not allowed in the first normal form.

SECOND NORMAL FORM (2NF) :

It should full fill requirement of first normal form and all the columns in the table should functionally depend upon primary key column in the table. Partially dependancy are not allowed in second normal form.

THIRD NORMAL FORMS (3NF) :

It should full fill requirement of second normal form & all the columns in the table should depend upon primary key column. Transitive dependency are not allowed in third normal form. Transitive dependency means non key column depends upon non key column in the table.

Here two tables are given in the question as "Customer" and "Location". Below are the tables

Table Name :Customer

Here if you observe above customer table all the non key columns are depend upon primary key columns and all these columns designates information of a customer. So above table Customer is in Third Normal Form [3NF].

Table Name :Location

By observing above table location , all the columns like store_name, store_address and store_phone_no are related to store , so here need to create one more table with name store and maintain relation between location and store using loc_id. So location table is in 2NF. So to Normalize the table in 3NF as given below.

Table Name : Location

Table Name : store

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION

Columns Attributes Description Type Keys 1 cust_id Customer id int PK 2 cust_name customer name varchar 3 phone_no phone number int 4 email email id varchar 5 address house address varchar 6 dob date of birth date 7 license_detail driving license details varchar 8 age age of customer int

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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