School Database Management System

It is about to school management system in which i explain all factors concerning school management system.

1. GROUP MEMBE
Muhammad Awais FALL13-BCS-B10-A-24
Hasan Jilani FALL13-BCS-B10-A-41
Hina Mahbob FALL13-BCS-B10-A-28






12/15/2014

[School Management System] | M Awais
DATABASE SCHOOL MANAGEMENT SCHOOL

2. School Management System

Purpose
School management system database create
Problem Statement
1. The current process of [COMPANY NAME] when it comes to
storing data such as training manuals,
2. trainees’ and facilitators’ records, progress and performance
reports solely relies on manual encoding.
3. [COMPANY NAME] does not have a centralized database or
system that will easily track all their records and data.
4. A lot of paper work needs to be accomplished and records/data are
manually encoded by the employee, trainees and facilitators.
Duplication and loss of data has been inevitable and employees
also find it difficult and time consuming to consolidate records and
reports.
Solution Statement
1. To design a Content Management System that will:
2. Automate the entire documentation process from trainee
registration, facilitator schedule
3. arrangement, down to invoicing since the system is integrated to
[COMPANY NAME]’s billing
4. system.
5. Allow easy tracking for all types of data such as training schedules,
trainees’ personal details,
6. success rate of event, etc.
7. Centralize all records, trackers, manuals and files.
8. Allow automatic consolidation of all data thus eliminating
duplication and loss of pertinent
9. information.
10.Faster turn-around time when it comes to accomplishing tasks.

3. Scope & System Overview

The main functionalities of the system are the following:
• Adding, editing, and deleting data
• User authentication for data access control
• Logs to track user activities
• Filter bar for searching of records
• RTE: Rich Text Editor tool bar (similar to Word document features)

DESCRIPTION

Systems Using the Database
1. [COMPANY NAME] Registration System as main data storage
2. [COMPANY NAME] Accounting Database for invoice reference
Relationship to Other Databases
[COMPANY NAME] Registration System is connected to [COMPANY
NAME] Accounting Database.
Database Information
Key Foreign Key
1. course Course table courseId cousrcatId
2. coursecategory Course category, look up table for courses
cousrcatId
3. facilitator Facilitators profile table facilitatorId
4. training Training table trainingId coursed, facilitatorId
5. users User Accounts table user_id
6. logs Audit logs for user activities logs_id
7. participant Participants profile table participantId
8. registration Registration table regId trainingId, participantId

5. Data Dictionary

Table structure for table course
Field Description Data Type Null
1. courseId Course ID int(11) No
2. title Course Title varchar(255) No
3. intro Course Introduction varchar(100) No
4. desc Course Description text No
5. dateposted Course Date Posted datetime No
6. status Course Status tinyint(4) No
7. coursecatId Course Category ID int(11) No

Table structure for table coursecategory
8. Field Description Data Type Null
9. coursecatId Course Category ID int(11) No
10. title Course Category Ttitle varchar(225) No
11. desc Course Categorry Description text No
12. dateposted Course Category Date Posted datetime No
13. status Course Category Status tinyint(4) No
14.
Database Identification and Description

Table structure for table facilitator
Field Description Date Type Null
1. facilitatorId Facilitator’s ID int(11) No
2. firstName Facilitator’s First Name varchar(50) No
3. midName Facilitator’s Middle Name varchar(50) No
4. titleName Facilitator’s Title varchar(50) No
5. midName Facilitator’s Middle Name varchar(50) No
6. address Facilitator’s Address varchar(255) No
7. email Facilitator’s Email Address varchar(100) No
8. phoneno Facilitator’s Phone Number varchar(50) No
9. mobile_1 Facilitator’s Mobile Number varchar(50) No
10. mobile_2 Facilitator’s Mobile Number 2 varchar(50) No

6. 11. fax Facilitator’s Fax Number varchar(50) No
12. sex Facilitator’s Gender char(1) No
13. birth_date Facilitator’s Birth Date date No
14. salary Facilitator’s Salary decimal(9,2) No
tin_number Facilitator’s Tax Identification Number int(11) No
15. dateposted Facilitator’s Date Posted datetime No
16. status Facilitator’s Status tinyint(4) No


Table structure for table logs
Field Description Data Type Null
1. logs_id Logs ID int(11) No
2. logs_table Logs Table varchar(50) No
3. logs_rec_id Logs Record ID int(11) No
4. logs_action Logs Action varchar(255) No
5. logs_keyword Logs Keyword varchar(255) No
6. logs_user_id Logs User ID int(11) No
7. logs_username Logs Username varchar(100) No
8. logs_ipadd Logs IP Address varchar(50) No
9. logs_datepost Logs Date Posted datetime No
Special Instructions: Data Process Flow
Step 1: Create User Account for CMS access
Step 2: Create Course
Step 3: Create Facilitator Profile
Database Identification and Description
[COMPANY NAME] Registration System
Step 4: Create Training Record
Step 5: Register Applicants