DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

CHAPTER III

SYSTEM DESIGN AND DEVELOPMENT

This chapter discusses the feasibility study of the proposed system and the software methodology used in developing the system. This chapter also discusses the GUI (Graphical User Interface), Data Dictionary and the HIPO that identifies the processing step to produce an output.

3.2 Project Design This section discusses the applicant’s proposed system, the programming language to be utilize, the graphical user interface and program functions and data dictionary.

3.2.1 System Introduction The Inquiry System is a system software application that will help the Registrar’s Office of Dualtech Center to manage the records of the applicants and the students easily.

18

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

3.2.2 Fabrication or Development Procedure

Fig. 3.0 System Development Life Cycle (SDLC)

19

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

System Development Life Cycle (SDLC) modified with feedback at every stage. This model is using an embedded real time system projects. The proponents followed the interrelated steps of the System Development Life Cycle. In System Planning phase, it describes what is being built and why it is being built. In System Analysis phase, it defines users needs, understands the problem, and establishing functional requirements. In System Design phase, defines users’ needs and transforms to detailed/final systems specifications. Plans and designs the specific details and mechanics of system

element: input, process, output, and storage. These detailed and final systems specifications, when approved by management, will serve as the blueprint for building and installing the system. In System Development phase, during systems development the system design formulated during the systems analysis and design phase is transformed into a working system which meets user requirements.

In System Implementation phase, users and operations personnel are provided training and hands-on experience on running the system. Training should emphasize that the

new system is their system and was designed to help them do their work better and faster, not to replace them.

20

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT In System Maintenance phase, is the final stage in the System Development Life
Cycle. It involves the revision of some or all the functions and procedures of the existing

system. This is mainly brought about by changes in the systems environment.

3.2.3 Graphical User Interface (GUI) An interface for issuing commands to a computer utilizing a pointing device such as a mouse that manipulates and activates graphical images on a monitor.

Fig. 3.2 Admin Login Form

21

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

Click this button to go to the main form

Click this button to exit to the log in form

Fig. 3.5 Admin Main Menu Form

22

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

Click the Search by Name button to search students by name or surname.

Click the Search by Sections button to search students by sections.

Click the Search by Scholarship button to search students by scholarship programs.

Click the New Applicant button to add records of the new applicants.

Click the Exit button to Exit on the form.

23

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

Click the Edit button to Edit Name, Section, and Scholarship

Click the Save button to Save information to database

Click the Delete button to Delete information from the database

24

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

25

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

3.2.4 Data Dictionary Table 3.6 shows the database tables and its names, data types and description. Table 3.6 Data Dictionary

Name of Data Field Name Description Data Type Length Purpose

Search by Name Search_by_Name Searching by Name Varchar 30 Search the record of the students according to name

26

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

Name of Data Field Name Description Data Type Length Purpose

Search by Section Search_by_Section Searching by Section Int 10 Search the record of the students according to section

Name of Data Field Name Description Data Type Length Purpose

Search by Scholarship Search_by_Scholarship Searching the records by scholarship Varchar 40 Search the record of the students according to their scholarship program

Name of Data Field Name Description Data Type Length Purpose

New Applicant New_Applicant Adding new applicant Text 50 Adding new applicant and its information to the system

27

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

Name of Data Field Name Description Data Type Length Purpose

Edit Edit Edit records Varchar 30 To edit each information of the students in the system

The table 3.6 shows the data dictionary of database of the proposed system which includes field name, data type, and number of characters.

3.3 Data Cycle Data Cycle is the first collection of data and its process to convert it into useful information. The data is process repeatedly until the accurate result is achieved.

3.3.1 Hierarchal Input Process Output (HIPO) HIPO is flow-charting technique that provides a graphical method for designing and documenting programs. It was use to develop requirements, construct the design, and support implementation of a system to demonstrate the Inquiry System.

28

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

Fig. 3.6 Hierarchal Input Process Output (HIPO)

29

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

30

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

Fig. 4.0 Hierarchal Input Process Output (HIPO)

31

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

3.3.2 Input Process Output (IPO) This section describes the system activities starting from the input, its process, until it gives the output of the database.

Module Name Called by: Calls/Invokes Input Process Output

Start up Menu Admin Main Form Mouse Click Wait for the admin to log in Admin log in window

Module Name Called by: Calls/Invokes Input Process Output

Admin Main menu Search by Name None Mouse Click Click the button to search by name Records sorted by name

32

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

Module Name Called by: Calls/Invokes Input Process Output

Admin Main Menu Search by Section None Mouse Click Click the button to search by section Records sorted by section

Module Name Called by: Calls/Invokes Input Process Output

Admin Main Menu Search by Scholarship None Mouse Click Click the button to search by scholarship Records sorted by scholarship program

33

DON BOSCO COLLEGE CANLUBANG COLLEGE DEPARTMENT

Module Name Called by: Calls/Invokes Input Process Output Module Name Called by: Calls/Invokes Input Process Output

Admin Main Menu New Applicant None Mouse Click Click to add new students’ information New applicant information Admin Main Menu New Applicant None Mouse Click Click to add new students’ information New applicant information

Module Name Called by: Calls/Invokes Input Process Output

Admin Main Menu Exit None Mouse Click Click button to go back to Main Menu Exit

34