Creating a ERD Diagram using UML notation

Question

A student may register for many subjects and a subject is registered by many students.

A student’s number, name and age needs to be stored in the database.

Each subject’s code, name, duration, cost and start date needs to be stored in the database

A lecturer may lecture many subjects. However a subject can only be lectured by one lecturer. Each lecturer’s code, name and qualification need to be stored.

A registration needs to have the following data stored: registration number and registration date.

Parents provide payment for each registration. A parent may pay for many registrations, but a registration can only be paid by one parent. Each parent’s ID, name and cell phone needs to be stored.

A registration must always belong to a student and a course must always be part of a registration

A lecturer must lecture at least one subject and a subject needs to be lectured by at least one lecturer.

A parent needs to provide payment for at least one registration and a registration needs to be paid by at least one parent.

Answer 1

Entities: Student, Lecturer, Parent, Registration, Subject.

Registration Table will refer to a student , and a subject.

Tables Parent and Registration will be in relationship.

Student and Registration are in relationship.

Lecturer and Subject are in relationship.