Computer Science 1032A/B Midterm: Computer Science 1032 Midterm 2017 Winter

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: All

Document Summary

At a university you have professors who teach courses and courses are assigned to classrooms. Each professor has a unique faculty id, first name, last name and an office number. Each course has a unique course id and course name. Each classroom has a unique classroom id, building location, room number and capacity (# of seats) A professor may not teach any courses. A course will have only one professor teaching it. All courses are taught in only one classroom. Record the day and time for when classes are taught in a classroom. Draw an e-r diagram just (only) for the relationship teaches that exists between the professor entity and the course entity. In the diagram include the cardinality of the relationship teaches, the participation of the entities in the relationship teaches, all of the appropriate attribute and clearly indicate the key attributes of the entities. There are no marks for your drawing the e-r diagram.