Task - Normalization - Students

[akash-coded]

Consider the following table:

Solve for each of the given cases step-by-step by converting the table into:

• 1st Normal Form (1NF)
• 2nd Normal Form (2NF)
• 3rd Normal Form (3NF)
• Boyce-Codd Normal Form (BCNF)

[Gayathiriramalingam2024]

Create table student(
student_id serial primary key ,
student_name varchar(30),
salutation varchar(4),
book_id serial references books,
address_id serial references address);

Create Table address(
address_id serial primary_key,
address1 varchar(30),
address2 varchar(30),
address3 varchar(30),
zipcode integer);

Create table books (
books_id serial primary key,
Book_name varchar(30),
count integer,
Author_name varchar(30),
Publisher varchar(30));