Question: Consider the E-R diagram of Question 2 and design the relational schema and the tables. Perform and show the Normalization till the required normal form. Implement the database using MS-Access and submit the screenshots along with your assignment response for this question.

Ans.

1.    student

Column	Data type	Description
Id	Int	Auto increment
Student_name	Varchar(25)	student name, unique
Password	Varchar(25)	Password
Address	Varchar(25)	Address
City	Varchar(25)	City
State	Varchar(25)	State
Phone	Varchar(25)	Phone number
Email	Varchar(25)	Email

1.    Faculty

Column	Data type	Description
F_Id	Int	Auto increment
Full_name	Varchar(25)	Name
Subject	Varchar(25)	subject
Address	Varchar(25)	Address
Phone	Varchar(25)	Phone number
Email	Varchar(25)	Email

2.    courses

Column	Datatype	Description
course_id	Int	Auto increment
Course_name	Varchar(25)	User name, unique
Duration	Varchar(25)	Duration
Fee	Int	Course fee

3.    Evaluation

Column	Datatype	Description
F_id	Int	Auto increment
Eval_teacher	Varchar(25)	Teacher name evaluating
Marks_project	Int	Project marks
Marks_viva	Int	Viva marks
Marks_theory	Int	Theory marks