Here are the instructions:
1. Create a new MS Access database and save it to a file with the name
Timetabling-XXXXXX where XXXXXX is your own student ID
2. Create 4 tables in the database - Lectures, Workshops, Locations and
Timeslots according to the diagram below:
This is how the table should look like
3. Create attribute columns for the above tables with suitable data types to
register the data as follows:
Lectures: lecture_id, module_code, module title, lecturer, location_id,
event_id
Workshops: workshop_id, group code, number_of_students, tutor,
location_id, event_id, lecture_id
Locations: location_id, building, room, capacity
Timeslots: event_id, weekday, beginning, ending
4. Connect the tables using suitable relations and implement the primary keys
and the foreign keys to connect the tables according to the schema above
5. Create 4 queries for finding:
- All staff members engaged in the delivery of teaching
- All Locations used on Tuesdays for workshops
- The Timeslots for one chosen module over the week
- The Lectures which are scheduled in the mornings only (before 13.00pm
6. Create 2 reports, Report1 and Report2, for showing the results of two of the
above queries and test them using your database. Format your report
7. Create 3 forms for entering data in tables Lectures, Locations and
Timeslots and test them using your database
