A Database is to be designed to store the contents of a Course Catalog.

This is the Start of the User specification of the Requirements :-

Question: I have looked and have not found a model for a course catalog.

I am designing a Website for a school and we advertise what courses are being offered, in what semester, by which faculty.

The closest thing on your site is the Student Assignment, if you exclude all the student keys.

Do you have anything like what I am talking about?


Ian Lubin ianl__at__ou.edu



This is the End of the User specification of the Requirements.

A. The Things of Interest include :-
A.1 Courses Offered
A.2 Courses Scheduled
A.3 Semesters
A.4 Staff

B. How are they related ?
B.1 An Assignment is associated with one, and only one, Scheduled Course.
B.2 A Scheduled Course has a defined start and end date.