Sample report for How to design a Database (Course Management System, Educational Institute)

Database Design

1^st step -  Requirements Collection and analysis phase

• There are 3 Levels of Courses(Certificate, Diploma, Degree)
•  Each Level has Several Courses
• Each Course Has one of more Subjects
• Each course & subject has unique Code
• Each course has many Students & One student can follow many Courses
• Each Course has Course Coordinator
• Course Coordinator is a lecturer
• A Lecturer can coordinate one or many courses
• Each Lecturer teach one or more Subjects
• Each course has one or more subjects
• Student has to pay course fee in partially or fully to register the course and also has to pay full amount of course fee to register the examination
• Each Student has Registration Number for all courses
• Each student get a index number for each Examination

2^nd Step – Conceptual Design

Entities

• Lecturer
• Course
• Student
• Examination
• Payment
• Subject
• Class