Bineesh  Viswanath

Bineesh Viswanath

  • NA
  • 1k
  • 777.8k

Normalization in SQL

Jun 14 2013 12:34 AM
Sir, I have bit confusion in SQL Normalization.

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

Answers (2)