sistem pen gurus an sekolah banang jaya

Upload: ashutz

Post on 10-Apr-2018

246 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    1/27

    SISTEM PENGURUSAN SEKOLAH BANANG JAYA

    NOR HANISAH BT. MOHAM AD

    This report is submitted in partial fulfillment of the requirements for theBachelor of Computer Science (Database Management)

    FACULTY OF INFORMATION AN D COM MUNICATION TECHNOLOGYUNIVERSITI TEKNIKAL MALAYSIA MELAKA

    2008

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    2/27

    ABSTRACT

    Sistem Pentadbiran Sekolah Banang Jaya shifts the education's system to thelatest technology where management becomes easier, quicker and more efficient. SistemPentadbiran Sekolah Banang Jqya,(SPSBJ) is a complete web-based system foradministrators, teachers, parents and students, to help schools improve the quality ofeducation, increase student performance and better communicate with parents. Itsflexible features that support multiple users, enabling them to record, access reports, aswell as manage their student data, and performance records in real-time. Besides that,SPSBJ is able to support decision making which will lessen the work of decision makeras they only need to review and approve the decision. The weakness of the currentsystem that is slow, not user friendly, not flexible, devoid of discipline module make thecurrent system not more efficient. This project is focus on admin module and disciplinemodule and school administration and discipline teacher as target user. Using IterativeLifecycle methodology, this system is developed using PHP and MySQL as database.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    3/27

    ABSTRAK

    Sistem Penurusan Sekolah Banang Jaya menggerakkan sistem pendidikankepada teknologi terbaru di mana pengurusan menjadi lebih mudah, cepat dan berkesan.Pengurusan Sekolah Banang Jaya(SPSBJ) adalah sistem yang berasaskan websepenuhnya untuk para pentadbir, guru, ibu bapa dan pelajar, untuk membantumemperbaiki kualiti pendidikan di sekolah, menambah prestasi pelajar dan komunikasiyang lebih baik dengan ibu bapa. Ciri-ciri yang fleksibel yang menyokong pelbagaipengguna, membolehkan mereka merekod, mencapai laporan, serta menguruskan datapelajar dan rekod pencapaian di masa semasa. . Selain itu, SPSBJ turut menyokongdalam membuat keputusan yang mana banyak mengurangkan kerja pembuat keputusandi mana mereka hanya perlu bersetuju dengan keputusan yang dilakukan oleh sistem.Masalah sistem semasa yang lambat, tidak mesra pengguna, tidak fleksible, sertaketiadaan modul disiplin menjadikan sistem semasa menjadi tidak efficient. Sk opprojek ini lebih tertumpu kepada modul pentadbiran dan modul disiplin serta pihakpentadbir sekolah serta guru disiplin sebagai sko p pengguna.Menggunakan metodologiIterative LgecycZe sistem ini dibangunkan menggunakan bahasa pengaturcaraan PHPdan M ySQL sebagai perisian pangkalan data.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    4/27

    CHAPTER I

    INTRODUCTION

    1.1 Project Background

    Education is central to development and a key to attaining the millenniumdevelopment goals. It is one of the most powefil instruments for reducing poverty andinequality and lays a foundation for sustained economic growth. Both individuals andcountries get benefit from education process. For individuals, the potential benefits layin general quality of life and in the economic returns of sustained, satisfyingemployment. For countries, the potential benefits lie in economic growth and thedevelopment of shared values that underpin social cohesion.

    Sistem Pengurusan Sekolah Banang Jaya (SPSBJ) will be developed under theeducation industry. With SPSBJ, education management will move to the latesttechnology where transactions can be done online and management is more flexible andmanageable. SPSBJ is proposed to assist all the basic functions (add, update, delete,search) added with report generator. In addition, SPSBJ will support decision making indetermine the punishment of discipline problem based on demerit point.

    Sistem Pengurusan SekoIah Banang Jaya (SPSBJ) is an online system forSekolah Banang Jaya that will integrate the current system used; 'Sistem Maklumat

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    5/27

    Murid' (SMM) and Education Management and Information System (EMIS) where bothsystems are currently being used by Malaysia Education Ministry. SPSBJ will bedeveloped in PHP scripts with Apache as the application server and MysQL as thedatabase server. It will focus on student's educational information profiles of schools,teachers and students, and students achievements such as exam marks, discipline and cocurriculum and also attendance for the student. SPSBJ also provide interaction amongparent and teacher about the information of student discipline with each parent will beregistered and information their children only can be accessed.

    1.2 Problem Statemen (s)

    From the analysis that has been made on the current systems, few problems wereidentified which are:

    i. Performance of the current systems are slow and not eflcientTwo different systems to manage information of a school make the currentsystems' management becomes slower and not efficient. Some data were foundto be redundant where user has to enter the same data in both systems. Inaddition, teachers still need to use the traditional filling method.

    ii. Constrains in accessibilityUsers can access the system from certain places only and different workstationwill have different databases and results.

    iii. Poor access controlNon effective access control is provided on the current systems where anybodycan access the system and do transactions. Furthermore, add, edit and view aredone on the same form which may cause lack of data availability and integrity.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    6/27

    iv. Does not have student discipline managementThe current system there was no module for student discipline managementwhere this module can be using by discipline teacher to manage and monitorstudent discipline performance.

    v. Fixed contentAll data and contents of both current systems are fixed which means system willneed to be updated, or reprogrammed if there is any additional change in contentor data.

    vi. Communication between teacher andparents.Parent has limited time to spend with their child teacher to discuss about childreneducation performance and discipline problem.

    13 Objective

    SPSBJ is a new system that is developed based on the problems arises on thecurrent systems. The objectives of SPSBJ are:

    J . To make data processing and accessing asterIntegrating both of the systems avoids data redundancy which will make betterand faster data processing and accessing. This will make the traditional fillingmethod unnecessary.

    ii. To make the system onlineSPSBJ is accessible anywhere if a specific machine (computer) has an internetconnection; all data are stored in the same database.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    7/27

    iii. To support access controlFor security purpose, SPSBJ appears with login function where all users willneed an ID to access the system. In addition, SPSBJ differentiate forms foradding, updating and searching functions according to the access level.

    iv. Togenerate student's discipline reportsSPSBJ will automatically analyze specific records and generate reports assistedwith graphs.

    v. Backup and RecoveryExisting system do not have backup for making copies of database so that theseadditional copies may be used to restore the original after a data loss event.Backup are useful primary for purpose to restore state following a disaster thatcalled as disaster recovery and the second purpose when is it using to restoresmall number of files or full backup database after they have been accidentallydeleted or corrupted.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    8/27

    1.4 Scope

    This section will explain the scopes of Sistem Pengurusun Sekolah Banang Jayaincluding the target users, modules of the system, where to implement and specificplatform used.

    1.4.1 TargetUser

    i. Discipline TeacherTeachers can do the transactions (add, update, delete, search) for studentsdiscipline details and view reports of students in the school.

    ii. School AdministratorThis level of user consists of school's administrators (Headmaster / headmistress/ principle, vice principals). These users can do transactions of teachers' as wellas viewing students' report and graph. School administrator also can use role andprivileges knction to divide and control user access. Administrator also canmonitor user of this system using transaction log

    1.4.2 Modules

    i. Manage Student DisciplineSPSBJ manage student discipline. Teacher can update discipline informationsuch as demerit point; category of discipline problem and etc. Teacher also cancreate report for the student and the Decision Support System (DSS) willdetermine type of punishment based on demerit point. Administrator can addnew discipline problem, update or delete the discipline information, so thatparents and schools can efficiently manage and track the discipline level of

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    9/27

    students. SPSBJ is able to analyze student's discipline achievements andgenerate reports

    ii. Adm in moduleAdministrator is able to do backup and recovery. Mainly purpose of backup is torestore a state following a disaster (called disaster recovery). The second is torestore small numbers of files after they have been accidentally deleted orcorrupted. (en.wikipedia.orghviki/Backup-anddRecovery,2008). ~dministrator can use role andprivileges function to divide and control user access and also can monitor user ofthis system using transaction log.

    1.5 Project Significance

    As mentioned in the problem statement, the current systems used are stand alonesystems. SPSBJ is developed in order to make the system online and will be accessiblefrom anywhere that has internet connection. In addition, integrating both of the currentsystems will cover the data redundancy and make data processing and accessing faster.

    SPSBJ is a system that can manage student's educational information effectively.This project more focuses in discipline module and admin module. SPSBJ can generatereports from student's discipline record and keep track with the current and previousdiscipline records. Furthermore, this system will support decision making in determinetype of punishment based on demerit point.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    10/27

    1.6 Expected O utput

    It is expected that SPSBJ will facilitates the management of all information asstated above excellently, support decision making in determine type of punishment, andall reports and analysis should be able to be printed. Besides, the system must have auser-friendly interface to simplifL all kind of users to use and understand the system.

    1.7 Conclusion

    This chapter has introduced the project in its background, objectives, scopes, aswell as the project significant and expected output. It's purposed to clarify introductiondevelopment for the project. The next activity to be carried out is to complete thechapter 11.

    Chapter I1 consists of fact and finding, project methodology, projectrequirements and project schedules and milestones. In order to complete this chapter, alot of effort needs to be done on research about proposed title, including study on relatedjournals, research reports, and articles.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    11/27

    CHAPTER I1

    LITERATURE REVIEW AND PROJECT METHODOLOGY

    2.1 Introduction

    This chapter will discuss about literature review and project methodology that isrelated to the project. A literature review is a body of text that aims to review the criticalpoints of current knowledge on a particular topic.

    According to Cooper (1988), a literature review uses as its database reports ofprimary or original scholarship, and does not report new primary scholarship itself. Theprimary reports used in the literature may be verbal, but in the vast majority of casesreports are written documents. The types of scholarship may be empirical, theoretical,critical/analytic, or methodological in nature. Second a literature review seeks todescribe, summarize, evaluate, clarify and/or integrate the content of primary reports(Wikipedia).

    Therefore, researches and analysis an existing system or current system have tobe done in order to build a good system. Good system always comes after enhancementof existing system. For this project, literature review serves the purpose of gatheringinformation related to the development of web-based house rental advertising system.This review will focus on the current existing system. The result of the review will serve

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    12/27

    to better equip the developer with knowledge relevant or essential in the design andplanning of the system. It will also discuss the approach that will be used for this projectand related research and information about the approach, methodology and tools thatwill be used to develop this project.

    2.2 Facts and Findings

    This section will discuss about facts and findings that are related to thedevelopment of this project. It will explain mainly on the system's domain, existingsystems and techniques that are applicable but not used for the development of SPSBJ.

    2.2.1 Domain

    Due to the many general terms used for these sub-chapters, domain for thisanalysis references might be defined as a realm or range of knowledge. After someresearch and finding process, the domain of this project is more concentrate on datamanagement and administration and it is targeted to be used at primary schools.

    2.2.2 Existing System

    This section will discuss related systems that existed which are used asreferences. Fifth existing systems are chosen. The first system is School ManagementSystem by Headmastersoft. The second system is Online School Management Systemby TMS Solutions. The third system is 'Sistem Maklumat Murid' by SK Chukai ,Kemaman. Finally, Student's Educational Information Management System (SEIMS) byfaisal imran.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    13/27

    2.2.2.1 Case Study 1School Management System (SManS) by Headmastersoft is a standalone system

    developed in Visual Basic environment with Microsoft Access database. The systemoffered in 3 packages, Basic (free), Pro (purchase) and Unlimited Custom Pack(purchase) and is downloadable at http:lheadmastersoft.com.

    SManS is targeted to be used by teachers in managing school's information. Itcovers student information management and enrollment,class informationmanagement, teacher information management, attendance control, staff informationmanagement and reporting.

    The interfaces used for this system is attractive and also user-friendly. Theknctions developed are usehl where it has class, student, teacher and employee'senrollment. In addition, user can also store pictures at the profiles section and reportscan be generated.

    However, this system is more practical for private school management because itkeeps employees information. Stand alone based system that used is not suitable forthese days where people tend to move to online systems. Not to mention that this systemdoes not support any decision making.

    Figure 2.1 represents the main screen of the School Management System.

    Nevr Vicw Took Reports Heb

    I Figure 2.1: Sample Interface of SManS

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    14/27

    2.2.2.2 Case Study 2

    TMS School Management System is a web-based system for administrators,teachers, parents and students. It aims to help schools improve the quality of education,increase student performance and better communicate with parents. Besides, TMSSchool Management System is able to support multiple users and schools, enabling themto record, access reports, as well as manage their student and employee data, andperformance records in real-time.

    This system is intended for schools in Malaysia. It is developed using Java and issupported on PC web browser, PDA web browser and WAP web browser. The modulesthat are applicable are Registration Management, Class Management, ECA ClubManagement, Marks Management, Financial & Human Resource Management, AccessControl & Security Management, Disciplinary Management, AdministrationManagement, Facility & Asset Management, Learning Management, Collaboration &Knowledge Management and Hostel Management Module. This system can be viewedat http://www.tmsasia.com.

    TMS School Management System is one of a good system that has been found. Itis a system that is accessible through PC, PDA and WAP browser and supported lots offunctions which covers most of information and management needed for a school.

    On the other hand, as the system is more to commercial sector, it did not focuson what truly needed by a school. It also focuses more on management for a secondaryschool, does not produce reports and does not support decision making.

    Figure 2.2 represents the main screen of the TMS School Management System

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    15/27

    NG SEKOLAH PINTAR . LllF.0r0

    Figure 2.2: Sample Interface of TMS School Management System

    2.2.2.3 Case Study 3

    Sistem Maklumat Murid is a computerized student information system. Thissystem is developed by Tuan Haji Mohd Yusof b. Muda when he becomes headmasterof Sekolah Kebangsaan Seri Kemaman at 2000. Important for school to usedcomputerized student information system because in this way, student name are not beenkey in so many time for each transaction. Furthermore, searching can be faster. It makesschool management more efficient and dynamic.This system is capable to update student information. Beside that this systemfacilitates student daily attendance and will be send warning letter if student are absentmore than three day via third party system which is Sistem Merit Demerit.

    However, Stand alone based system that used is not suitable for these days wherepeople tend to move to online systems. Disadvantage of this system is this system isdepending to other system such as Sistem Merit Demerit and Sistem Laporan AdabBelajar to produce report, warning letter and etc.

    Figure 2.3 represents the main screen of the Sistem Maklumat Pelajar (SMM)

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    16/27

    BKKUP DATAlMPORT DATCI

    REKODMURID TPMUN 6BORANGP.U. 275PENRIMA RUTPEMRIMA SPBT

    SEKOLAH KEBANGSAAN CHUM124000 ICEMAMAN

    ESE) @LA'+VEP.DAH VCPJ.0

    MENU UTAMA

    Figure 23: Sample Interface of SM M

    2.2.2.5Case Study 4

    Student's Educational Information Management System (SEIMS) is a projectproposed by Faisal Imran, a 3d batch student of Bachelor of Computer Science(Software Engineering), UTeM. The project was developed in PHP environment andMySQL as the database. The system should cover the report student information, recordstudent grade, and record school information also generates report functions. The systemwill also use decision support system @SS) concept for 'Program Head Count' andsorting students into future classes.

    Unfortunately, due to some reasons, the some function of the system had failedto function and be executed hence making the author not able to view how any of the

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    17/27

    functions work. However, from the report documented, the overview is good and is usedas the guideline for this project.

    2.2.2.6 Conclusion

    Four systems had been chosen as case study, differentiate and justified. Theresearch process is quite tough and difficult as some of the systems do not have anyjustification or clarification on how to use. Some also being commercialized and did nothave any demo 1 trial version. However, all systems are good systems; some have user-friendly interfaces, contain lots of useful functions and have much more benefits whichcan be used as review and references.

    2.23 Technique

    During the development of this project, there are several techniques that hadbeen applied to get as much as information as a guide in develop this system. Sourcesare collected from journals, books, electronic resource, questionnaires and observation.

    In developing the system, AppServ software will be used in term of designingand implementing code. Database will be created by using MySQL syntax while theprogramming languages are based on PHP (Pre-Hypertext Processor). MacromediaDreamweaver MX is used to implement PHP programming language. Apache server hadbeen chosen as a platform in which the system will run. Image manipulation and imageediting will be done by using Adobe Photoshop CS.

    Observation to the existing system is also done to get the reality of disciplinemanagement environment. There were some reviews of other management system asreferences. From the review, there is a lot of information and data that is useful.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    18/27

    2.23.1 Sewer-Side Scripting

    Server-side scripting is a web server technology in which a user's request isfulfilled by running a script directly on the web server to generate dynamic HTMLpages. It is usually used to provide interactive web sites that interface to databases orother data stores. The primary advantage to server-side scripting is the ability to highlycustomize the response based on the user's requirements, access rights, or queries intodata stores. (Wikipedia)

    Realizing the security that offers by server-side scripting, SPSBJ uses PHPscripting language for the development. PHP is a widely-used general-purpose scriptinglanguage that is especially suited for web development and can be embedded intoHTML. PHP generally runs on a web server, taking PHP code as its input and creatingweb pages as output, however it can also be used for command-line scripting and client-side GUI applications. PHP can be deployed on most web servers and on almost everyoperating system and platform free of charge.

    2.2.3.2 Decision Support System

    The approach to be implemented is the Decision Support System, DSS.According to Rob and Coronel DSS is an arrangement of computerized tools used toassist managerial decision making within a business. A DSS usually requires extensivedata "massaging" to produce information. The DSS is used at all level within anorganization and is often tailored to focus on specific business areas or problems such asfinance, insurance, healthcare, banking, sales, and manufacturing(Wikipedia).

    The DSS is interactive and provides ad hoc query tools to retrieve data and todisplay data in different formats. For example, a DSS operator might to; compare therelative rates of productivity growth by company division over some specified period oftime. Define the relationship between advertising types and sales levels. This

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    19/27

    relationship might then be used for forecasting. Define relative market shares by selectedproduct lines.

    Figure 2.4 below shows four (4) main components: a data store component, adata extraction and filtering component, an end-user query tool, and an end-userpresentation tool. Data store component is basically DSS database. It is contains two (2)types of data: business data and business model data. Business Data are extracting fromthe operational database and from external data sources.

    mmIdata I DataextractinghEEzzL and filtering

    DSS

    Datastore Endiserquery toolEnduserpresentatontod

    Figure 2.4: Main com ponents of a Decision Support System, DSS

    Business Data summarize and arrange the operational in structures that areoptimize for data analysis and query speed. Business model data are generated byspecial algorithms to model the business to identify and enhance the understanding ofbusiness situations and problems.

    The data extraction and data filtering component is used to extract and validatethe data taken from the operational database and the external data source. The end- userquery tool is use by the data analyst to create the queries that access the database.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    20/27

    Depending on the DSS implementation, the query tool accesses either the operationaldatabase, or more commonly, the DSS database.

    This tool advises the user on which data to select and how to build the reliablebusiness data model. The end-user presentation tool is used by the data analyst toorganize and present the data. This tool helps the end user select the most appropriatepresentation format for report such as graph or chart. The query tool and the presentationtool are the front end to the DSS.

    2.23.3 Gathering info to develop the system

    i. ResearchSome research is made to understand the requirements of this system. Some of theschool management systems are studies to learn how it fimctions. The technique todevelop the system requires meeting with the project requirements.

    ii. InterviewAn interview is conducted with the user of the school management systems. Some of theinformation was obtained from the people who often used the system. The informationgathered will be analyzed in the requirements of the system.

    i i i . Software UsedThe software that will be used is decided based on the system requirements. Thesoftware chosen is very important because it determines the success in developing thesystem.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    21/27

    2.3 Project Methodology

    Methodology is a codified set of practices (sometimes accompanied by trainingmaterials, formal educational programs, worksheets, and diagramming tools) that maybe repeatable carried out to produce software. It is a set of guidelines, standards andprocesses that is involved and followed explicitly in order to yield a product or software.In order to produce quality and reliable software, a well-defined methodology forachieving those results is important. With a methodology, the process of achieving resultcan be studied and verified. By implementing suitable methodology in constructingSPSBJ, it can ensure that the objectives and requirements of the project are achieved andmet.

    23.1 Approach

    Structured Systems Analysis and Design Method (SSADM) will be the approachto the analysis and design of the system. SSADM is used because the use of adisciplined engineering approach will eventually improve the quality of the systemproduced.

    2.3.2 Software Development Life Cycle (SDLC)

    The System Development Life Cycle (SDLC) is a general framework throughwhich you can track and come to understand the activities required to develop andmaintain information. Within the framework, there are different ways to completevarious task specified in the SDLC. In this project, the Sistem Pengurusan SekolahBanang Jaya will be developed using Iterative lifecycle model in order to achieve thepredetermined project objective.

    An iterative lifecycle model cyclical software development process developed inresponse to the weaknesses of the waterfall model. It is an essential part of the Rational

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    22/27

    Unified Process, the Dynamic Systems Development Method, Extreme Programmingand generally the agile software development frameworks. It does not attempt to startwith a full specification of requirements. Instead, development begins by specifying andimplementing ust part of the software, which can then be reviewed in order to identifyfurther requirements. This process is then repeated, producing a new version of thesoftware for each cycle of the model.

    An iterative lifecycle model consists of repeating the following four phases insequence:

    i. Requirements phase, in this stage, the project requirement for SIMS project isgathered by interview with the kindergarten owner and staff. All the informationwill be analyzed. Iteration should eventually result in a requirements phase thatproduces a complete and final specification of requirements.

    ii. A Design phase, in which a software solution to meet the requirements isdesigned. This is an extension of an earlier design.

    i i i . An Implementation and Test phase, when the software is coded, integrated andtested by the user.

    iv.A Review phase, in which the software is evaluated, the current requirements arereviewed, and changes and additions to requirements proposed.

    For each cycle of the model, a decision has to be made as to whether the systemproduced by the cycle will be discarded, or kept as a starting point for the next cycle(sometimes referred to as incremental prototyping). Eventually a point will be reachedwhere the requirements are complete and the software can be delivered, or it becomesimpossible to enhance the software as required, and a k s h start has to be made.

    The Iterative Lifecycle model is choosing because Iterative development slicesthe deliverable business value (system hnctionality) into iterations. Each iteration aslice of functionality is delivered through crossdiscipline work, starting from themodel/requirements through to the testing/deployment.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    23/27

    Figure 2.5 shows main component that involve in Iterative Lifecycle Model whichis Requirement stage, Design stage, Implementation and Test stage and also ReviewStage

    Start IRequirements Design

    ImplementationiComplete

    1 IFigure 2.5: Iterative Lifecycle Model

    2.33 Database Life CycleWithin the larger information system, the database, too, is subject to a life cycle.

    The Database Life Cycle (DBLC) contains six phases; database initial study, databasedesign, implementing and loading, testing and evaluation, operation, maintenance andevolution.

    Figure 2.6 shows stage of Database Life Cycle (DBLC)

    Figure 2.6: Database Life Cycle (DBLC)

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    24/27

    a) Database initial studyThe overall purpose of the database initial study is to analyze the companysituation such as operating environment or organized structure. Besides that thisphase define problems and constraint, objectives and lastly define the scope andboundaries. Figure 2.7 depicts the interactive and iterative process required tocomplete the first phase of DBLC successfully.

    I IFigure 2.7: A summary of activities in th e database initial study

    b) Database designThe second phase focuses on the design of the database model that will supportcompany operation and objectively. At this point, there are two views of the datawithin the system: the business views of data as a source of information and thedesigner's view of the data structure, its access, and the activities required totransform the data into information. The two views of data are depicted in figure2.8.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    25/27

    Manapersviewa.oa me p o L Y w4 W7mtore Iha solutions?a m nfamatlon is neededmlmplemant tha tolutlons?4 Wnaf data a re required topenwat* tha desired Infacmotlon?

    Figure 2.8: Twoviews of data: business manager and designer

    c) Implementing and loadingIn modem RDBMS, anew database implementation requires the creation ofspecial storage-related constructs to house the end-user tables. The constructsusually include the storage group, the table space and the tables. During theimplementation and loading phase, others issues must be address such asperformance, security, backup and recovery, integrity and company standards.

    d) Testing and evaluationIn this phase database is tested and fine-tuned for performances, integrity, andconcurrent access and security constraints. Test processing is done in parallelwith application programming. If the database implementation fails to meet someof the system's evaluation criteria, several options may be considered to enhancethe system such as fine tuning based on reference manuals, modification ofphysical design, modification of logical design and upgrade or charge DBMSsoftware and hardware.

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    26/27

    e) OperationOnce the database has passed the evaluation stage, it is considered to beoperational. At that point, the database, its management, its user and itsapplication programs constitute a complete information system the beginning ofthe operational phase invariably starts the process of system evolution. As soonas all the targeted end users have entered the operations phase, problems thatcould not have been foreseen during the testing phase begin to surface.

    f) Maintenance and evolutionSome of the required periodic maintenance activities include preventivemaintenance 9backup), corrective maintenance (recovery), adaptivemaintenance, assignment of access permissions and their maintenance for newand old users, generation of database access statistic to monitor performance,periodic security audits based on system-generated statistics and the periodicsystem usage-summaries.

    2.4 Project Requirements

    This section will state the software and hardware that are required for thisproject.

    2.4.1 Software Requirement

    Software requirements mention the software applications and programminglanguage that are needed for the development of the project are listed in Table 2.1

  • 8/8/2019 Sistem Pen Gurus An Sekolah Banang Jaya

    27/27

    Table 2.1: Software Specification

    2.1.1 Hardware RequirementHardware requirements mention the hardware components and peripherals that

    are needed for the development of the project.Desktop PC- Processor Intel Pentium 4- 512MBram- Hardisk 10 GB space

    - Network Card- Printer

    DescriptionDatabase in WindowsOperating System in WindowsDesign ToolsInterface ToolsWeb ServerWeb BrowserServer Site Scripting

    No.1 .2.3.4.5.6 .

    7

    2.1.2 Other RequirementNetwork connection (internet) is needed.

    SoftwareMySQLWindows XP ProfesionalAdobe Photoshop CS2Macromedia DreamweaverApacheInternet ExplorerPHP