Need help on school database...breaking down courses into separate classes.
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.