ๅฐŠๆ•ฌ็š„ ๅพฎไฟกๆฑ‡็Ž‡๏ผš1ๅ†† โ‰ˆ 0.046166 ๅ…ƒ ๆ”ฏไป˜ๅฎๆฑ‡็Ž‡๏ผš1ๅ†† โ‰ˆ 0.046257ๅ…ƒ [้€€ๅ‡บ็™ปๅฝ•]
SlideShare a Scribd company logo
Student Database Management System
Contents
List of Figures 4
1 Introduction 1
1.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
2 Project Review 2
2.1 Project management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
2.2 Student management system . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
3 Resources 4
3.1 System Development lyfe cycle . . . . . . . . . . . . . . . . . . . . . . . . . . 4
3.2 Scripting language selection . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
3.3 Database selection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
3.4 Web server selection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
4 System Analysis and Design 7
4.1 Use case analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
4.2 System Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
5 Database Design and Development 12
5.1 Database design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
5.2 Database development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
6 System and Database Testing 17
6.1 System and database testing . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
7 Project Management 33
2
7.1 Work breakdown structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
7.2 Risk management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
8 Conclusions 35
8.1 Conclusions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
9 Critical Reviews 36
9.1 Critical reviews . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
List of Figures
2.1 Project Development Phases . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
3.1 SDLC Phases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
3.2 Comparison of web servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
4.1 use case analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
4.2 Student registration process . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
4.3 Export students module . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
4.4 Search attributes for registration process . . . . . . . . . . . . . . . . . . . . 9
4.5 Enrol existing student to class . . . . . . . . . . . . . . . . . . . . . . . . . . 10
4.6 Legend and attendance system . . . . . . . . . . . . . . . . . . . . . . . . . . 10
5.1 Database creation in phpMyAdmin . . . . . . . . . . . . . . . . . . . . . . . 14
5.2 Table creation in phpMyAdmin . . . . . . . . . . . . . . . . . . . . . . . . . 14
5.3 Attribute creation in phpMyAdmin . . . . . . . . . . . . . . . . . . . . . . . 15
5.4 Total number of tables in a database . . . . . . . . . . . . . . . . . . . . . . 16
5.5 Data of one table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
6.1 Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
6.2 Test1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
6.3 Test2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
6.4 Test3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
6.5 Test4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
6.6 Test5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
6.7 Test6 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
6.8 Test7 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
4
6.9 Test8 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
6.10 Test9 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
6.11 Test10 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
6.12 Test11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
6.13 Test12 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
6.14 Test13 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
6.15 Test14 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
6.16 Test15 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
6.17 Test16 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
6.18 Test17 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
6.19 Test18 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
6.20 Test19 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
6.21 Test20 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
6.22 Test21 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
6.23 Test22 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
6.24 Test23 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
7.1 Risk Assessment Matrix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Chapter 1
Introduction
1.1 Introduction
Student Management System deals with all kind of student details, academic related
reports,
college details, course details, curriculum, batch details and other resource related
details
too. It tracks all the details of a student from the day one to the end of his course which
can
be used for all reporting purpose, tracking of attendance, progress in the course,
completed
semesters years, coming semester year curriculum details, exam details, project or any
other
assignment details, _nal exam result etc.
Our design can facilitate us to explore all the activities happening in the college, even
we
can get to know which faculty is assigned to which course, the current status of a
student,
attendance percentage of a student and upcoming requirements of a student. The
student
management system is an automated version of manual Student Management System.
It
can handle all details about a student. The details include college details, subject
details,
student personnel details, academic details, exam details etc.
In case of manual system they need a lot of time, manpower etc. Here almost all work
is computerized. So the accuracy is maintained. Maintaining backup is very easy. It can
do with in a few minutes. Our system has two type of accessing modes, administrator
and
user. Student management system is managed by an administrator. It is the job of the
administrator to insert update and monitor the whole process. When a user log in to the
system. He/she would only view details of the student. He/she can't perform any
changes.
Our system has seven modules, they are administrator, student, course, department,
exam,
attendance, and section. These modules and its attributes with entity relationship
module
presented in the ER diagram secion.
Chapter 2
Project Review
2.1 Project management
Project management skills are put to good use for this project. Having gone through
project management modules in Time Series Analysis, Optimization and with two
interns Project Management for Business and IT respectively, they enhanced my
knowledge on managing a project. Project management focuses on achieving the
objectives by applying _ve processes presented in Figure below.
Figure 2.1: Project Development Phases
2.2 Student management system
There are many software development companies that o_er student management
system for schools in the market. There are records on the past years projects on
student management system is done by students. Through the researches, it is
observed that there are features where this project can adopt and implement. One of it
will be with addition of new course or class, or even upgrading of students to the next
level, the school administrator can easily register all of them within a particular class into
the new one using just a page and not having to register one at a time. With this feature,
it helps administrator to save time as well as increase their e_ciency.
Chapter 3
Resources
3.1 System Development lyfe cycle
Systems Development Life Cycle (SDLC) is the most common process adopted to
develop a project and not surprisingly, this project is following this model too. To be
precise, waterfall model is being applied. Waterfall model is a sequential model process
where the input of a phase actually results from the previous phase.
Figure 3.1: SDLC Phases
There are _ve phases in this model and the _rst phase is the planning stage. The
planning stage determines the objectives of the project and whether the project should
be given the green light to proceed. This is where the proposal submission comes into
picture. After obtaining the approval, the next phase is analysis. Gathering and
analysing the system and user requirements is essential for entry to the design step.
With the user requirements gathering completed, there is a need to prepare the
resources for the project. Be it software or hardware components, careful consideration
and selection is to be taken care at this stage. The decision on the appropriate
resources to be used is further elaborated under the subsections below. The next step
is to design the system and database structure.
Results from the analysis and preparation that were concluded from the previous stage
are put into action. With the user requirements in mind, the ow of the system is planned
and the user interface is designed to suit their easy navigation needs. In addition, the
number of tables, attributes, primary and unique keys of the database is listed.
After completing the design, actual coding begins. Database is created and codes are
written. Some of the codes required amendments and improvement to it so these are
being developed at this fourth stage of the waterfall model. With the development
completed,testing will begin. The codes and database are tested to ensure the results
obtained are as intended. More time is spent on both development and testing stages
because it is inevitable to have errors and issues and bu_er time is allocated for
troubleshooting.
3.2 Scripting language selection
There are many scripting languages available in the market. VBScript, Perl, JSP (Java
Server Pages), ASP (Active Server Pages) and PHP (Hypertext Pre-processor) are
some of those commonly used. Yet for this project, PHP is the language that is utilised
for the coding piece because it is a server-side, embeddable HTML language. Being a
widely-used open source scripting language, it is free for everyone to use and is
especially suited for web development. On top of that, the existing system is already
using PHP. There are many advantages for using PHP thus no need for the switch to
another scripting language. Other than being a freeware, there are many free upgrade
packages easily available. The other bene_t of choosing PHP is the ease in installation.
It can run as a plug in on quite a number of web servers such as the Apache. On the
other hand, JSP requires J2EE server to run and because it is a Java coded language,
it is therefore more complex to understand and to do coding Further exploring on the
processing speed against ASP, PHP is interpreted at runtime and not compiled into
memory whereas ASP is more memory intensive with each ASP language compiler
running in its own processes. This results in slower processing speed for ASP. In
addition, ASP runs more reliably only on Microsoft Windows-based web servers than
other web servers In conclusion, PHP is the preferred selection due to the ease of
usage and it can be uploaded and run on another platform with minimal change
required to be done to the script. Beyond and above, the compiling time and speed for
PHP is faster and more e_cient.
3.3 Database selection
There are a variety of databases that we can select from the market. The widely used
databases are Microsoft Access, Microsoft SQL, Oracle and MySQL. Looking at
Microsoft Access, it does not encourage concurrent usage and it may be ine_cient, as
the database needs to be saved into one _le. It is also unable to process high speed
and large size database as compared to MySQL.
In terms of costs, Oracle database requires a licensing fee but MySQL database is a
freeware. In addition, MySQL database is easy to install, user friendly, reliable and is
able to run on di_erent platforms. Moreover PHP can access MySQL database directly
without the need to go through ODBC (Open Database Connectivity). To conclude, PHP
script is able to run faster with MySQL database and the processing time will de_nitely
be shorter. The pre-school does not require complex and costly software for its
database management system hence MySQL is the ideal database for this project.
3.4 Web server selection
After deciding on the scripting language and database, next is to select the web server
that can support them. Web server is necessary for the delivery of web content to the
web browser. As such, Apache HTTP server which has performance similar with other
'high-performance' server is considered
Thereafter, research and actual testing have been performed to see the outcome of the
various servers listed in the Figure below. These servers include PHP and MySQL in
their installation packages thus allowing smoother and simpler download process.
However, based on the performance and interface, Wamp or LAMP server is the
preferred choice.
Figure 3.2: Comparison of web servers
Chapter 4
System Analysis and Design
4.1 Use case analysis
In order to provide a clearer picture of the functionality provided by the student
management module, we have done a use case analysis. Figure below is a use case
diagram to present the functionality in the student management module.
4.2 System Design
Under the existing student management module, the administrator has to _rst register
the family. This includes the parent's particulars and home details. After submitting
these data, the administrator will be directed to the student page whereby the student
information is to be submitted. Figure below provides the interface of the existing
student registration site. For easy navigation, the registration of the student and
enrolment to the class has been combined into one process.
Figure 4.2: Student registration process
Besides the registration for a single student, there is a new feature added to the system.
That is to 'export' bulk students from a class to another. This new feature is created to
minimize the time required to register students to a new class. The school has many
programs ranging from beginner to intermediate levels thus with this new feature, the
administrator can easily enrol those students to their next level. The interface of this
function is shown in Figure below.
Figure 4.3: Export students module
Other than the 'export' feature, the system has been modi_ed to allow a couple of
search attributes at the family registration part. The name attribute includes the _rst and
last name whereas contact number means mobile, o_ce and home number. Figure
below present functionality at registration page.
Figure 4.4: Search attributes for registration process
Figure below present the functionality to add student to class module from the existing
one.
Figure 4.5: Enrol existing student to class
For the attendance marking system the following functionality has been added
Figure 4.6:
Figure 4.6: Legend and attendance system
In order to ful_l the second objective on minimizing human error, there are a few error
checking functions being implemented for the student management module. Firstly, at
the family registration page, all the _elds except the entry date, referral and remarks
_elds have been coded to do validation check. This is to ensure that all the relevant
information are collected and inserted into the database in an orderly manner.
The contact _elds are designed to prompt an error message if none of the three _elds
has been input. The school requires at least one valid number. In addition, contact
number should not contain alphabets so this has been taken into consideration for the
error checking. As for surname, name and nationality _elds, checks are implemented to
make sure the _elds are not empty. On the other hand the postal code which should not
contain alphabet; there will be message to alert any error as well.
Other than error checks on family registration page, the student registration page also
checks for the surname and name _elds. After retrieving the class details at the same
page, users will be alerted if no class is selected for the enrolment. This is also
implemented at the bulk student enrolment process. If the targeted class code is not
provided, error message will appear. The codes for the system design are provided
under Appendix A.
Chapter 5
Database Design and Development
5.1 Database design
Database is critical for all businesses. A good database does not allow any form of
anomalies and stores only relevant information in an ordered manner. If a database has
anomalies, it is a_ecting the e_ciency and data integrity. For example, delete anomaly
arise upon the deletion of a row which also forces other useful data to be lost. As such,
the tables need to be normalised. This ful_ls the last objective of ensuring data are
accurate and retrieved correctly. For the database of this project, the tables are
normalised to BCNF as shown below.admin(id,name,password)
faculty(id,name, password)
ATTENDANCE (student-class-id,class-date,status)
Where ATTENDANCE.student-class-id mustexist in STUDENT-
CLASS.id
ATTENDANCE-CODE (attendance-code,attendance-status)
CLASS-SCHEDULE(id, code,clientcode,clientname,educatorname,
educatornric,cur-
riculatheme,startdate,enddate,starttime,endtime)
Where CLASS-SCHEDULE.codemustexist in CLIENT.code,
CLASS-SCHEDULE.clientnamemustexist in CLIENT.name,
CLASS-SCHEDULE.educatornric mustexistin EDUCATOR.nric,
CLASS-SCHEDULE.educatornamemustexist in EDUCATOR.name
And CLASS-SCHEDULE.curriculatheme mustexist in
CURRICULA.theme
CLASS-TIMETABLE (class-schedule-id,class-date)
Where CLASS-TIMETABLE.class-schedule-id mustexistin CLASS-
SCHEDULE.id
CLIENT (code,name)
CURRICULA (grp, theme)
EDUCATOR(nric, name)
(nric: National Registration Identity Card)
FAMILY (id, entry-date, reg-fee, status, name, surname, nric,
address1, address2, postal-
code, contact-home, contact-o_ce, contact-hp, email,
nationality, referred-by, remarks)
STUDENT (id, family-id, name, surname, sex, dob, status)
Where STUDENT.family-id must exist in FAMILY.id
STUDENT-CLASS (id, student-id, class-schedule-id, remark)
Where STUDENT-CLASS.student-id must exist in
STUDENT.id
And STUDENT-CLASS.class-schedule-id must exist in
CLASS-SCHEDULE.id
5.2 Database development
fter identifying the tables and columns of the database, the next step is to create them.
Basically there are two ways to do so. The _rst option is to create them using
commands. Below are some of the 'create' and 'insert' statements. The complete
database code is provided under Appendix B. create table if not exists admin(aid
char(50) not null primary key, aname char(50), apwd char(50));
insert into admin values('admin', 'admin', password('admin'));
create table if not exists faculty(_d char(50) not null primary key, fname char(50), fpwd
char(50)); insert into faculty values('faculty', 'faculty', password('faculty'));
CREATE TABLE IF NOT EXISTS curricula (grp varchar(50) NOT NULL, theme var-
char(50) NOT NULL, PRIMARY KEY (grp) ) ENGINE=InnoDB DEFAULT
CHARSET=latin1; INSERT INTO curricula (grp, theme) VALUES ('1', 'Math'), ('2',
'Phy'), ('3', 'Che'), ('4', 'CSE');
The second option is to use phpMyAdmin. This is a Graphical User Interface (GUI)
interface for building and maintaining the database which is included in the web server,
XAMPP package.
This is a simpler way to create the tables if one does not know the usage of commands.
The _rst step is to create the database as shown in Figure below.
The default storage engine in this MySQL server is InnoDB which has commit, rollback,
and crash-recovery capabilities to protect user data. Following that is to create the
tables in the database.
Figure 5.1: Database creation in phpMyAdmin
Figure below gives a view of the table creation.
Figure 5.2: Table creation in phpMyAdmin
Figure below shows the interface for creating the attributes in the table.
Figure 5.3: Attribute creation in phpMyAdmin
After completing the creation, Figure below depicts the contents of the database,
providing information like the number of tables in the database and the number of
records in eachof them. The MySQL server, phpMyAdmin, has many other features
such as the deletion of tables, attributes and database. It also provides a mean for
exporting or importing data into another database easily just by selecting the desired
option seen at the top of the table in Figure below.
Figure 5.4: Total number of tables in a database
To view the data in one of the table, this can be done by clicking on the table name
listed on the left menu as per Figure below. The _gure illustrates the educator table and
there are three records in it.
Figure 5.5: Data of one table
Chapter 6
System and Database Testing
6.1 System and database testing
Testing is the last phase of this project. This is the stage where it shows whether the
system and database are working as desired. Otherwise, further recti_cation is required.
Tests have been conducted and recorded below to show the results.
Figure 6.1: Test
Test 1
Purpose: Test the error checking functions
Location: Family Registration
Condition: All mandatory _elds need to be _lled up
Result
Figure 6.2: Test1
Test 2
Purpose: Test the error checking functions
Location: Family Registration
Condition: At least one contact number is required
Result:
Figure 6.3: Test2
Test 3
Purpose: Test the error checking functions
Location: Family Registration
Condition: Contact number should contain numbers only
Result:
Figure 6.4: Test3
Test 4
Purpose: Test the error checking functions
Location: Family Registration
Condition: Email address must be valid
Result:
Figure 6.5: Test4
Test 5
Purpose: Test the error checking functions
Location: Family Registration
Condition: Postal Code should contain numbers only
Result:
Figure 6.6: Test5
Test 6
Purpose: Test the Search function
Location: Family Registration
Condition: No search value is input
Result
Figure 6.7: Test6
Test 7
Purpose: Test the Search function
Location: Family Registration
Condition: Search using NRIC
Result:
Figure 6.8: Test7
Test 8
Purpose: Test the Search function
Location: Family Registration
Condition: Search using any contact number
Result:
Figure 6.9: Test8
Test 9
Purpose: Test the Search function
Location: Family Registration
Condition: Search using name
Result:
Figure 6.10: Test9
Test 10
Purpose: Update of family details
Location: Family Registration
Database: Family table
Condition: All data are valid
Result: In the system:
Figure 6.11: Test10
Test 11
Purpose: Update of family details
Location: Family Registration
Database: Family table
Condition: No update is done (status quo)
Result: In the system:
Figure 6.12: Test11
Test 12
Purpose: Create family
Location: Family Registration
Database: Family table
Condition: All data are valid
Result:In the system:
Figure 6.13: Test12
Test 13
Purpose: Create student (After creating the family)
Location: Student Registration
Condition: All mandatory _elds are required
Figure 6.14: Test13
Test 14
Purpose: Create student (After creating the family)
Location: Student Registration
Condition: All mandatory _elds are required
Result:
Figure 6.15: Test14
Test 15
Purpose: Create student (After creating the family)
Location: Student Registration
Condition: Need to select the class after retrieve class
Result:
Figure 6.16: Test15
Test 16
Purpose: Create student (After creating the family)
Location: Student Registration
Database: Student and Student-class tables
Condition: All data are valid
Result: In the system:
Figure 6.17: Test16
Test 17
Purpose: Delete student
Location: Student Registration
Database: Student and Student-class tables
Result: In the system:
Figure 6.18: Test17
Test 18
Purpose: To test the export function
Location: Export students
Condition: A valid class code is required.
Result:
Figure 6.19: Test18
Test 19
Purpose: To test the export function
Location: Export students
Database: Student-class table
Condition: Selected student to be exported from TRY-01 to class TRY-02
Result: In the system
Fig
Figure 6.20: Test19
Test 20
Purpose: To test the list students function
Location: List Student
Database: Student and Family tables
Condition: Search for students with name 'Bhai' and list out the family information
Result:
Figure 6.21: Test20
Test 21
Purpose: To test the list students function
Location: List Student
Database: Student and Family tables
Condition: List all students in the school by the order of Date of Birth
Result:
Figure 6.22: Test21
Test 22
Purpose: To test the list students function
Location: List Student
Database: Student and Family tables
Condition: List all students in the school by the order of Surname
Result:
Figure 6.23: Test22
Test 23
Purpose: To test the attendance taking function
Location: Take Attendance
Database: Attendance table
Result: In the system:
Chapter 7
Project Management
7.1 Work breakdown structure
The Work Breakdown Structure provides a clear picture of the items that are required to
be completed for the project work scope. It is arranged in a tree structure manner to
show all sub-sections required to be accomplished in each phase throughout the
project.
7.2 Risk management
Every project has uncertainties and they may a_ect the project success. These
uncertainties are known as risk. There is a need to determine the risks involved in the
project to reduce the chance of its occurrence as well as develop a plan to either
mitigate or avoid the risks that have been identi_ed. After identifying and determining
the risks, they are recorded in a table called the risk assessment matrix. This matrix lists
the severity which is also known as the impact level in terms of High, Medium and Low.
In addition to those details, the action plan that can be taken for each of the risks is
clearly stated too.
Figure 7.1: Risk Assessment Matrix
Chapter 8
Conclusions
8.1 Conclusions
Simplicity is never simple. As we have seen in this project, the process of creating a
user-friendly and straightforward platform that facilitates the administrator's job is one
_lled with complexity. From understanding user requirements to system design and
_nally system prototype and _nalization, every step requires in-depth understanding
and commitment towards achieving the objectives of the project.
Although the student database management module is not fully integrated to the system
and used on real time, the system prototype demonstrates easy navigation and data are
stored in a systematic way. Overall, e_ciency has improved and work processes
simpli_ed. Although all the objectives have been met, the system still has room for
improvement. The system is robust and exible enough for future upgrade using
advanced technology and devices
Chapter 9
Critical Reviews
9.1 Critical reviews
In the process of doing this project, obstacles have been encountered. I have learnt to
be more exible in resolving issues. One of the situations that I have faced was when I
had installed MySQL server, but it did not work. Then I tried to troubleshoot, research
online and did a couple of re-installation but to no avail. Then I installed XAMPP, it did
not work out too. Some how I did get rid of this problem but I did not like XAMPP server.
Therefore I decided to install LAMP server. Yes it worked _ne. At the end I found that I
had installed multiple server and hence system was confused which server is to be
used i.e. conicts with MySQL. Then I stopped all server running on my laptop and
decicded to start only LAMP server and it worked _ne.
Being a novice in PHP language, I had di_culty in understanding the basic to write php
_les. Therefore I took longer time to understand how and why PHP works. I researched
too much online. Went through several examples, tutorials etc.
Still I am not good enough in PHP language. In this entire project I have used only
PHP and HTML languages. but later I realized that there are multiple laguages which
can support in designing a good database project. Those are CSS, JavaScript. There
may be more but trully speeking I really don't know any more. Eventually with more
hands-on exposure throughout this project, I managed to gain some understanding of
PHP language. Discipline played an important role for the completion of this project.
Using the project management skills taught in class, I was able to apply them to this
project. Besides project management skills, I had also applied the database knowledge
that I had learnt in the class to this project. From analysing of database structure and
their relations to creating the database and tables, all these have strengthened my
understanding. However when doing part of the codes, I would still research online and
_nd solutions, for example, the usage of 'Ignore' command to avoid duplication of data
from inserting into the database. This command did not work on MyISAM storage
engine thus I had to change my database storage to InnoDB in order for that to work.
Overall though the project was _lled with challenges, it had given me opportunity to
apply and strengthen my knowledge as well as gain new knowledge and skill through
researches and experienced professionals whom I am fortunate enough to encounter.

More Related Content

What's hot

Synopsis on billing system
Synopsis on billing systemSynopsis on billing system
Synopsis on billing system
Alok Sharma
ย 
Placement management system
Placement management systemPlacement management system
Placement management system
Surya Teja
ย 
Student management system
Student management systemStudent management system
Student management system
Gaurav Subham
ย 
Student information system
Student information systemStudent information system
Student information system
sourabh singh sen
ย 
Student Management System
Student Management SystemStudent Management System
Student Management System
HamaQarani
ย 
student database management system
student database management systemstudent database management system
student database management system
Md. Riadul Islam
ย 
Final Year Project BCA Presentation on Pic-O-Stica
Final Year Project BCA Presentation on Pic-O-SticaFinal Year Project BCA Presentation on Pic-O-Stica
Final Year Project BCA Presentation on Pic-O-Stica
Sharath Raj
ย 
Attendance management system
Attendance management system Attendance management system
Attendance management system
SHIVANGI GOEL
ย 
Student Management System report
Student Management System reportStudent Management System report
Student Management System report
Chandresh Prasad
ย 
online Examination System (project report)
online Examination System (project report)online Examination System (project report)
online Examination System (project report)
vivek anand
ย 
Student Management System Project Abstract
Student Management System Project AbstractStudent Management System Project Abstract
Student Management System Project Abstract
Udhayyagethan Mano
ย 
Library mangement system project srs documentation.doc
Library mangement system project srs documentation.docLibrary mangement system project srs documentation.doc
Library mangement system project srs documentation.doc
jimmykhan
ย 
Software Requirements Specification for restaurant management system
Software Requirements Specification for restaurant management systemSoftware Requirements Specification for restaurant management system
Software Requirements Specification for restaurant management system
SM. Aurnob
ย 
Software requirements specification of Library Management System
Software requirements specification of Library Management SystemSoftware requirements specification of Library Management System
Software requirements specification of Library Management System
Soumili Sen
ย 
Online Admission System
Online Admission System  Online Admission System
Online Admission System
Laukesh Jaishwal
ย 
School management system
School management systemSchool management system
School management system
Soumya Behera
ย 
Student database management system
Student database management systemStudent database management system
Student database management system
Arpita Naik
ย 
Library management system
Library management systemLibrary management system
Library management system
Paresh Gosavi
ย 
Online Quiz System Project Report
Online Quiz System Project Report Online Quiz System Project Report
Online Quiz System Project Report
Kishan Maurya
ย 
Banking Management System Project documentation
Banking Management System Project documentationBanking Management System Project documentation
Banking Management System Project documentation
Chaudhry Sajid
ย 

What's hot (20)

Synopsis on billing system
Synopsis on billing systemSynopsis on billing system
Synopsis on billing system
ย 
Placement management system
Placement management systemPlacement management system
Placement management system
ย 
Student management system
Student management systemStudent management system
Student management system
ย 
Student information system
Student information systemStudent information system
Student information system
ย 
Student Management System
Student Management SystemStudent Management System
Student Management System
ย 
student database management system
student database management systemstudent database management system
student database management system
ย 
Final Year Project BCA Presentation on Pic-O-Stica
Final Year Project BCA Presentation on Pic-O-SticaFinal Year Project BCA Presentation on Pic-O-Stica
Final Year Project BCA Presentation on Pic-O-Stica
ย 
Attendance management system
Attendance management system Attendance management system
Attendance management system
ย 
Student Management System report
Student Management System reportStudent Management System report
Student Management System report
ย 
online Examination System (project report)
online Examination System (project report)online Examination System (project report)
online Examination System (project report)
ย 
Student Management System Project Abstract
Student Management System Project AbstractStudent Management System Project Abstract
Student Management System Project Abstract
ย 
Library mangement system project srs documentation.doc
Library mangement system project srs documentation.docLibrary mangement system project srs documentation.doc
Library mangement system project srs documentation.doc
ย 
Software Requirements Specification for restaurant management system
Software Requirements Specification for restaurant management systemSoftware Requirements Specification for restaurant management system
Software Requirements Specification for restaurant management system
ย 
Software requirements specification of Library Management System
Software requirements specification of Library Management SystemSoftware requirements specification of Library Management System
Software requirements specification of Library Management System
ย 
Online Admission System
Online Admission System  Online Admission System
Online Admission System
ย 
School management system
School management systemSchool management system
School management system
ย 
Student database management system
Student database management systemStudent database management system
Student database management system
ย 
Library management system
Library management systemLibrary management system
Library management system
ย 
Online Quiz System Project Report
Online Quiz System Project Report Online Quiz System Project Report
Online Quiz System Project Report
ย 
Banking Management System Project documentation
Banking Management System Project documentationBanking Management System Project documentation
Banking Management System Project documentation
ย 

Similar to Student database management system PROJECT

Student Database Management System
Student Database Management SystemStudent Database Management System
Student Database Management System
Ajay Bidyarthy
ย 
Student db-mgmt-system
Student db-mgmt-systemStudent db-mgmt-system
Student db-mgmt-system
Md. Riadul Islam
ย 
online examination management system
online examination management systemonline examination management system
online examination management system
Praveen Patel
ย 
dissertation
dissertationdissertation
dissertation
Peeranat Fupongsiripan
ย 
Undergrad Thesis | Information Science and Engineering
Undergrad Thesis | Information Science and EngineeringUndergrad Thesis | Information Science and Engineering
Undergrad Thesis | Information Science and Engineering
Priyanka Pandit
ย 
S4 h 301 testyourprocesses_userguide
S4 h 301 testyourprocesses_userguideS4 h 301 testyourprocesses_userguide
S4 h 301 testyourprocesses_userguide
Lokesh Modem
ย 
Trinity Impulse - Event Aggregation to Increase Stundents Awareness of Events...
Trinity Impulse - Event Aggregation to Increase Stundents Awareness of Events...Trinity Impulse - Event Aggregation to Increase Stundents Awareness of Events...
Trinity Impulse - Event Aggregation to Increase Stundents Awareness of Events...
Jason Cheung
ย 
SocioTechnical-systems-sim
SocioTechnical-systems-simSocioTechnical-systems-sim
SocioTechnical-systems-sim
Rub Afonso
ย 
Smart attendance system using facial recognition
Smart attendance system using facial recognitionSmart attendance system using facial recognition
Smart attendance system using facial recognition
VigneshLakshmanan8
ย 
Online Test
Online TestOnline Test
Online Test
Vikas Sharma
ย 
UCHILE_M_Sc_Thesis_final
UCHILE_M_Sc_Thesis_finalUCHILE_M_Sc_Thesis_final
UCHILE_M_Sc_Thesis_final
Gustavo Pabon
ย 
UCHILE_M_Sc_Thesis_final
UCHILE_M_Sc_Thesis_finalUCHILE_M_Sc_Thesis_final
UCHILE_M_Sc_Thesis_final
Gustavo Pabon
ย 
document
documentdocument
document
Ouerghi Yassine
ย 
bkremer-report-final
bkremer-report-finalbkremer-report-final
bkremer-report-final
Ben Kremer
ย 
Report on e-Notice App (An Android Application)
Report on e-Notice App (An Android Application)Report on e-Notice App (An Android Application)
Report on e-Notice App (An Android Application)
Priyanka Kapoor
ย 
Fraser_William
Fraser_WilliamFraser_William
Fraser_William
William John MacLeod Fraser
ย 
Thesis - Nora Szepes - Design and Implementation of an Educational Support Sy...
Thesis - Nora Szepes - Design and Implementation of an Educational Support Sy...Thesis - Nora Szepes - Design and Implementation of an Educational Support Sy...
Thesis - Nora Szepes - Design and Implementation of an Educational Support Sy...
Nรณra Szepes
ย 
digiinfo website project report
digiinfo website project reportdigiinfo website project report
digiinfo website project report
ABHIJEET KHIRE
ย 
Thesis_Report
Thesis_ReportThesis_Report
Thesis_Report
Subramaniam Ramasubramanian
ย 
project Report on LAN Security Manager
project Report on LAN Security Managerproject Report on LAN Security Manager
project Report on LAN Security Manager
Shahrikh Khan
ย 

Similar to Student database management system PROJECT (20)

Student Database Management System
Student Database Management SystemStudent Database Management System
Student Database Management System
ย 
Student db-mgmt-system
Student db-mgmt-systemStudent db-mgmt-system
Student db-mgmt-system
ย 
online examination management system
online examination management systemonline examination management system
online examination management system
ย 
dissertation
dissertationdissertation
dissertation
ย 
Undergrad Thesis | Information Science and Engineering
Undergrad Thesis | Information Science and EngineeringUndergrad Thesis | Information Science and Engineering
Undergrad Thesis | Information Science and Engineering
ย 
S4 h 301 testyourprocesses_userguide
S4 h 301 testyourprocesses_userguideS4 h 301 testyourprocesses_userguide
S4 h 301 testyourprocesses_userguide
ย 
Trinity Impulse - Event Aggregation to Increase Stundents Awareness of Events...
Trinity Impulse - Event Aggregation to Increase Stundents Awareness of Events...Trinity Impulse - Event Aggregation to Increase Stundents Awareness of Events...
Trinity Impulse - Event Aggregation to Increase Stundents Awareness of Events...
ย 
SocioTechnical-systems-sim
SocioTechnical-systems-simSocioTechnical-systems-sim
SocioTechnical-systems-sim
ย 
Smart attendance system using facial recognition
Smart attendance system using facial recognitionSmart attendance system using facial recognition
Smart attendance system using facial recognition
ย 
Online Test
Online TestOnline Test
Online Test
ย 
UCHILE_M_Sc_Thesis_final
UCHILE_M_Sc_Thesis_finalUCHILE_M_Sc_Thesis_final
UCHILE_M_Sc_Thesis_final
ย 
UCHILE_M_Sc_Thesis_final
UCHILE_M_Sc_Thesis_finalUCHILE_M_Sc_Thesis_final
UCHILE_M_Sc_Thesis_final
ย 
document
documentdocument
document
ย 
bkremer-report-final
bkremer-report-finalbkremer-report-final
bkremer-report-final
ย 
Report on e-Notice App (An Android Application)
Report on e-Notice App (An Android Application)Report on e-Notice App (An Android Application)
Report on e-Notice App (An Android Application)
ย 
Fraser_William
Fraser_WilliamFraser_William
Fraser_William
ย 
Thesis - Nora Szepes - Design and Implementation of an Educational Support Sy...
Thesis - Nora Szepes - Design and Implementation of an Educational Support Sy...Thesis - Nora Szepes - Design and Implementation of an Educational Support Sy...
Thesis - Nora Szepes - Design and Implementation of an Educational Support Sy...
ย 
digiinfo website project report
digiinfo website project reportdigiinfo website project report
digiinfo website project report
ย 
Thesis_Report
Thesis_ReportThesis_Report
Thesis_Report
ย 
project Report on LAN Security Manager
project Report on LAN Security Managerproject Report on LAN Security Manager
project Report on LAN Security Manager
ย 

More from Rai Saheb Bhanwar Singh College Nasrullaganj

lec34.ppt
lec34.pptlec34.ppt
lec33.ppt
lec33.pptlec33.ppt
lec31.ppt
lec31.pptlec31.ppt
lec32.ppt
lec32.pptlec32.ppt
lec42.ppt
lec42.pptlec42.ppt
lec41.ppt
lec41.pptlec41.ppt
lec39.ppt
lec39.pptlec39.ppt
lec38.ppt
lec38.pptlec38.ppt
lec37.ppt
lec37.pptlec37.ppt
lec23.ppt
lec23.pptlec23.ppt
lec21.ppt
lec21.pptlec21.ppt
lec20.ppt
lec20.pptlec20.ppt
lec19.ppt
lec19.pptlec19.ppt
lec18.ppt
lec18.pptlec18.ppt
lec17.ppt
lec17.pptlec17.ppt
lec16.ppt
lec16.pptlec16.ppt
lec30.ppt
lec30.pptlec30.ppt
lec28.ppt
lec28.pptlec28.ppt
lec27.ppt
lec27.pptlec27.ppt
lec26.ppt
lec26.pptlec26.ppt

More from Rai Saheb Bhanwar Singh College Nasrullaganj (20)

lec34.ppt
lec34.pptlec34.ppt
lec34.ppt
ย 
lec33.ppt
lec33.pptlec33.ppt
lec33.ppt
ย 
lec31.ppt
lec31.pptlec31.ppt
lec31.ppt
ย 
lec32.ppt
lec32.pptlec32.ppt
lec32.ppt
ย 
lec42.ppt
lec42.pptlec42.ppt
lec42.ppt
ย 
lec41.ppt
lec41.pptlec41.ppt
lec41.ppt
ย 
lec39.ppt
lec39.pptlec39.ppt
lec39.ppt
ย 
lec38.ppt
lec38.pptlec38.ppt
lec38.ppt
ย 
lec37.ppt
lec37.pptlec37.ppt
lec37.ppt
ย 
lec23.ppt
lec23.pptlec23.ppt
lec23.ppt
ย 
lec21.ppt
lec21.pptlec21.ppt
lec21.ppt
ย 
lec20.ppt
lec20.pptlec20.ppt
lec20.ppt
ย 
lec19.ppt
lec19.pptlec19.ppt
lec19.ppt
ย 
lec18.ppt
lec18.pptlec18.ppt
lec18.ppt
ย 
lec17.ppt
lec17.pptlec17.ppt
lec17.ppt
ย 
lec16.ppt
lec16.pptlec16.ppt
lec16.ppt
ย 
lec30.ppt
lec30.pptlec30.ppt
lec30.ppt
ย 
lec28.ppt
lec28.pptlec28.ppt
lec28.ppt
ย 
lec27.ppt
lec27.pptlec27.ppt
lec27.ppt
ย 
lec26.ppt
lec26.pptlec26.ppt
lec26.ppt
ย 

Recently uploaded

Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants  When and How To Record ProperlyAccounting for Restricted Grants  When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
TechSoup
ย 
Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024
Friends of African Village Libraries
ย 
bryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours  second semesterbryophytes.pptx bsc botany honours  second semester
bryophytes.pptx bsc botany honours second semester
Sarojini38
ย 
Creating Images and Videos through AI.pptx
Creating Images and Videos through AI.pptxCreating Images and Videos through AI.pptx
Creating Images and Videos through AI.pptx
Forum of Blended Learning
ย 
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT KanpurDiversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Quiz Club IIT Kanpur
ย 
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT  Internet resources for social science220711130083 SUBHASHREE RAKSHIT  Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
Kalna College
ย 
The Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptxThe Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptx
PriyaKumari928991
ย 
Slides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptxSlides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptx
shabeluno
ย 
How to Download & Install Module From the Odoo App Store in Odoo 17
How to Download & Install Module From the Odoo App Store in Odoo 17How to Download & Install Module From the Odoo App Store in Odoo 17
How to Download & Install Module From the Odoo App Store in Odoo 17
Celine George
ย 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
Celine George
ย 
Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17
Celine George
ย 
nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...
chaudharyreet2244
ย 
220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology
Kalna College
ย 
How to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRMHow to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRM
Celine George
ย 
220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science
Kalna College
ย 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
MJDuyan
ย 
Talking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual AidsTalking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual Aids
MattVassar1
ย 
The basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptxThe basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptx
heathfieldcps1
ย 
220711130095 Tanu Pandey message currency, communication speed & control EPC ...
220711130095 Tanu Pandey message currency, communication speed & control EPC ...220711130095 Tanu Pandey message currency, communication speed & control EPC ...
220711130095 Tanu Pandey message currency, communication speed & control EPC ...
Kalna College
ย 
A Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by QuizzitoA Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by Quizzito
Quizzito The Quiz Society of Gargi College
ย 

Recently uploaded (20)

Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants  When and How To Record ProperlyAccounting for Restricted Grants  When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
ย 
Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024
ย 
bryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours  second semesterbryophytes.pptx bsc botany honours  second semester
bryophytes.pptx bsc botany honours second semester
ย 
Creating Images and Videos through AI.pptx
Creating Images and Videos through AI.pptxCreating Images and Videos through AI.pptx
Creating Images and Videos through AI.pptx
ย 
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT KanpurDiversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
ย 
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT  Internet resources for social science220711130083 SUBHASHREE RAKSHIT  Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
ย 
The Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptxThe Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptx
ย 
Slides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptxSlides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptx
ย 
How to Download & Install Module From the Odoo App Store in Odoo 17
How to Download & Install Module From the Odoo App Store in Odoo 17How to Download & Install Module From the Odoo App Store in Odoo 17
How to Download & Install Module From the Odoo App Store in Odoo 17
ย 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
ย 
Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17
ย 
nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...
ย 
220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology
ย 
How to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRMHow to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRM
ย 
220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science
ย 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
ย 
Talking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual AidsTalking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual Aids
ย 
The basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptxThe basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptx
ย 
220711130095 Tanu Pandey message currency, communication speed & control EPC ...
220711130095 Tanu Pandey message currency, communication speed & control EPC ...220711130095 Tanu Pandey message currency, communication speed & control EPC ...
220711130095 Tanu Pandey message currency, communication speed & control EPC ...
ย 
A Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by QuizzitoA Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by Quizzito
ย 

Student database management system PROJECT

  • 2. Contents List of Figures 4 1 Introduction 1 1.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 2 Project Review 2 2.1 Project management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2.2 Student management system . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 3 Resources 4 3.1 System Development lyfe cycle . . . . . . . . . . . . . . . . . . . . . . . . . . 4 3.2 Scripting language selection . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3.3 Database selection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3.4 Web server selection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 4 System Analysis and Design 7 4.1 Use case analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 4.2 System Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 5 Database Design and Development 12 5.1 Database design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 5.2 Database development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 6 System and Database Testing 17 6.1 System and database testing . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 7 Project Management 33 2 7.1 Work breakdown structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 7.2 Risk management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 8 Conclusions 35 8.1 Conclusions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 9 Critical Reviews 36 9.1 Critical reviews . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
  • 3. List of Figures 2.1 Project Development Phases . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 3.1 SDLC Phases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 3.2 Comparison of web servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 4.1 use case analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 4.2 Student registration process . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 4.3 Export students module . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 4.4 Search attributes for registration process . . . . . . . . . . . . . . . . . . . . 9 4.5 Enrol existing student to class . . . . . . . . . . . . . . . . . . . . . . . . . . 10 4.6 Legend and attendance system . . . . . . . . . . . . . . . . . . . . . . . . . . 10 5.1 Database creation in phpMyAdmin . . . . . . . . . . . . . . . . . . . . . . . 14 5.2 Table creation in phpMyAdmin . . . . . . . . . . . . . . . . . . . . . . . . . 14 5.3 Attribute creation in phpMyAdmin . . . . . . . . . . . . . . . . . . . . . . . 15 5.4 Total number of tables in a database . . . . . . . . . . . . . . . . . . . . . . 16 5.5 Data of one table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 6.1 Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 6.2 Test1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 6.3 Test2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 6.4 Test3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 6.5 Test4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 6.6 Test5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 6.7 Test6 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 6.8 Test7 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 4 6.9 Test8 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 6.10 Test9 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 6.11 Test10 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 6.12 Test11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 6.13 Test12 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 6.14 Test13 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 6.15 Test14 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 6.16 Test15 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 6.17 Test16 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 6.18 Test17 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 6.19 Test18 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 6.20 Test19 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 6.21 Test20 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 6.22 Test21 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 6.23 Test22 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 6.24 Test23 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 7.1 Risk Assessment Matrix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
  • 4. Chapter 1 Introduction 1.1 Introduction Student Management System deals with all kind of student details, academic related reports, college details, course details, curriculum, batch details and other resource related details too. It tracks all the details of a student from the day one to the end of his course which can be used for all reporting purpose, tracking of attendance, progress in the course, completed semesters years, coming semester year curriculum details, exam details, project or any other assignment details, _nal exam result etc. Our design can facilitate us to explore all the activities happening in the college, even we can get to know which faculty is assigned to which course, the current status of a student, attendance percentage of a student and upcoming requirements of a student. The student management system is an automated version of manual Student Management System. It can handle all details about a student. The details include college details, subject details, student personnel details, academic details, exam details etc. In case of manual system they need a lot of time, manpower etc. Here almost all work is computerized. So the accuracy is maintained. Maintaining backup is very easy. It can do with in a few minutes. Our system has two type of accessing modes, administrator and user. Student management system is managed by an administrator. It is the job of the administrator to insert update and monitor the whole process. When a user log in to the system. He/she would only view details of the student. He/she can't perform any changes. Our system has seven modules, they are administrator, student, course, department, exam, attendance, and section. These modules and its attributes with entity relationship module presented in the ER diagram secion.
  • 5. Chapter 2 Project Review 2.1 Project management Project management skills are put to good use for this project. Having gone through project management modules in Time Series Analysis, Optimization and with two interns Project Management for Business and IT respectively, they enhanced my knowledge on managing a project. Project management focuses on achieving the objectives by applying _ve processes presented in Figure below. Figure 2.1: Project Development Phases 2.2 Student management system There are many software development companies that o_er student management system for schools in the market. There are records on the past years projects on student management system is done by students. Through the researches, it is observed that there are features where this project can adopt and implement. One of it will be with addition of new course or class, or even upgrading of students to the next level, the school administrator can easily register all of them within a particular class into the new one using just a page and not having to register one at a time. With this feature, it helps administrator to save time as well as increase their e_ciency.
  • 6. Chapter 3 Resources 3.1 System Development lyfe cycle Systems Development Life Cycle (SDLC) is the most common process adopted to develop a project and not surprisingly, this project is following this model too. To be precise, waterfall model is being applied. Waterfall model is a sequential model process where the input of a phase actually results from the previous phase. Figure 3.1: SDLC Phases There are _ve phases in this model and the _rst phase is the planning stage. The planning stage determines the objectives of the project and whether the project should be given the green light to proceed. This is where the proposal submission comes into picture. After obtaining the approval, the next phase is analysis. Gathering and analysing the system and user requirements is essential for entry to the design step. With the user requirements gathering completed, there is a need to prepare the resources for the project. Be it software or hardware components, careful consideration and selection is to be taken care at this stage. The decision on the appropriate resources to be used is further elaborated under the subsections below. The next step is to design the system and database structure. Results from the analysis and preparation that were concluded from the previous stage are put into action. With the user requirements in mind, the ow of the system is planned and the user interface is designed to suit their easy navigation needs. In addition, the number of tables, attributes, primary and unique keys of the database is listed. After completing the design, actual coding begins. Database is created and codes are written. Some of the codes required amendments and improvement to it so these are being developed at this fourth stage of the waterfall model. With the development completed,testing will begin. The codes and database are tested to ensure the results obtained are as intended. More time is spent on both development and testing stages because it is inevitable to have errors and issues and bu_er time is allocated for troubleshooting.
  • 7. 3.2 Scripting language selection There are many scripting languages available in the market. VBScript, Perl, JSP (Java Server Pages), ASP (Active Server Pages) and PHP (Hypertext Pre-processor) are some of those commonly used. Yet for this project, PHP is the language that is utilised for the coding piece because it is a server-side, embeddable HTML language. Being a widely-used open source scripting language, it is free for everyone to use and is especially suited for web development. On top of that, the existing system is already using PHP. There are many advantages for using PHP thus no need for the switch to another scripting language. Other than being a freeware, there are many free upgrade packages easily available. The other bene_t of choosing PHP is the ease in installation. It can run as a plug in on quite a number of web servers such as the Apache. On the other hand, JSP requires J2EE server to run and because it is a Java coded language, it is therefore more complex to understand and to do coding Further exploring on the processing speed against ASP, PHP is interpreted at runtime and not compiled into memory whereas ASP is more memory intensive with each ASP language compiler running in its own processes. This results in slower processing speed for ASP. In addition, ASP runs more reliably only on Microsoft Windows-based web servers than other web servers In conclusion, PHP is the preferred selection due to the ease of usage and it can be uploaded and run on another platform with minimal change required to be done to the script. Beyond and above, the compiling time and speed for PHP is faster and more e_cient. 3.3 Database selection There are a variety of databases that we can select from the market. The widely used databases are Microsoft Access, Microsoft SQL, Oracle and MySQL. Looking at Microsoft Access, it does not encourage concurrent usage and it may be ine_cient, as the database needs to be saved into one _le. It is also unable to process high speed and large size database as compared to MySQL. In terms of costs, Oracle database requires a licensing fee but MySQL database is a freeware. In addition, MySQL database is easy to install, user friendly, reliable and is able to run on di_erent platforms. Moreover PHP can access MySQL database directly without the need to go through ODBC (Open Database Connectivity). To conclude, PHP script is able to run faster with MySQL database and the processing time will de_nitely be shorter. The pre-school does not require complex and costly software for its database management system hence MySQL is the ideal database for this project. 3.4 Web server selection After deciding on the scripting language and database, next is to select the web server that can support them. Web server is necessary for the delivery of web content to the web browser. As such, Apache HTTP server which has performance similar with other 'high-performance' server is considered
  • 8. Thereafter, research and actual testing have been performed to see the outcome of the various servers listed in the Figure below. These servers include PHP and MySQL in their installation packages thus allowing smoother and simpler download process. However, based on the performance and interface, Wamp or LAMP server is the preferred choice. Figure 3.2: Comparison of web servers
  • 9. Chapter 4 System Analysis and Design 4.1 Use case analysis In order to provide a clearer picture of the functionality provided by the student management module, we have done a use case analysis. Figure below is a use case diagram to present the functionality in the student management module.
  • 10. 4.2 System Design Under the existing student management module, the administrator has to _rst register the family. This includes the parent's particulars and home details. After submitting these data, the administrator will be directed to the student page whereby the student information is to be submitted. Figure below provides the interface of the existing student registration site. For easy navigation, the registration of the student and enrolment to the class has been combined into one process. Figure 4.2: Student registration process Besides the registration for a single student, there is a new feature added to the system. That is to 'export' bulk students from a class to another. This new feature is created to minimize the time required to register students to a new class. The school has many programs ranging from beginner to intermediate levels thus with this new feature, the administrator can easily enrol those students to their next level. The interface of this function is shown in Figure below.
  • 11. Figure 4.3: Export students module Other than the 'export' feature, the system has been modi_ed to allow a couple of search attributes at the family registration part. The name attribute includes the _rst and last name whereas contact number means mobile, o_ce and home number. Figure below present functionality at registration page. Figure 4.4: Search attributes for registration process Figure below present the functionality to add student to class module from the existing one.
  • 12. Figure 4.5: Enrol existing student to class For the attendance marking system the following functionality has been added Figure 4.6:
  • 13. Figure 4.6: Legend and attendance system In order to ful_l the second objective on minimizing human error, there are a few error checking functions being implemented for the student management module. Firstly, at the family registration page, all the _elds except the entry date, referral and remarks _elds have been coded to do validation check. This is to ensure that all the relevant information are collected and inserted into the database in an orderly manner. The contact _elds are designed to prompt an error message if none of the three _elds has been input. The school requires at least one valid number. In addition, contact number should not contain alphabets so this has been taken into consideration for the error checking. As for surname, name and nationality _elds, checks are implemented to make sure the _elds are not empty. On the other hand the postal code which should not contain alphabet; there will be message to alert any error as well. Other than error checks on family registration page, the student registration page also checks for the surname and name _elds. After retrieving the class details at the same
  • 14. page, users will be alerted if no class is selected for the enrolment. This is also implemented at the bulk student enrolment process. If the targeted class code is not provided, error message will appear. The codes for the system design are provided under Appendix A.
  • 15. Chapter 5 Database Design and Development 5.1 Database design Database is critical for all businesses. A good database does not allow any form of anomalies and stores only relevant information in an ordered manner. If a database has anomalies, it is a_ecting the e_ciency and data integrity. For example, delete anomaly arise upon the deletion of a row which also forces other useful data to be lost. As such, the tables need to be normalised. This ful_ls the last objective of ensuring data are accurate and retrieved correctly. For the database of this project, the tables are normalised to BCNF as shown below.admin(id,name,password) faculty(id,name, password) ATTENDANCE (student-class-id,class-date,status) Where ATTENDANCE.student-class-id mustexist in STUDENT- CLASS.id ATTENDANCE-CODE (attendance-code,attendance-status) CLASS-SCHEDULE(id, code,clientcode,clientname,educatorname, educatornric,cur- riculatheme,startdate,enddate,starttime,endtime) Where CLASS-SCHEDULE.codemustexist in CLIENT.code, CLASS-SCHEDULE.clientnamemustexist in CLIENT.name, CLASS-SCHEDULE.educatornric mustexistin EDUCATOR.nric, CLASS-SCHEDULE.educatornamemustexist in EDUCATOR.name And CLASS-SCHEDULE.curriculatheme mustexist in CURRICULA.theme CLASS-TIMETABLE (class-schedule-id,class-date) Where CLASS-TIMETABLE.class-schedule-id mustexistin CLASS- SCHEDULE.id CLIENT (code,name) CURRICULA (grp, theme) EDUCATOR(nric, name) (nric: National Registration Identity Card) FAMILY (id, entry-date, reg-fee, status, name, surname, nric, address1, address2, postal- code, contact-home, contact-o_ce, contact-hp, email, nationality, referred-by, remarks) STUDENT (id, family-id, name, surname, sex, dob, status)
  • 16. Where STUDENT.family-id must exist in FAMILY.id STUDENT-CLASS (id, student-id, class-schedule-id, remark) Where STUDENT-CLASS.student-id must exist in STUDENT.id And STUDENT-CLASS.class-schedule-id must exist in CLASS-SCHEDULE.id
  • 17. 5.2 Database development fter identifying the tables and columns of the database, the next step is to create them. Basically there are two ways to do so. The _rst option is to create them using commands. Below are some of the 'create' and 'insert' statements. The complete database code is provided under Appendix B. create table if not exists admin(aid char(50) not null primary key, aname char(50), apwd char(50)); insert into admin values('admin', 'admin', password('admin')); create table if not exists faculty(_d char(50) not null primary key, fname char(50), fpwd char(50)); insert into faculty values('faculty', 'faculty', password('faculty')); CREATE TABLE IF NOT EXISTS curricula (grp varchar(50) NOT NULL, theme var- char(50) NOT NULL, PRIMARY KEY (grp) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO curricula (grp, theme) VALUES ('1', 'Math'), ('2', 'Phy'), ('3', 'Che'), ('4', 'CSE'); The second option is to use phpMyAdmin. This is a Graphical User Interface (GUI) interface for building and maintaining the database which is included in the web server, XAMPP package. This is a simpler way to create the tables if one does not know the usage of commands. The _rst step is to create the database as shown in Figure below. The default storage engine in this MySQL server is InnoDB which has commit, rollback, and crash-recovery capabilities to protect user data. Following that is to create the tables in the database. Figure 5.1: Database creation in phpMyAdmin Figure below gives a view of the table creation.
  • 18. Figure 5.2: Table creation in phpMyAdmin Figure below shows the interface for creating the attributes in the table. Figure 5.3: Attribute creation in phpMyAdmin After completing the creation, Figure below depicts the contents of the database, providing information like the number of tables in the database and the number of records in eachof them. The MySQL server, phpMyAdmin, has many other features such as the deletion of tables, attributes and database. It also provides a mean for exporting or importing data into another database easily just by selecting the desired option seen at the top of the table in Figure below.
  • 19. Figure 5.4: Total number of tables in a database To view the data in one of the table, this can be done by clicking on the table name listed on the left menu as per Figure below. The _gure illustrates the educator table and there are three records in it. Figure 5.5: Data of one table
  • 20. Chapter 6 System and Database Testing 6.1 System and database testing Testing is the last phase of this project. This is the stage where it shows whether the system and database are working as desired. Otherwise, further recti_cation is required. Tests have been conducted and recorded below to show the results. Figure 6.1: Test
  • 21. Test 1 Purpose: Test the error checking functions Location: Family Registration Condition: All mandatory _elds need to be _lled up Result Figure 6.2: Test1
  • 22. Test 2 Purpose: Test the error checking functions Location: Family Registration Condition: At least one contact number is required Result: Figure 6.3: Test2
  • 23. Test 3 Purpose: Test the error checking functions Location: Family Registration Condition: Contact number should contain numbers only Result: Figure 6.4: Test3
  • 24. Test 4 Purpose: Test the error checking functions Location: Family Registration Condition: Email address must be valid Result: Figure 6.5: Test4
  • 25. Test 5 Purpose: Test the error checking functions Location: Family Registration Condition: Postal Code should contain numbers only Result: Figure 6.6: Test5
  • 26. Test 6 Purpose: Test the Search function Location: Family Registration Condition: No search value is input Result Figure 6.7: Test6
  • 27. Test 7 Purpose: Test the Search function Location: Family Registration Condition: Search using NRIC Result: Figure 6.8: Test7
  • 28. Test 8 Purpose: Test the Search function Location: Family Registration Condition: Search using any contact number Result: Figure 6.9: Test8
  • 29. Test 9 Purpose: Test the Search function Location: Family Registration Condition: Search using name Result: Figure 6.10: Test9
  • 30. Test 10 Purpose: Update of family details Location: Family Registration Database: Family table Condition: All data are valid Result: In the system: Figure 6.11: Test10
  • 31. Test 11 Purpose: Update of family details Location: Family Registration Database: Family table Condition: No update is done (status quo) Result: In the system: Figure 6.12: Test11
  • 32. Test 12 Purpose: Create family Location: Family Registration Database: Family table Condition: All data are valid Result:In the system: Figure 6.13: Test12 Test 13 Purpose: Create student (After creating the family) Location: Student Registration Condition: All mandatory _elds are required Figure 6.14: Test13 Test 14 Purpose: Create student (After creating the family) Location: Student Registration Condition: All mandatory _elds are required
  • 33. Result: Figure 6.15: Test14 Test 15 Purpose: Create student (After creating the family) Location: Student Registration Condition: Need to select the class after retrieve class Result: Figure 6.16: Test15
  • 34. Test 16 Purpose: Create student (After creating the family) Location: Student Registration Database: Student and Student-class tables Condition: All data are valid Result: In the system: Figure 6.17: Test16 Test 17 Purpose: Delete student Location: Student Registration Database: Student and Student-class tables Result: In the system: Figure 6.18: Test17 Test 18 Purpose: To test the export function Location: Export students Condition: A valid class code is required. Result: Figure 6.19: Test18
  • 35. Test 19 Purpose: To test the export function Location: Export students Database: Student-class table Condition: Selected student to be exported from TRY-01 to class TRY-02 Result: In the system Fig Figure 6.20: Test19 Test 20 Purpose: To test the list students function Location: List Student Database: Student and Family tables Condition: Search for students with name 'Bhai' and list out the family information Result: Figure 6.21: Test20 Test 21 Purpose: To test the list students function Location: List Student
  • 36. Database: Student and Family tables Condition: List all students in the school by the order of Date of Birth Result: Figure 6.22: Test21 Test 22 Purpose: To test the list students function Location: List Student Database: Student and Family tables Condition: List all students in the school by the order of Surname Result:
  • 37. Figure 6.23: Test22 Test 23 Purpose: To test the attendance taking function Location: Take Attendance Database: Attendance table
  • 38. Result: In the system:
  • 39. Chapter 7 Project Management 7.1 Work breakdown structure The Work Breakdown Structure provides a clear picture of the items that are required to be completed for the project work scope. It is arranged in a tree structure manner to show all sub-sections required to be accomplished in each phase throughout the project. 7.2 Risk management Every project has uncertainties and they may a_ect the project success. These uncertainties are known as risk. There is a need to determine the risks involved in the project to reduce the chance of its occurrence as well as develop a plan to either mitigate or avoid the risks that have been identi_ed. After identifying and determining the risks, they are recorded in a table called the risk assessment matrix. This matrix lists the severity which is also known as the impact level in terms of High, Medium and Low. In addition to those details, the action plan that can be taken for each of the risks is clearly stated too. Figure 7.1: Risk Assessment Matrix
  • 40. Chapter 8 Conclusions 8.1 Conclusions Simplicity is never simple. As we have seen in this project, the process of creating a user-friendly and straightforward platform that facilitates the administrator's job is one _lled with complexity. From understanding user requirements to system design and _nally system prototype and _nalization, every step requires in-depth understanding and commitment towards achieving the objectives of the project. Although the student database management module is not fully integrated to the system and used on real time, the system prototype demonstrates easy navigation and data are stored in a systematic way. Overall, e_ciency has improved and work processes simpli_ed. Although all the objectives have been met, the system still has room for improvement. The system is robust and exible enough for future upgrade using advanced technology and devices
  • 41. Chapter 9 Critical Reviews 9.1 Critical reviews In the process of doing this project, obstacles have been encountered. I have learnt to be more exible in resolving issues. One of the situations that I have faced was when I had installed MySQL server, but it did not work. Then I tried to troubleshoot, research online and did a couple of re-installation but to no avail. Then I installed XAMPP, it did not work out too. Some how I did get rid of this problem but I did not like XAMPP server. Therefore I decided to install LAMP server. Yes it worked _ne. At the end I found that I had installed multiple server and hence system was confused which server is to be used i.e. conicts with MySQL. Then I stopped all server running on my laptop and decicded to start only LAMP server and it worked _ne. Being a novice in PHP language, I had di_culty in understanding the basic to write php _les. Therefore I took longer time to understand how and why PHP works. I researched too much online. Went through several examples, tutorials etc. Still I am not good enough in PHP language. In this entire project I have used only PHP and HTML languages. but later I realized that there are multiple laguages which can support in designing a good database project. Those are CSS, JavaScript. There may be more but trully speeking I really don't know any more. Eventually with more hands-on exposure throughout this project, I managed to gain some understanding of PHP language. Discipline played an important role for the completion of this project. Using the project management skills taught in class, I was able to apply them to this project. Besides project management skills, I had also applied the database knowledge that I had learnt in the class to this project. From analysing of database structure and their relations to creating the database and tables, all these have strengthened my understanding. However when doing part of the codes, I would still research online and _nd solutions, for example, the usage of 'Ignore' command to avoid duplication of data from inserting into the database. This command did not work on MyISAM storage engine thus I had to change my database storage to InnoDB in order for that to work. Overall though the project was _lled with challenges, it had given me opportunity to apply and strengthen my knowledge as well as gain new knowledge and skill through researches and experienced professionals whom I am fortunate enough to encounter.
  ็ฟป่ฏ‘๏ผš