Collegecourse catalog Design a database for the following business requirement C

Question

Collegecourse catalog

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.

Explanation / Answer

Hi,

Please refer to the following figure.

Please feel free to ask any doubts.

Thanks

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects