I have a table; its a university enrolements database-

tblModules

GroupNo (PK)
Title
TutorCode(FK)
DayNo
Time
Room
Semester

Time; I dont think it is dependent on the Primary Key.

I think it should go in a seperate table like this-

tblTimes

TimeSlot(PK)
Day
Time

So it will look like this-

TimesSlot|Day|Time|

m1 |MON|9:00 - 11:00|
m2 |MON|11:15 - 1:15|
t1 |TUE|9:00 - 11:00|
t2 |TUE|11:15 - 1:15|

Do you guys think this is overkill?

I think it is required so they can query for any free timeslots and other tasks like what day is GroupNO "BAF3"; Thats if I add a composite PrimaryKey table called tblTimeTables with GroupNo and TimeSlot.

Would this even be 3rd Normal Form or 4th maybe even 5th???

Thanks Guys

I believe it's spelt university

I believe your right, I also believe this is a typo!

Fair enough - I'll stop shaking my head then

What do you think of the database?