Monday, May 12, 2014

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



Database Design

1st 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



2nd Step – Conceptual Design

Entities


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

Sample Document Flow Diagram, Context Diagram and Level 1 DFD (Data Flow Diagram) of Course Management System, Educational Institute

Document Flow Diagram



Context Diagram




Level 1 DFD (Data Flow Diagram) 


Milinda Mayadunne
Software and Database Developer

Sample format of New System Development Proposal (for Educational Institute, Course Management System)


Project Proposal

Courses Management System of XXXXXXXX
xxxxxx University of Sri-Lanka


Brief Description of the existing system

Generally XXXXXXX has a Director and Board of Management. Faculty Boards are authorized to Propose New External Degree level Programs. Then the proposal is referred to the Senate and University Council for the Approval by the Faculty Board. XXXXXXX is Authorized to Propose New Certificate and Diploma level Courses and New proposal send to board of Management of XXXXXXX. Then that proposal is referred to the Senate and University Council for the Approval by the Board of Management.
 After get the council approval, That Approved Proposal(Degree, Diploma, Certificate) send to the Director of XXXXXXX by the Faculty Board or Board of Management. Then The Director Appoint a Coordinator For the new course and Give him the Authority to Coordinate the Course. He assigning the lecturers to the course and Applications will be called. Then According to the Course Pre-Requirements they Select the Students for the course. Before Register to the Course Students have to pay the Initial payment or Total course fee. Then the students submit the Payment Slip with the Application to the Office. Then They were registered to the course. After that Course will begin. Then, Before Examinations, Students have to pay full amount of the course fee to get register to the Examination. After students make the payments as usually the payment slip and Exam Application to be submitted. Then XXXXXXX send these exam applications to Examination Branch with the Admissions. Then examination Branch send back the Admissions to XXXXXXX with the Index Number. Finally XXXXXXX Post the Exam Admissions to the Students. Then the Examination will be held.
All the Applications, Payment slips and Other documents will be filed in the cardboard files and Store in The cupboards.



Issues of the Existing System

Ø  Still they do not use a Computerized Software Application.
Ø  All Documents are stored in physical Files.
Ø  No proper way to get student details Quickly without referring Physical files and it takes more time.
Ø  Making reports and Summarizing are done Manually by the staff. It is too difficult and Take Long time.
Ø  No proper way to update Student’s & Lecturer’s Details.
Ø  More Student’s Personal Information Mentioned & stored more than one time.




Introduction of New Proposed System

Ø  A Computerized System.
Ø  Focused on Students, Courses, Examinations and Lecturers.
Ø  Easy and Accurate Student, Course, Examination, and Lecturer  registration.
Ø  Easy to Modify and Delete data.
Ø  Easy to Access and view data.
Ø  Can Create Users with necessary Privileges.
Ø  Can Generate Relevant reports and letters easily.
Ø  User Friendly and Easy to use.

The Project Goals


Ø  Increase the Efficiency and Accuracy of  day today work and minimize Human Effort & errors.
Ø  To find correct details quickly.
Ø  Provide a Good Visibility of Student Payments.
Ø  Generate Reports & Relevant Letters quickly at any time.
Ø  Supports to Decisions making and Future planning for the Director and Council.


Scope Definition

            The Entire Process Between the Student Registration in the XXXXXXX and Student Registration for examination will be Computerized. Including Lecturer Profile.

Ø  Student Registration – (Register in XXXXXXX, for New Courses, for Examinations)
Ø  Lecturer Registration – (Register in XXXXXXX, With Teaching Subjects)
Ø  Course registration – (New course offerings with subjects & lecturers)
Ø  Payments of Student – (Maintaining All the student Payments)
Ø  Examination Registration – (Maintaining All the Examination Details with Time Table)


The work plan







Milinda Mayadunne
Software and Database Developer