0

Hi,

I have to draw an ER diagram for assigning classrooms for scheduled courses for university.
A classrom is simply a room within a particular building and all bulidings on campus have atleast one classroom. A classroom is scheduled for a particular time and day or days of a week. If there are at least 15 students enrolled in a class, the class is included in the course schedule. The course schedule assigns a classroom to every course listed.
So, the entities for this case are:
Classroom
Building
Student
Class
Course Schedule
Well, I know the attributes for the student are studentid, name, course name ,classroom no.
I want to know the attributes for each of these entities and their relationships. I am new to this topic and have no clue how to do it?
Please help me how to solve this question.
Thank You

2
Contributors
2
Replies
10
Views
4 Years
Discussion Span
Last Post by Navya91
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.