Jump to content

Welcome Guest to Geeks to Go - Register now for FREE
Geeks To Go is a helpful hub, where thousands of friendly volunteers serve up answers and support. Get free advice from the experts. Feel free to browse the site as a guest. However, you must log in to reply to existing topics or start a new topic of your own, and enjoy all this forum has to offer. Additionally, if you can assist another member by sharing your knowledge, please post a reply! Best of all - Registration and all assistance, is FREE! Learn more about How it Works. Infected? Malware Cleaning Guide. What are you waiting for?
Create an Account Login to 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

Advertisement


#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
  • 272 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

Advertisement




Similar Topics: Module Timetabling Database     x


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured