Hi there
I am hoping someone would be able to answer my question here.
Basically I need some ideas for a database I need to create for college for an assignment.
The database needs to allow input for time table.
Information such as
Course:
Level: 1 or 2 or 3
Title:
Credits:
Time:
Semester:
Tutors:
Room:
I am not very experienced with Access or PHP, as I am just starting PHP and know abit about Access. Have to start somewhere.
I am planning on going with a PHP design, this is how I have it planned, (hopefully someone will tell me if this is even possible or too complex)
The user chooses the course using a drop down list, which lists all the courses.
The user then chooses the levels, 1 or 2 or 3
Which ever level they choose that they will get the modules for that level, (for example if u choose arts degree, then the level, u will get the module for that level)
The credits again drop down, 15 or 30
The Time: either manually input or via other
The semester: 1 / 2
Tutors, again using list box
Finally the rooms
Then the user clicks on save, and this will save all the data user has entered, into the database.
Is it even possible to do above and get an A4 style print out, with a standard structure, like how you see a time table.
Like so:
Time M T W T F
09:00
10:00
The the course, title, semester, and tutor to be shown, for each day and its duration.
What I am expecting it to do:
- save time
- Notify if a room is already booked
- provide search functions (as php does)
- Print functions which should be in A4 format so it can be posted in front of room
If the above is slightly difficult to do, would you suggest doing this in Access or any other.
I hope to hear from you, thanks.
