Jump to content

Free help from tech experts
Welcome to Geeks to Go forums. Create an account now to gain access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing topics, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. Best of all, registration and all assistance is 100% free! This message, and all ads will be removed once you have signed in.
Sign In Create Account

Module Timetabling Database


  • Please log in to reply

#1
Immy

Immy

    New Member

  • Member
  • Pip
  • 2 posts
I don't understand this. Please could someone help..Thank you

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

Edited by Immy, 23 December 2011 - 01:22 PM.

  • 0

Similar Topics: Module Timetabling Database     x


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Is this a project or homework set at college?
  • 0

#3
Immy

Immy

    New Member

  • Member
  • Pip
  • 2 posts
Yes it is, it is part of it, but I'm confused at how to start it off
  • 0

#4
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
There are people here who know MS Access a lot better than me. I'd suggest talking to your tutor about what's required.
  • 0

#5
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 270 posts
Hello Immy,

Have you had a chance to work through this assignment yet?

dm
  • 0

#6
Problem Solving

Problem Solving

    New Member

  • Member
  • Pip
  • 1 posts
I catch you, come on try to work a bit or you really want that somebody will do it for you.

Best wishes.

Dafna.

Edited by Problem Solving, 06 January 2012 - 01:24 PM.

  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured