
October 20th, 2000, 04:57 PM
|
|
Junior Member
|
|
Join Date: Oct 2000
Posts: 12
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Well, I have the timetable of my uni, and I want to put it in a table and retrieve whatever I want. Here are the clues:
LessonCode , LessonSemester , StartTime , EndTime , Classroom , and Day ????
Is it better to make separate tables for each day or just put it all in one? StartTime and EndTime are to show when the lesson is taking place, and i haven't used one field for time because I want to seach using time also.
LessonCode is 4 characters, LessonSemester is 1 upto 8, and Classroom is 2 characters.
Anyone who can give a good idea for setting this up please do so, if you aren't bored of course;> Thnx anyway.
|