World's most popular travel blog for travel bloggers.

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.

, , No Comments

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






0 comments:

Post a Comment

Let us know your responses and feedback