Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you draw ERD diagram please and fast A2 requires students to Draw the whole Entity Relation Diagram (ERD) based on business rules and data
Can you draw ERD diagram please and fast
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started