I have 11 Tables:- tbl_Class,tbl_Division,tbl_Exam,tbl_Mark,tbl_Markentry,tbl_School,tbl_Teacher,tbl_Fee,tbl_Student,tbl_Teacher ,tbl_Login ,tbl_Subject and tbl_userCreation
tbl_Class:classId(Pk),className,noOfseats
tbl_Division:divisionId(PK),divisionName,classId(FK_tbl_Class)
tbl_Exam:examId(PK),examName,classId(FK_tbl_Class)
tbl_Login:loginId(PK),userName,password,schoolCode(fk_tbl_School)
tbl_Mark:markId(PK),studentId(FK_tbl_Student),teMark,ceMark,peMark,Total
could you help me how I arrange these tables?
Also let me know the repetating columns in this whole tables
plese send me the answer

Jignesh TrivediPosted Jun 14, 2013, 7:54 AM
hi,
Normalization is very generic. it is depending upon your requirement and complexity of you requirement.
genereally upto 3 Normalization is applied.
Note that Normalization is inversely proportional perfomance.
Vijay YadavPosted Jun 14, 2013, 6:15 AM
You can find the normalization example in our recommended articles and this will help you to arrange your tables.