Home » Developer & Programmer » Designer » Confusion :Normalization
Confusion :Normalization [message #90582] Mon, 26 April 2004 12:45 Go to next message
oracle
Messages: 9
Registered: May 2002
Junior Member
Hi,
suppose I have found following tables
after normalization .

students :
student_id
student_name

courses :
course_id
course_name

student_course
student_id
course_id

My confusion is that how do I setup those
table . How many tables I need to create ? two or three .
What to do with that link(student_course) table ????

Please help me . I understand normalization but
those questions bothers me .

Thank You.
Re: Confusion :Normalization [message #90583 is a reply to message #90582] Mon, 26 April 2004 21:40 Go to previous message
lalitha
Messages: 39
Registered: June 2002
Member
Hi
If every student is associated with more than one course, then it is better to have 3 tables. Else
two tables are sufficeint ie
students :
student_id
course_id
student_name

courses :
course_id
course_name

Incase If student and couse has one to many relationship, then we need to have 3 tables acc to normalization. This is because if we have only two tables, redundancy will be created(ie table contents will be repeated along with each course).
And this third table will be useful whenever we want to write queries related to students and their courses.
Hope u are getting.
lalitha
Previous Topic: Long character string in a WHERE clause filter? Performance issue?
Next Topic: help me in denormalising my database
Goto Forum:
  


Current Time: Fri Mar 29 01:16:22 CDT 2024