Exercise 1 - Draw an ERD A Student has a name, address and a birthplace city. Each students is identified by student ID. Students enroll in one or more courses. Each course is identified by course ID. Each course may have multiple students. An instructor has a name, address and phone number. Each instructor is identified by instructor ID. Instructors teach courses. Each course meets in a specific room, day of week and time. An instructor teaches no less than one courses. A course has one and only one instructor. An instructor also advises one or more students, and a student can have only one advisor.

Example like this:

Deparment one-to-one Manager Manager ID Deparmet Num is managed by one-to-many many-to-many = has Project Employee Spouse Spouse ID has works Project Num Ho Employee ID TI has Child Child ID