Quote:
Originally Posted by bree9482
for example if u had:
App ref Student name Address Town P/code Course ref Course title Student no
Would student No be a repeating group and why pls???
|
StudentName Adress Town P/Code (Course ref Course title) StduentNo
The collumns in brackets would be the repeating group.
Example-
StudentNo StudentName ........... Course ref Course title
1 Jim A1 CompSci
2 Tony A1 CompSci
3 Tim D2 ChildCare
4 Timmy D1 SocialCare
Notice the cousetitle repeating??
Normalised solution-
TableStudents
StudentNo(PK)
CourseRef(FK)
StudentName
....
TableCourses
CourseRef
CourseName
Think of a massive university database with thousands of students...
Un normailised-
500 A1's
that means 500 CompSci's
Normalised
500 A1's
but
1 CompSci
becuase A1 is a referance to CompSci in the CourseTable.
Really hope this helps.