Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Modeling and Database Design

Authors: Narayan S. Umanath, Richard W. Scammel

2nd edition

1285085256, 978-1285085258

More Books

Students also viewed these Databases questions

Question

What would you do about the verbal homophobic insults?

Answered: 1 week ago

Question

What is meant by organisational theory ?

Answered: 1 week ago

Question

What is meant by decentralisation of authority ?

Answered: 1 week ago

Question

Briefly explain the qualities of an able supervisor

Answered: 1 week ago

Question

Define policy making?

Answered: 1 week ago

Question

Define co-ordination?

Answered: 1 week ago