Example of a Database (with a Conceptual Data Model)

Posted by AJ × 22:06

• Mini-world for the example:

Part of a UNIVERSITY environment.

• Some mini-world entities:

STUDENTs

COURSEs

SECTIONs (of COURSEs)

(academic) DEPARTMENTs

INSTRUCTORs

Example of a Database (with a Conceptual Data Model)

• Some mini-world relationships:

SECTIONs are of specific COURSEs

STUDENTs take SECTIONs

COURSEs have prerequisite COURSEs

INSTRUCTORs teach SECTIONs

COURSEs are offered by DEPARTMENTs

STUDENTs major in DEPARTMENTs

Example of a simple Database

Example of a Student File

Example of a simplified database catalog

Widget by HandBit

All Syllabus