Hi was wondering if someone could help me?? I am doing normalization to the 3NF. I am gettin confused at what defines an repeating group!

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???

findin it really hard to understand!

Thank u in advance for helping!

Brendan

have a look at
Fundamentals of Relational Database Design -- r937.com
or
www.datamodel.org
or
The Relational Data Model, Normalisation and effective Database Design

have a look at
Fundamentals of Relational Database Design -- r937.com
or
The Relational Data Model, Normalisation and effective Database Design

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.