| Confusion :Normalization [message #90582] |
Mon, 26 April 2004 12:45  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
