Design a database for the following business requirement

College university offers courses to students on variety of subjects. The courses are often bundled into cluster of up to 3 courses. Students are enrolled into a single courses or clusters.

Design a database to maintain a course catalog and cluster offering by semesters. A typical semester is 12 weeks duration. Additionally design should include keeping track of student roster for each cluster or course.

Please prepare a database diagram with tables and its relationship. The tables in the diagram should have Primary keys and columns with datatypes and null/not constraints.

Answer rating: 100% (QA)

Designing a database for the given business requirement involves creating tables for courses cluster... View the full answer