1. Identify the entities and their attributes:
- Students: attributes may include student ID, name, age, gender, major
- Courses: attributes may include course ID, course name, instructor, credit hours
- Enrollment: attributes may include enrollment ID, student ID, course ID, enrollment date
2. Identify the degree of their relationship:
- Students have a relationship with Enrollment (many-to-many)
- Courses have a relationship with Enrollment (many-to-many)
3. Identify their cardinalities:
- Students can be enrolled in multiple courses (many)
- Courses can have multiple students enrolled (many)
4. Identify Constraints:
- One student cannot be enrolled in the same course more than once (Unique constraint)
- Enrollment must have a valid student and course ID (Foreign key constraint)
Course.
1. Identify the entities and their attributes
2. Identify the degree of their relationship
3. Identify their cardinalities
4. Identify Constraints
1 answer