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