Data Flow Diagram - Database Management - Lecture Slides, Slides of Introduction to Database Management Systems

Download Data Flow Diagram - Database Management - Lecture Slides and more Slides Introduction to Database Management Systems in PDF only on Docsity!

Database

Management

System

Lecture - 12

Practice Session

Application of E-R data model

We study an example scenario and

apply the design phases we have

studied so far

Data flow diagram and E-R

database design

Preliminary Study

1. Students are enrolled in

programmes/degrees

2. Programmes comprise of

different courses

3. Different programmes are

offered at the start of semester

Preliminary Study

4. Students register courses of

different programmes at the start

of every semester

5. After valid registration students

attend the classes

6. Teachers submit results during

and at the end of semester

Preliminary Study

8. Cumulative GPA is calculated

on the basis of semesters’

GPAs

9. Courses, results, students data

is stored in files

Outputs Required

Teachers and controller need class

list or attendance sheet, class result;

subject and overall

Students need transcripts, semester

result card, subject result

Registration

System

Teacher

Student

Controller

EXAMINATION

SYSTEM

MAIN MODULES

1.Subject registration

2.Result submission

3.Result calculation

STUDENT PROGRAM

& COURSE

Edit Form

Check

Pre-Req

REGISTRATION

RESULT

Teacher

Collect

Result

Calculate

GP

Update

Result

Submit Result

STUDENT PROGRAM & COURSE

Edit Form

2. Check Pre-Req

REGISTRATION

RESULT

Verified

Teacher

3. Collect Result

4. Calculate GP

5. Update Result

Subject GP

7. Calculate CGPA

8. Generate Result

6. Calculate GPA

Controller

Overall Result

Analysis Phase

Candidate Entity Types

From DFD

• Student
• Controller
• Courses
• Teachers
• Courses Offered
• Programmes
• Registration
• Results
• Semester

Candidate Entity Types

PROGRAM COURSES

CRS_OFFERED

TEACHER

SEMESTER

STUDENT