please DRAW the ER Diagram
A university has a set of classrooms scheduled for final exams. A classroom has a room
number, building, and capacity. A classroom can be uniquely identified by a building and a room
number. Each course has a course serial number, and a course name, and it belongs to a
department. Each course can have one or more sections. Each section has a section number that is
unique regarding the same course. Students are enrolled in a section. Exams are conducted in
each section of a particular course. Each exam has an exam number that is unique regarding the
same section of a course. The exam's result is also recorded i.e.,the grades of students. Student's
information includes SsN, name, and address. A name consists of a first name and a last name
An address consists of street, city, state, and zip. You should identify the key or a partial key for
each entity.
Constraints:
1.A course must have at least one section. A student should enroll in at least one
section.
2. A section should be associated with one and only one course
3. A section can have many exams and an exam belongs to just one section
4. An exam can be conducted in many classrooms (e.g. at different time).
5. A classroom can have many exams conducted in it (e.g. at different time). We do
not keep track of the time to conduct the exam
6.A section should have at least one student
7. An exam must conduct in a classroom
8. Some classrooms may not host any exam.
The owner of a weak entity can be another weak entity
