Scribd
Upload
474 views2 pages

Dbms Case Study

This document describes an entity relationship (ER) diagram for an online education system database. The main entities are Course, Students, Schedules, Fees, Durations, and Training. Each entity has its own attributes like course ID, student name, schedule type, fee amount, duration date, and training description. The ER diagram shows the relationships between these entities like one-to-one and one-to-many relationships between courses, durations, fees, and training. The database is normalized to reduce duplicate records and indexing is used to improve query performance.

Uploaded by

Aditi Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
474 views2 pages

Dbms Case Study

This document describes an entity relationship (ER) diagram for an online education system database. The main entities are Course, Students, Schedules, Fees, Durations, and Training. Each entity has its own attributes like course ID, student name, schedule type, fee amount, duration date, and training description. The ER diagram shows the relationships between these entities like one-to-one and one-to-many relationships between courses, durations, fees, and training. The database is normalized to reduce duplicate records and indexing is used to improve query performance.

Uploaded by

Aditi Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Database Management System

CASE STUDY
ONLINE EDUCATION SYSTEM
This ER (Entity Relationship) Diagram represents the model of Online
Education System Entity. The entity-relationship diagram of Online
Education Management System shows all the visual instrument of data
base tables and the relations between Students, Fees, Course, and
Training etc. It used structure data and to define the relationships
between structured data groups of Online Education System
functionalities. The main entities of the Online Education System are
Course, Students, Schedules, Fees, Durations and Training.

Online Education System entities and their attributes:

• Course Entity: Attributes of Course are course_id, course student id,


course registration, course_name, course_type, course_year, course_
description

• Students Entity: Attributes of Students are student_id,


student_college_id, student_name, student_ mobile, student_ email,
student_ username, student_ password, student_address

• Schedules Entity: Attributes of Schedules are schedule_id,


schedule_name, schedule_type, schedule_ description

• Fees Entity: Attributes of Fees are course_fee_id,


course_fee_course_id, course_fee_amount, course_fee_total,
course_fee_payment, course_fee_type, course_fee_description

Durations Entity: Attributes of Durations are duration_id, duration


course_id, duration_time, duration_date, duration_type,
duration_description
Training Entity: Attributes of Training are training_aid,
training_student_id, training _registration, training_name, training_type,
training_year, training_description

Description of Online Education System Database:

 The details of Course is store into the Course tables respective with
all tables

 Each entity (Training, Schedules, Durations, Students, Course)


contains primary key and unique keys.

 The entity Schedules, Durations has binded with Course, Students


entities with foreign key

 There are one-to-one and one-to-many relationships available


between Durations, Fees, Training, and Course

 All the entities Course, Durations, Schedules, Training are


normalized and reduce duplicacy of records

 We have implemented indexing on each table of Online Education


System tables for fast query execution.

You might also like