Hey, i have to create a database for a driving school and having some problems, never really grasped databases and i have an assignment that has to be handed in in a few days.

I have just set up my tables and have to include some of the following:

• Daily Printout on what lessons the instructor has

• A weekly cancellation printout

• A report on how many hours each driver does per week

• A report stating how many lessons each student has

• Quarterly Report

• Monthly Success Report on the students

• Monthly Failure Report on the students

• Finance Report

At the minute im having trouble on how i can book lessons for each student and dont no which method to do this.

Here is all my normalised data:

Student Details

Student ID
Student Name
Student Surname
Student Address
Student Landline
Student Mobile
Student Email
Student DOB
Student Gender
Student Next of Kin
Student Tel of Next Kin
Student Provisional No


Lesson

Student ID
Lesson Type
Lesson Time
Lesson Date
Lesson Cost
Collection Address
Drop off Point
Instructor ID


Instructor Details

Instructor ID
Driver Name
Driver Surname
Driver Address
Driver Mobile
Driver Email
Driver DOB
Driver Next of Kin
Driver Tel Next of Kin
Driver Instructor No
Driver ADI No
Driver License No
Driver Doctors No
Driver License Renewal Date

Student Pass/Fail

Student ID
Student Pass/Fail Date
Student Test Date

Lesson Type

Lesson Type
Lesson Cost

If you're looking for someone to help you with your homework assignments, you've come to the wrong place. If, as you say, you have a few days until you have to hand it in, I suggest you go to your teacher for guidance.

And your database is not normalized and otherwise not ready to begin work. If it were close to right, I'd say you might have a chance.

You really need to figure out if an instructor is an instructor or a driver. Those are 2 different things in my mind.

How do you know a [lesson] has been cancelled? Nothing in the design to tell you that.

You want a report for driving time. You don't have anywhere to collect the total driving time. I assume you need to include a "DropOffTime" field to get that.

Your field names have spaces...make your life easier by removing the spaces from your field names.

I didn't mean to hit send yet, but you get the gist. You need to read your requirements and base your tables on the requirements. You're not ready yet. You could be soon, but not yet.

[CENTER]At the minute im having trouble on how i can book lessons for each student and dont no which method to do this.
Where's your problem? You have a table called Lesson. To book a lesson for a student you would enter the data here as a row in this table. Are you being asked to design a front end (user interface) for this assignment? In which case you should design a form based on this table.

Take note of GW's comments though. You need to ensure that you have data somewhere in you tables to deal with all the questions.

It's difficult to advise on assignments because we don't know what your course has covered or your tutors expectations. We may, in trying to help, suggest you do things well outside the bounds of your course.

Chris

If I was developing that as a system I would be looking at 2 months work.