AnsweredAssumed Answered

Need help on school database...breaking down courses into separate classes.

Question asked by bwbono on Feb 10, 2009

Title

Need help on school database...breaking down courses into separate classes.

Post

I have come up with a relational database for my school and I wonder if someone could help me out on this one point:

 

I have one database set up as the Courses. Each Course has multiple Classes that make up each Course.

On the Course database, I have all the information about this Course....teacher, trimester,classroom, pay schedule, time duration, etc.

 

What I would like to do is have a separate database called Classes with the Courses expanded or duplicated based on the amount of class units or bookings. Then I plan to add the Class dat and Times appropriately...having all the other Course data "default" in. 

 

I am sure it is possible and maybe I am blind from trying to see, but I cannot get my brain to figure this out. Maybe the wrong approach?

 

I have to admit, I am new at this all and not so good with calculations.

 

Thank you all for reading this and for ANY helpful hints or ideas that you could pass along.

 

 

Outcomes