COLLEGE OF COMPUTER STUDIES NOTRE DAME UNIVERSITY NOTRE DAME AVENUE, COTABATO CITY 9600, PHILIPPINES Online Computer Assisted Survey System Database Management System IT322 A PROJECT Presented to the Faculty of College of Computer Studies Notre Dame University Cotabato City In Partial Fulfillment of the requirements for the Degree BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY SUBMITTED BY: IGNEY DONIS S. LU SAJEED ZAINAL SUBMITTED TO: Prof. Martina P.

Tagacay INSTRUCTOR January, 2012 1CHAPTER I INTRODUCTION The need for Computer Assisted Survey information System has been a helping hand in acquiring Amount of data needed for a particular Research or Study. Conducting Surveys from The past requires more Time to tabulate amounts of data in the survey. Scanning questionnaires is a method of data collection that can be used with paper questionnaires that have been administered in face-to-face interviews; mail surveys or surveys completed by an Interviewer over the telephone.The method used in the office of The University Research Center is The SPSS (originally, Statistical Package for the Social Sciences) where thesystem reads the encoded or databases of a Conducted system.

1. 1Purpose of this document The Online Computer Assisted Survey Entry System generally helps the surveyor to Cross tabulate and Compute. inthe processing of data. The System can be used by researchers in any social sciences. However, the design is intended for the NDU-University Research Center Can used The System Developed.

1. 2Scope of this documentThe System Allow the Surveyor enters the Respondents answer to the Survey. Decreases the amount of time needed to calculate the results in the Conducted activity. The system can generate a report for the researcher. 1.

3 Overview The user can browse View Summary Reports of the Survey. The system monitor the amount of Respondents. Can generate a report. Manual Tabulation & calculation is Eliminated in the Process. 1. 4Business Context the Socio-Economic Research Center (SERC) was established in 1972 as the research arm of Notre Dame       University.

Through the years, SERC has engaged in research and other information generation activities    useful for private agencies and    government in Central Mindanao and the Autonomous Region in Muslim Mindanao (ARMM) regions in        program planning, formulation and implementation. In 1996, the University Research     Center (URC) was formed to consolidate all research units in the university into one. The URC now comprise Socio-Economic  Research Center (SERC); Institutional    Research Development (IRD); and Databank (DB). Engage in collaboration and multi- disciplinary researches on human development, representing a wide range of disciplines: anthropology, humanities, history, sociology, economics, peace     education, religion, political science, etc.

* Provide professional and consultancy services on research, project proposal development, program  monitoring and evaluation, computerization and data analysis and other related services. * Promote dissemination of research findings to a wide variety of relevant audiences through forum, conferences and documentationsPresident ORGANIZATIONAL CHART VPAA Executive Director Research Associate Research Associate Research Assistant Research Assistant Secretary CHAPTER II GENERAL DESCRIPTION 2. 1Product Functions Log-in Form = the form where the user must log-in in order to gain access to the software. Main-Form= where the user can access the set of questions for the survey.

2. 2Similar System Information The Old System used in the University Research Center is Software made not specifically for creating questions.The SPSS(originally, Statistical Package for the Social Sciences) is widely used by many research institute who would like to have a generated report from the Survey they conducted. In order to get a result you must gather the data from the survey and encode the data manually into the software then a Report would make a Report. 2. 3 User Characteristics Admin- The person who conducts the survey.

Able to operate computer system. Client-computer literate, able to answer survey questions without assistance. 2. 4Problem Statement Based on the interview conducted researchers incur.

The High cost of time generating a report large amount of data. The need of encoding amount of data into the software. The researcher has to review manually the set of questionnaires. The researcher must produce numerous amounts of questionnaires in order to meet the amount of sample in conducting a survey.

2. 5Objectives The main objective of the document is to design a working online Computer Aided Survey System. Specifically, the system can. 1. ) Facilitate online Questionnaires 2.

) Generate a tabulated report 3. ) Generate raw data from the respondents. . 6Constraints The major constraints in the development of the Study is online connection of the Research Center in order to collect data from the respondents the research center has only Local Area Network(LAN) connection within the campus. 3. Functional Requirements.

1. ) Log-In Name of Requirements| Code| Measure of Performance| Justification| Verification Criteria| Priority| Remarks| UsernamePassword| 001002| All charactersAlphanumeric| 8 characters8 digits| Correct UsernameThree Attempts only| 21| Required to access the systemRequired|Table 1. 1 The Log-In form is the user interface where the Verification is processed. The Administrator can add, edit, view the survey questions, the Respondents can only view and answer the questions. 2. ) Survey Form Name of Requirements| Code| Measure of Performance| Justification| Verification Criteria| Priority| Remarks| Survey_IDRespondent_ID| 001002| NumericNumeric| 6 digits6 digits| Unique keyUnique key| 34| Unique key RequiredUnique keyRequired| Table 1.

2 The Survey form is where the Respondents will answer the questionnaire.The Researcher can only view and edit the Survey questionnaire. 3. ) Respondents Registration Form Name of Requirements| Code| Measure of Performance| Justification| Verification Criteria| Priority| Remarks| Respondent_IDAgeSex| 001002003| NumericNumericcharacter| 6 digits2digits1 character| Unique keyValid AgeValid Sex| 34| Unique key RequiredRequired data| 8.

1 Product Development Description 8. 1. 1 Context Diagram -> In this context diagram shows the three entities which are the following.The persons concerned in the system are the following. The researcher is the one who submits the questions for the survey, the researcher receive the Tabulated report.

The Respondents are the persons who take part in the survey, source of raw data. 8. 1. 2 Data Flow Diagram 0 8. 1. 3 Relational Database Diagram 8.

1. 4 ER Model Shown in the table is the Relationship between the Tables. * A researcher conducts one or more Survey. * a Survey can have multiple Respondent