Tables Structure (Normalization) [message #478901] |
Wed, 13 October 2010 06:49 |
Doc1992
Messages: 5 Registered: September 2010
|
Junior Member |
|
|
Hello
I am trying to make a Program that can assist school Administration. I have created a structure Of tables given below .
Kindly check it and tell me that is it right or wrong , and if it is wrong then Provide me some guidance .
Student
Studen_Id Primary Key
Studend_Name
Class
Section
Address
City
Class
Teacher
Teacher_id Primary Key
Teacher_name
Salary
Course
Course_ID Primary Key
Course_Name
Teacher_course
Teacher_id Foreign Key
Course_ID Foreign Key
Results
Student_ID Foreign Key
Course_id
Month_of_result
Marks
Fees
Student_ID Foreign Key
Due_Date
Late_fees
Total_fees
Regards
DOC
|
|
|
|
|
|