timetable

[jlynch1]

i am running a timtable system off an access database. I have implemented it in asp with both a page for viewing it and forms for modifying it.i have implemented it with a single line for the subject.I now have to change it to include both the location and the subject code as well as the subject name.

the following are the columns i have in my table
cid (couse id)
sem (semester)
startTime (from 9 to 17 )
mon
tues
wed
thurs
fri

should i include the 3 pieces of information in a single cell (name,code,location) in the table and then modify my update forms to use text areas instead of a text box?

Is there any other solution where the 3 items (name,code,location) could be stored seperately to in a database. Then mabye i could have both a concise version and a long version of the timetable.

would this overcomplicate things ?

i would appreciate any help.

 

[Jonax]

I must confess that I have a little trouble understanding your problem, but yes, if I were you I would modify the table and the pages, and add the three columns, separately.

I think you will find that putting them all in a single field would overcomplicate things in the long run.

If you show me some code, I'll try to help... This is not a bug - it's an undocumented feature...
;-)

 

[jlynch1]

Here is a link to a screen capture of the table i am talking about. It is about 41kb.

http://frink.nuigalway.ie/~jlynch/access.jpg

This should explain better the structure of my table at the moment. At the moment I am only storing the name of the subject.

I require now to store the name of subject , the subject code and the location where it will be thought.

I now realise that my table may be designed badly
would this be a better design ?

cid sem day time subject location
----------------------------
1 1 1 9 3 maths lab
1 1 1 10 2 science building
1 1 1 11 4 ac 202
1 1 1 12 NULL NULL
1 1 1 13 NULL NULL
1 1 1 14 NULL NULL
1 1 2 9 1 ac112

where attribute day refers to the day of the week eg 1 is monday etc. attribute subject refers to the subject table which contains the subject name and the course code.

 

[rico14d]

You should be using more than one table to store all this information.

 

[jlynch1]

any ideas how i should construct it then ??