0 Replies Latest reply on Feb 10, 2009 4:31 AM by bwbono

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

    bwbono

      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.