Can you draw ERD diagram please and fast A2 requires students to Draw the whole Entity Relation

Can you draw ERD diagram please and fast

Transcribed Image Text:

A2 requires students to Draw the whole Entity Relation Diagram (ERD) based on business rules and data information of the University Registrar's Office as follow: A university registrar's office maintains data about the following entities: 1. Lecturer, including staff identification number, first name, last name, mobile number, contact email, address and department; 2. Online Class, including class number, class name, class time, and semester; 3. Course, including course number, and course name; 4. Room, including room number, room type, and location; 5. Student, including student number, student First name, last name, phone and email; 6. Department, including department number, department name; Business rules (i.e., relationships) 1. A Lecturer teaches zero, or many classes and a class is taught by one Instructor. 2. A course may generate zero, or many Online classes; and an Online class comes from one course. 3. An Online class is held in one room but a room holds many Online classes. 4. An Online class may enroll zero or many students, and a student may enroll in zero or many classes in each semester. 5. A department offer zero or many courses, and a course is offered by only one department. Regarding Cardinality Relationships, you are required to document all assumptions, things that are accepted as true or as certain to happen, without proof. A2 requires students to Draw the whole Entity Relation Diagram (ERD) based on business rules and data information of the University Registrar's Office as follow: A university registrar's office maintains data about the following entities: 1. Lecturer, including staff identification number, first name, last name, mobile number, contact email, address and department; 2. Online Class, including class number, class name, class time, and semester; 3. Course, including course number, and course name; 4. Room, including room number, room type, and location; 5. Student, including student number, student First name, last name, phone and email; 6. Department, including department number, department name; Business rules (i.e., relationships) 1. A Lecturer teaches zero, or many classes and a class is taught by one Instructor. 2. A course may generate zero, or many Online classes; and an Online class comes from one course. 3. An Online class is held in one room but a room holds many Online classes. 4. An Online class may enroll zero or many students, and a student may enroll in zero or many classes in each semester. 5. A department offer zero or many courses, and a course is offered by only one department. Regarding Cardinality Relationships, you are required to document all assumptions, things that are accepted as true or as certain to happen, without proof.