Step by Step ERD Example

Step by Step ERD - Step by Step ERD Example The scenario A University contains many Faculties The Faculties in turn are divided into several

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Step by Step ERD Example The scenario A University contains many Faculties. The Faculties in turn are divided into several Schools. Each School offers numerous programs and each program contains many courses. Lecturers can teach many different courses and even the same course numerous times. Courses can also be taught by many lecturers. A student is enrolled in only one program but a program can contain many students. Students can be enrolled in many courses at the same time and the courses have many students enrolled. Step 1 - Identify Entities The entities in this scenario are University Faculty School Program Course Lecturer Student Step 2 - Find relationships University Faculty School Program Course Lecturer Student University contains Faculty divided into School offers employs Program contains Course taken by Lecturer taught Student enrolled enrolled Step 3 - Draw rough ERD
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Step 4 - Fill in cardinality The university contains many faculties
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 7

Step by Step ERD - Step by Step ERD Example The scenario A University contains many Faculties The Faculties in turn are divided into several

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online