Database Management (資料庫管理) - Spring 2025 (113-2)
Last updated on 03/26/2025
home
.
back
Practice 4: ER Model
Question
Create an ER model for the Tiny College(TC)
Identity the
entites
Describe the
attributes
of each entity
Describe the type(s) of
relationship
(s) between entities
Draw the ERD in Chen's model
Extra: Draw database schema in Crow's Foot model
Hint:
The entities:
SCHOOL, DEPARTMENT, COURSE,
CLASS, PROFESSOR, STUDENT, BUILDING, ROOM, ENROLL
(the
associative entity between STUDENT and CLASS)
1:
The entities:
SCHOOL, COURSE, DEPARTMENT, CLASS, PROFESSOR, STUDENT, BUILDING, ROOM, ENROLL (the associative entity between STUDENT and CLASS)
2~3:
3:
4:
