TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
2
)
Adoob in SQl SERVER
Primary and Foreign Key in SQL