Home

Futsal Field Management System - Attawit Commercial Technology

image

Contents

1. Status admin Access time Fig 4 11 The Page save Information Payment J g Ta aay BOOKING Sole CUSTOMER REPORT gt jsl Information Ground Options Button Ground ID GO Price 50 Ground Name Ground sid aonb GSAT Show Information Ground Ground_ID Ground_Name Ground_Description Ground Price C 1 Ground 1 Futsal Ground Futsal Ground Futsal Ground Ground 4 Futsal Ground Status admin Access time 20 Fig 4 12 The Page save add Information Ground 53 BOOKING PAYMENT CUSTOMER GROUND REPORT EXIT ID Address 2291 885 Username Password Tel 0878269878 Full Name MrGridsadaPrasan Emal Tam sport outlook Show Information Staff al M Username Password Member Name Member_Ai Mem Tel Mem _Emai 1 admin 123456 Mr Gridsada Pra 2291 385 08782698 Tam_spo Status admin Access time 2 Current time Fig 4 13 The Page save add Information Staff BOOKING PAYMENT CUSTOMER GROUND STAFF oR Gonna Customer Siaf_ Booking Booking_ID Booking_Date Member_ID Ground_ID Time_Rent Discount total Booking_status 1900 Booking 44 8 12 2014 66 750 11960 500 Fig 4 14 Print out report proposed Manager 54 Chapter 5 The Summary of the Project 5 1 The Summary of the Project 1 This system has been developed by Visual Studio together with the
2. Not found Data Yes Save the data access services Fill in the payment information Save the receipt of payment Displays the report STOP Fig 2 4 Flowchiyrt the curreny System 2 3 Related Theory 10 2 3 1 Basic Knowledge about Database Database as a data storage enables users to share information related to the work sharing system that will not result in duplication of data and also be able to avoid a conflict of information all data in the system it will be reliable and must be the same as a standard set of information security systems the current era of information technology is that it is information that is passed to the appropriate committees can be used in business administration and other affairs an organization for fee information very difficult to find the devil as well as bring out the information you want to keep up an event Therefore the computer is used as a tool to assist in the processing of information which makes data storage systems is going to be a great this is an individual program to create control and manage the database it has a very important role specifically the computer based system design and development of database system for controlling and managing the accuracy and efficiency in retrieving 2 3 2 Database Theory Information is collected about the facts of what we are interested in a Particular subject that is in the form of numbers or symbols who has not passed the data processing is
3. FUUMITIAMIAWINHN AYO Futsal Field Management System Submitted by Mr Gridsada_ Prasan Mr Worathon Picheansoonthon This project is Partial Fulfillment of the Requirements for Graduate Diploma in Higher Vocational Education Business Computing Major Attawit Commercial Technology College Academic Year 2014 Name of Project in Thai suUMIIAMIAIUUAKAA Name of Project in English Futsal Field Management System Group Members 1 Mr Gridsada Prasan 2 Mr Worathon Picheansoonthon This project is accepted by the Business Computer Department Attawit Commercial Technology College in partial fulfillment of the requirement for the Higher Vocational school Major in Business Computing Mrs Ohmar Thwin Advisor Mr Ditprapot Suwanasart Co Advisor Mr Ditprapot Suwanasart Head of Business Computer Department Name of Project in Thai Name of Project in English Group Members Communitee Member Advisors Co Advisor Department Institution Abstract jZUUMIIAMIA WINN AKA Futsal Field Management System 1 Mr Gridsada Prasan 2 Mr Worathon Picheansoonthon Mrs Obhmar Thwin Mr Thanawut Wichai Mr Ditprapod Suwannasart Business Computer Major Attawit Commercial Technology College Abstract The purpose of the Futsal court management system to facilitate the customers to book Futsal field and to search the data of the football fields information and administrat
4. what it do system development flow with together 7 steps 1 Understand the problem Problem Recognition 2 Feasibility study 3 Analyses 4 Design 5 To create or develop a system Construction 19 6 Modify Conversion 7 Maintenance 2 4 4 Systems Analysis for the System Development Cycle Starting from the Original System study and information from the study Requirements or anything that needs to be updated in another system or is a solution of the system the analysis will be started after the known problems and through the process of feasibility studies and collect data study on the original system analysts starts from the study of documents such as manuals after it is collected such as forms and reports in the accounts payable system will form a package product the claim report to prepares silver pine etc In addition it is essential to observe the work of those involved in the educational system finally there may be required to interview people who are responsible for the tasks that are involved in the system or in some cases may need to use a query to help collect the data with it All methods are called data collection techniques In Fact Gathering Techniques Description of the data Data Description when many systems into educational system analysts will find that there is plenty of information that must be classified as a category such as a customer s information will include other information such as the customer s name ad
5. Visual Basic 2 This program allows customers to play futsal can book the futsal flied 3 This program can check the history of booking field 5 2 The Problems and Difficulties during Making the Projects 1 Members of the group did not match the free time to work together 2 Computer crashed often and the works were delayed 3 There are difficulties in writing project in English and needed to edit several time 4 The system is not completely smooth yet sometimes errors come out when we run the program 5 3 Actual Time Schedule June 57 July 57 August 57 September 57 List Note 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Proposed project i gt 18 20 June 2014 topic Chapter 1 lt gt Edit the project gt 24 June 2014 topic and chapter 1 lt gt Finalized the project gt 28 June 2014 topic and Chapter 1 Declared the project p __ 1 15 July 2014 topic Di gt lt gt 15 July 15 Submit Chapter 2 Sed a a gt August 2014 Submit Chapter 3 4 gt 20 August 2014 Progress lt gt 1 September 2014 Presentation 4 November 57 December 57 January 58 February 58 List I 1 Note 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Send H 8 November 2014 70 progress t gt Send e 12 November 80 progress gt 2014 Send gt 19 November 100 progress gt 2014 Present the lq lt gt 8 De
6. a single process Process 1 Process 2 Fig 2 2 Flowchart for selecting Conditional Action 2 3 Repeat or reparation Loop To make a process several times with the terms to govern means to repeat the principle that understanding is more difficult 2 models because each programming language is not explicitly shown like writing flowchart the author of the program needs to imagine them Process 2 Fig 2 3 Flowchart for Attraction 3 1 2 Benefits of work flows 1 Make it easy to understand and identify the Define Problem 2 Display sequence Step Flowing 3 Simple errors Easy to Debug 4 Understand simple programs Easy to Read 5 Do not depend on the particular language Flexible Language Or map a particular language to describe the image making it easy and convenient to consider a procedural order to work narrate rather than a letter 3 1 3 The constraints of writing flowchart Flowchart programming is not suitable for working with complex methods such as weaving conditions that many exams often use a decision DECISION TABLE to help more than 3 1 4 How to write a great work flows 1 Use the symbols as defined 2 Use the arrow shows the direction of the information flow from top to bottom or from left to right 3 The description should be short compact and easy to understand 4 All the diagram must have an arrow showing direction away 5 Do not weld line link task map very far should use the symbol inste
7. applications more easily with Unit Testing the Microsoft Visual Studio 2013 Professional Edition wizard automatically 1 5 Using the potential of the NET Framework 3 5 available by using An Integrated tool that helps creates a great work environment and are connected to them 1 6 Create a great experience for end users by using the integrated Design tools The circuit for the Windows Presentation Foundation WPF that can be merged into anything with Windows Forms is harmoniously 1 7 Build applications for a connection by using the design tools a new type of Visual for Windows Communication Foundation and Windows workflow foundation 1 8 Using the development environment of professional Microsoft Visual Studio 2012 Professional Edition to create solutions for Microsoft Visual Studio 2013 Professional Edition as well as applications that extend the system stable and easy care 1 9 Allows designers and developers to work together better to create Applications that provide great experiences to users 2 Features of Microsoft Visual Studio 2013 Professional Edition 2 1 Creating applications for the Windows web Microsoft Office System NET Framework SQL Server and Windows Mobile devices using integrated design tools drag and drop features 2 2 Microsoft Visual Studio 2013 Professional Edition with English Visual Basic Visual C and Visual C which supports the development of a variety of styles 2 3 features such as Edit and Continue and in th
8. bit This article describes the Setup preview Windows XP 32 bit 4 3 Order of installation Installation tools for the study of work and the establishment of a service provider sales template to the test needs to be performed in the correct order because if you make a mistake the Setup process may fail from the experiment several times in different ways the author finds that it should perform the following steps 4 3 1 Preparation before installation 4 3 2 Installing the program Microsoft Visual Studio 2013 4 3 3 Installing Microsoft SQL Server 2014 4 3 4 Set up Reporting Services preparation before installation Is necessary to prepare preliminary before installing any tools to the study of work and the establishment of a service provider sales template to test the following 4 3 5 Format the hard disk and then install the operating System Windows XP if installed on Windows XP is used for a long time and have the programs installed are working There is a high possibility that the installation will fail 4 3 6 Download and Setup service pack for your operating System to Windows XP the latest Update from Microsoft Corporation s Web site service pack that the author uses this test updated SP3 WindowsXP K B936929 SP3 x86 ENU exe 27 4 3 7 Downloads and installs new versions of the NET frame Work from the website of Microsoft company the version used in the test while a NET Framework 4 5 4 3 8 Make sure do not install Internet Info
9. in order to reduce duplication why the need to reduce the redundancy due to the difficulty in updating data that is if multiple redundant data storage when you update the data and then update the data incomplete data conflicts data followed and also waste storage space because the same set of data stores many duplicate themselves 2 Maintain the Accuracy of the Data Because the database management system can check rule enforced the accuracy of the information provided by bringing them into the database which is a function of the database management system that handles the accuracy of the information instead but if it s a file system developers must write programs to control regulations Data integrity for all if programming rules and regulations covering any incomplete or missing some of the rules may cause data errors and also reduce maintenance expenses and program development with database management systems because of the deal because database management system can support the implementation of the nature several people at the same time therefore a static condition and accuracy of the information it is very important and must be controlled but because the user can change it this will cause the error affects data usage of all other users therefore the benefits of this system s database is very important 3 There is Freedom of Information Because it is a concept that do the program is independent from the changes in the data structure if it is not cu
10. process Process Description this description tells you exactly how to input serial output is changed to grill To create a database Data Modeling is the design of the database themselves analysts have said the system is designed to store data and retrieved using what methods will be used to the database system analyst need to know the exact saying all data that uses a version of the software from publishers you trust sample database may be a plain table Relational Database and retrieved by a search using the key as the index file so that the majority of the current database is used the table is easy to understand Modelling systems is to bring everything from data dictionary information to render the database diagram is a new system and it is important that the new system needs to be more to come in this new system this new system is the system that we want to in addition it must be about whether to use the personnel equipment and what you d like and use it as much Management due to act as system analysts to see whether there is a job that must be done fairly therefore controlling behavior so that they do not exceed the planning time during the project is very necessary because if you take a lot more than planned It means that the expenses would certainly escalate planning amp control good project by the planning schedule for smaller tasks which we know already exists what is tools to help you plan and track project performance control Char
11. that shows step by step how to do the job of one system which in the chart the System will demonstrate the information media save data processing methods procedure and relations of the parts in the system to provide an overview of the system one system 2 Program flowchart or short call that flowchart This type of flowchart represents a step of the commands used in this map the program may create from the author of system flowchart retrieves the relevant points of a computer that appears in the chart of the system burning so they know if they use a computer to work on it to get the desired results it should be a step by step instruction how to bring computer programming work 2 1 The works respectively Sequence The programming model is simple to write working from top to bottom write a command line and line by line from the top line down to the bottom line supposed to be 3 working process is reading Process 1 Process 2 the data calculate and print Process 3 Fig 2 1 Flowchart sequential Works 2 2 To select a conditional action Decision or Selection The decision was a condition or selects a program to bring up to select the action the event usually has 2 process is the actual condition is one of the processes will be completed and false to perform another process but if it is more complicated to use terms such as multi layer cutting student grades etc an example of this task will display a simple option to make the process just
12. to create a complex Query to transform data into meaningful information for operations on language must be one of the two nacho of a system that can be performed by simple and the structure of the language seems to be easier to learn as well SQL Server it is a language that can meet these requirements and also have commands that are used for database management principles of database systems analysis and design Asst Prof Dr may reflect the beauty with a great deal of somite 2006 28 Chapter 3 Computer System Design 3 1 The User Interface Design 1 Context Diagram Ticket 1 Infi ti 3 R MASUR nee aero Futsal Stadium Information Futsal Field booking Information Subscription Fee The subscription Information The code booking Member Members Administrator Futsal Field Management System The code booking Member Member Information Membership card Futsal Field course Information Cash receipts Futsal Field booking Information Fig 3 1 Design Context Diagram 2 Data Flow Diagram Level 1 Member information Information on subscription Members Ticket renewal information Member information Member information Register 3 Detailed member information Membership card Futsal Field information D2 Futsal Field information Reservation Information Futsal Field Booking Members Information The code Reservation Futsal Field booking Information Member in
13. 1 42 42 42 56 57 Chapter 1 Introduction 1 1 Background Information In this current global society is a society of information technology IT The evolution of information technology has been changed so quickly and has become extremely complex to develop countries consistently with the era and adapt to the ASEAN Economic Community so that information technology has come to play an important role on people s life which have applied technologies in areas such as industry finance business education communication and creating a competitive advantages through trading with other countries In Thailand it is steaming in the countries that give priority to information technology which is founding countries to national economic social wisdom and learning Knowledge based Economy by encouraging technology which has been used in various activities both in the public and private sectors The database has a role in the various aspects taking technology to help in business It can also build the business that can be externally recognized easily to another current international business which is very high competition at the present International business has a lot happening and it must have the facility to get more customers whether it s booking system that provides the information to customers and get attraction from them So the group has recognized the importance in making a booking system of futsal stadium and improves the system performance to ge
14. 2 The Programs used in the Development 47 4 3 Installation of the program System 48 4 4 The Steps to use the System 50 Chapter 5 The Summary of the Project 5 1 The Summary of the Project 55 5 2 The Problems and Difficulties during Making the Projects 55 5 3 Actual Time Schedule 56 5 4 Actual Budgets 57 Appendix ATC 01 58 ATC 02 59 ATC 03 60 ATC 04 61 ATC 05 62 Reference 64 Biography 65 List of Pictures Fi g 2 1 Flowchart sequential Works Fi g 2 2 Flowchart for selecting Conditional Action Fi g 2 3 Flowchart for Attraction Fig 2 4 Flowchart the current System Fi pi g 2 5 Displays Symbols in the Written Program Flowchart Fig 2 6 Shows the symbols used in the Data Stream Fi pi g 2 7 Example Diagrams logical and physical printable Reports Fi En g 3 1 Design Context Diagram Fi pi g 3 2 Data Flow Diagram Level 1 Fi g 3 3 The Shows Subscribe DFD Level 1 of Process 1 Fi g 3 4 The Shows Booking Information DFD Level 1 of Process 2 Fi g 3 5 The Shows Receiving Payments DFD Level 1 of Process 3 Fi g 3 6 The Shows Report DFD Level 1 of Process 4 Fi g 3 7 The Shows Subscription Flowchart Fi g 3 8 The Shows Login Flowchart Fi g 3 9 Flowchart futsal field Booking Fi pi g 3 10 Flowchart receipt of Payment Fi g 3 11 Flowchart to Report Fi m g 3 12 The Entity Relationship Diagram Fig 3 1
15. 3 The screen picture to Register Fig 3 14 The screen picture to Login From Fig 3 15 The screen picture to Order Booking Fig 3 16 The screen picture to Receive Payment Fig 3 17 The screen picture to Cash Receipts Fig 3 18 The screen picture to Report Fig 4 1 How to install Step 1 Fig 4 2 How to install Step 2 Fig 4 3 How to install Step 3 Page 10 15 16 22 29 30 31 32 33 34 35 36 37 38 39 40 43 43 44 44 45 45 48 48 49 Fig Fig Fig Fj pi 8 Fi 8 Fi 8 Fi pmi 8 Fi m 8 Fi pi 8 Fi 8 Fi 8 List of Pictures cout 4 4 How to install Step 4 4 5 How to install Step 5 4 6 The Page Download Program 4 7 Login Page 4 8 Home Page 4 9 The Page save Information Customer 4 1 The Page save Information Booking 4 11 The Page save Information Payment 4 12 The Page save add Information Ground 4 13 The Page save add Information Staff 4 14 Print out report proposed Manager Page 49 50 50 51 51 52 52 53 53 54 54 Table Table Table Table Table Table Table Table Table List of Table 1 1 Time schedule for developing project 1 2 Operational budgets 3 1 Shows the Storage Member 3 2 Displays the Storage Ground 3 4 Shows the subscription Information 3 5 Show payment Information 3 6 Displays the Storage Report 5 1 Actual Time Schedule 5 2 Actual budget to complete the project Page 41 4
16. 8 June 2014 topic and Chapter 1 Declared the project e gt 1 15 July 2014 topic 15 July 15 Submit Chapter 2 e August 2014 Submit Chapter 3 gt 20 August 2014 Progress lt gt 1 September 2014 Presentation November 57 December 57 January 58 February 58 List Note 2 3 4 1 2 3 2 3 1 2 3 4 Send gt 8 November 2014 70 progress Send 12 November gt 80 progress 2014 Send 19 November 100 progress 2014 Present the 8 December 2014 completed program Submit Chapter 4 gt 18 January 2015 Submit Chapter 5 lt gt 31 January 2015 Submit Report lt gt 3 February 2015 and CD Table 1 1 Time schedule for developing project 1 6 Tools 1 The program Microsoft Visual Studio 2013 is used for programming 2 The language Microsoft SQL Server 2014 is used for writing programs to handle Database 3 The program Adobe Photoshop CS6 is used for managing to edit and decorate pictures 1 7 Operational Budgets No List Quantity Price l Paper A4 3 Steam 380 2 The staple 1 Book 150 3 The teaching guide book Visual Basic 1 Book 300 4 The teaching guide book SQL Server 1 Book 270 5 Other expenses 1 000 Total Amount 2 100 Table 1 2 Operational budgets Chapter 2 The System and Related theory 2 1 The Theory about the Flowchart In a computer program the program is a sequence of commands written in a computer langua
17. CHAR 30 Name of Member Gro Desc VARCHAR 30 Description Ground Gro_Price CHAR 10 Price Member ID CHAR 10 FK Member Member ID 41 Order Booking Table Attribute Data Type Size Key Constraints Description Reference Booking ID CHAR 10 PK NOT NULL Code Booking Boo_ Date DATE Date Booking Member ID CHAR 10 FK Member ID Member Ground_ID CHAR 10 FK Code Ground Ground Table 3 4 Shows the subscription Information Payment Table Attribute Data Type Size Key Constraints Description Reference Payment ID CHAR 10 PK NOT NULL Payment ID Pay_Date DATE Date receipt of Payment Pay Money INTEGER Paid amount Booking ID CHAR 10 FK Service code Booking Table 3 5 Show payment Information Report Table Attribute Data Type Size Key Constraints Description Reference Report ID CHAR 10 PK NOT NULL Report ID Rep_Date DATE Date of Report Member ID CHAR 10 FK Member ID Member Ground_ID CHAR 10 FK Ground ID Ground Payment_ID CHAR 10 FK Payment ID Payment Table 3 6 Displays the Storage Report 42 3 4 Design Implementation Story Board 1 Register Form Register Username Password Confirm Profile Name Ld Futsal Field Management System L l oaf a Identification Number Sooo E Birthday C v Mouth Year C v alas O O Confirm
18. Cancel Fig 3 13 The screen picture to Register 2 Login From Futsal Field Management System Login USERNAME PASSWORD Login Fig 3 14 The screen picture to Login From 43 3 Order Booking Futsal Field Management System Futsal field booking information Futsal field booking details Number Booking Number field Booking of Hours Service charge id pt fee e Save Fig 3 15 The screen picture to Order Booking 4 Booking Details Futsal Field Management System Booking Details Details of payment Number Booking Number field Booking of Hours Service charge Fix List Delete Fig 3 16 The screen picture to Receive Payment 44 5 The Print of Cash Receipts Cash Receipts Charges Employees Futsal Field Management System Futsal Management Thank you he 2 2c 2 2g E k k K k k k k k k k k k k k k k k k kk k Printer Cancel Fig 3 17 The screen picture to Cash Receipts 6 How to Print to Report Issue reports Futsal Field Management System Select an item to View L Field report O Report Bookings L Report Information O The payment O Staff report Print Report Fig 3 18 The screen picture to Report 45 3 5 The Design Input Data 1 User Password 2 Member Information 3 Ground Information 4 Booking Information 5 Renewal Information 6 Payment In
19. Customer 66 Full name 1565544589654 Address 55 88 M 2 Bangna Tel 668545556 Code ID MrATC Name E Mail ATCO1 gmailcom _ OX Search Show Information Customer custc customer_numci customer_name custom custome customer_email 1455566957852 Mr Gridsada Prasan 5578 08455 Tum amail com 155445568789 Mr Wannachai 103654 Bank El hotmail 2556655444444 Ms Pannaporn 6684 Pannaporn 1150 1255545669975 Mr Akemonakon 1234567894561 um 1565544589654 Mr ATC Name 6632 Ake 191 Hotma 08785 tUM ATCO1 amail com Status admin Access time 19 59 14 Currenttime 20 01 33 Fig 4 9 The Page save Information Customer 7 d EE Tal E Bay PAYMENT CUSTOMER GROUND STAFF REPORT EXIT Information Booking Booking ID a Customer 1 Cid Booking Date 28 11 2557 Start Time 7 00 O gt End Time 8 00 Ground ID 1 Price Hour Hour tq Discount oF Price Total 500 Baht Show Information Booking All item Booking ID Booking_ID Booking_Di Member_IL Ground_ID Time_Rent J 28 11 2557 1 Status admin Access time 19 59 14 Current time 20 03 16 Fig 4 1 The Page save Information Booking Options Button Booking TA Payment x Cancel 52 f F E ws Information Payment Booking ID Payment Details
20. Information Calculate expenses Want to edit information for payments or not No Save payment information Cash Receipt Fig 3 10 Flowchart receipt of Payment 38 5 Flowchart to Report START Fill out the information to log on There are no Not permission Has the right to permissions to have or not view Reports With permission Displays the Report screen Fill out the information To view the report Check whether Not permission Data could not there are or not be found With permission Display Report Print the Documents Report STOP Fig 3 11 Flowchart to Report 39 3 3 Design Entity Relationship Diagram 1 The Entity Relationship Diagram Report ID Fig 3 12 The Entity Relationship Diagram 40 2 Data Dictionary The Member Table Table 3 2 Displays the Storage Ground Attribute Data Type Size Key Constraints Description Reference Member ID CHAR 10 PK NOT NULL Member ID Username VARCHAR 20 Username Password VARCHAR 20 Password Mem Name VARCHAR 30 Name of Member Mem Add VARCHAR 150 Address Mem Tel VARCHAR 10 Telephone Men E Mail VARCHAR 30 E mail Table 3 1 Shows the Storage Member Ground Table Attribute Data Type Size Key Constraints Description Reference Ground_ID CHAR 10 PK NOT NULL Ground ID Gro Name VAR
21. Project Committee Member ATC 03 Progress Project Presentation ATC 04 Progressive Report of Project ATC 05 Record of Submitting Document and program ATC 02 Request Permission to be a Project Committee Member Major in Business Computing Attawit Commercial Technology College July 7 2014 Subject Request Permission to be a Project Committee Member To Mr Ditprapot Suwanasart Group Members 1 Mr Gridsada Prasan Student Code 33827 Level 2 EP 2 Mr Worathon Picheansoonthon Student Code 33904 Level 2 EP We would like to invite Mr Ditprapot Suwanasart to be a project committee member of our group We will develop the system with Database named as Futsal Field Management System We have also attached of the documents regarding the project s topic Please kindly determine and allow SIQMACUIC eee eeeeeeeeeeeeseeeseeeeeeeeees Student STi E a E T Student Mr Gridsada Prasan Mr Worathon Picheansoonthon ETAn E a N A A N Committee Member Mr Ditprapot Suwanasart ATC 01 Project Title Approval Major in Business Computing Attawit Commercial Technology College June 18 2014 Subject Project Title Approval To The committee members Group Members 1 Mr Gridsada Prasan Student Code 33827 Level 2 EP 2 Mr Worathon Picheansoonthon Student Code 33904 Level 2 EP We would like to make the project of Database System Thai Name ssuuMsdAMIAaWINNAKOA English Name Futsal Field Management Syste
22. a database system database system development and implementation and benefits from the knowledge of computer Database systems provide the users can be able to subscribe be able to delete add and edit information And also it can save the report and print the payments etc The developers hope that this system will be very useful for the users who are interested in the booking the Futsal Fields and who wants to search for the fields information Team prepared February 10 2014 Contents Approved Abstract Acknowledgement Introduction Contents List of pictures List of table Chapter 1 Introduction 1 1 Background Information 1 2 The project s objectives 1 3 Scope of the study 1 4 The benefits expected to be received 1 5 Time schedule for developing project Gantt chart 1 6 Tools 1 7 Operational Budgets Chapter 2 The System and Related theory 2 1 The Theory about the Flowchart 2 2 The Current System 2 3 Related Theory 2 4 Analysis and System Requirements 2 5 Tools used in the development of a new System Chapter 3 Computer System Design 3 1 The User Interface Design 3 2 The Current System Design Flowchart 3 3 Design Entity Relationship Diagram 3 4 Design Implementation Story Board 3 5 The Design Input Data 3 6 The Design Output Data Page Qu o a w o 19 24 29 35 40 43 46 46 Contents cout Page Chapter 4 Database System of Futsal Field Management System 4 1 Tools and Equipment used 47 4
23. about events that occur continuously and accurately complete applies only when distributed processing Database is a group of related data is collected together with data and systems that make up the database to meet the objectives of the organization as well as in office collects data from the phone number of a contact to store office documents this section contains information that is related to release later benefits it might be about people all of the places or any event that we are interested in education or may have come from observing to count or measure it is including numbers text and pictures can be stored in the database and all data and must have the same relationship because we want to continue to utilize in the future Database Management System is a program that acts as an intermediary in the contacts between the users of a database to manage and control accuracy redundancy and relationships between various data within the database which is different from the file system data that these duties are the duties of a programmer in contact with the data in the database either by using the commands in the Group DML or DDL or with programs all commands that use the data 11 is done with the best BMW s be translated compiled into operation under the command to be performed on the data within the database for the neighborhood countries within acting translation commands to be executed on the data 2 3 3 The need that caused a database 1 Sys
24. ad of the connection point 6 Flowchart should have tested the accuracy of the work prior to programming 2 2 The Current System In the operation of the futsal field there are times that customers who want to rent the field live in customers need to have incoming calls to query various information about futsal stadium in an empty stadium at intervals if the customer does not have to call to inquire about the information available moments before the waste of time Since that time futsal may be busy at this point is that the problem of waste of time in the section of the booking administrator the current will be used only to provide incoming phone book in both parts of the pitch and duration sometimes a book in this manner may cause haziness that those who came calling to book reservations and how much is the airport what time sometimes results in duplicate bookings and leads to the waste of time on both sides from the study and analysis of the current operation in the route in found that there are quite lot problems particularly booking information management efficient Therefore remove the system technology to improve and enhance the reserve Futsal by storing information on your computer instead of having to remember and write down START Save customer information Booking Fill Check the full booking information or not Incomplet Yes Save the customer s booking Information Check you have access service or not
25. an application that focuses on using data using a new program called Language Integrated Query LINQ to create client applications with elite that allows a user to work better they also take advantage of the various features available in the Microsoft Office System 2010 and Windows Vista Windows 7 as well Create web applications with high performance which focuses on the use of various media using Interactive Web interface name ASP NET AJAX 1 New features that are available in Microsoft Visual Studio 2013 Professional Edition 1 1 creating applications that take advantage of the latest Web Technologies Privacy updated to work with AJAX the Web Controls and the Microsoft AJAX Library better 1 2 build Web applications more easily by using the screen design and ta in conjunction with the various standards have been updated to better utilize data from any data source can be more fluid by using LINQ which is a new language for structure language Visual Basic and Visual C In conjunction with the various standards have been updated to better utilize 24 data from any data source can be more fluid by using LINQ which is a new language for structure language Visual Basic and Visual C 1 3 Manage and create specific applications for NET Framework each the Version by this time considered to be the first time that you can use only one type of tool to work with applications that use with NET Framework version 2 0 3 0 3 5 and 4 5 1 4 Validation of
26. be discussed here just some of the ways only in addition there will be examples collecting information by means of questionnaires interviews and accounts payable systems which is an example of a system that will be used in the next study The start of data collection is to collect data is collected on all input forms that have been filled and that have not yet been completed in addition to collecting all reports Reports Output as well as saying that the reports and forms each input is created in which sections of the system often a lot fewer and who use those forms and reports when the forms and reports in the hands and then began to study the documents of the system as well as how the system works the existing program data files and links of the files document the issue is how the system works how much state of the art or to keep them or not etc So what system analysts will have to do next is to observe actual work manually we know how the system really works how it is Before you begin to observe the system analyst must obtain permission from those who wish to observe their work including bosses during observations we must live far apart from work and will be not interfering with his work but one thing we must remember is that under our 22 observations will not work normally like the time he normally would do too working with negligence or caution than normal the best way is to make your own cause understanding working better observations on
27. cember 2014 completed program Submit Chapter 4 e gt 4 gt 18 January 2015 Submit Chapter 5 4 gt 31 January 2015 Submit Report Bele 3 February 2015 and CD i j Table 5 1 Actual Time Schedule lt lt Planning operation Actual working time 56 5 4 Actual Budgets No List Quantity Price 1 Paper A4 4 Steam 500 2 Ink 4 Cartridge 500 3 The teaching guide book Visual Basic 1 Book 300 4 The teaching guide book SQL Server 1 Book 270 5 Project day 1 500 6 Project book 200 7 Miscellaneous 1 000 Total amount 4 270 Table 5 2 Actual budget to complete the project 57 Reference Benjamin Nevarez 2014 Microsoft SQL Server 2014 Query Tuning amp Optimization UK amp EUROPE McGraw Hill Education Europe Boonserb PooSre 2013 The program is successful in the profession Bangkok Vocation Education Bruce Johnson 2014 Professional Visual Studio 2013 United States John Wiley amp Sons Inc EPC Group net 2014 Microsoft SQL Server 2014 Future and Features United States Search 11 November 2014 https www youtube com watch v YF9Kidp7qml Esneyder Alvarez 2014 Conexion SQI server 2014 Visual Studio 2013 Asp United States Search 11 November 2014 https Avww youtube com watch v s9vfSFTINxQ Siwat Kanjanchu 2010 Database System Bangkok Academic Development 64 Appendix ATC 01 Project Title Approval ATC 02 Request Permission to be a
28. dress telephone number cash purchases etc are all just a single file only in many cases the file will need to have a way to store tracking uncluttered definition of information tools to help keep it descriptions data dictionary Description methods Procedure Description processes that track changes to the data will need to know how to process information over what is known as doing nothing he said in the system and how to do such as paying creditors we are going to do or how to rule on a decision whether to pay anyone before after that certain methods are only a few details such as if the customer orders we only check whether there is a sufficient stock of the number of customer orders or not where CAU is remembered what to do immediately but if there are how to decide more details such as paying creditors there will be several steps as follows how much amount if too much to wait for approval from the executive if it does not exceed the set came checks that have discounted or not or the number of days payable is that how long the decision there are many steps and too many details to remember 20 A description of the process Process Description must have because even though the diagram renders data DFD is a tool that is used to analyze what to do or what processing is required but at each step even though it has come down to digests it also contains information that is deep Deep processing in the DFD description details by Description of the
29. e Editor Microsoft IntelliSense Will provide integrated design development and debugging applications with easy gliding 25 2 4 installed client applications simply by using the length property Name click Once that helps developers and IT professionals to install the application and required elements as well as to ensure that the application functions are always updated with the status 2 5 build applications that emphasize sharing anything NET Framework to Reduce the development time by reducing the systems of coding Java infrastructure and helps applications more secure 2 7 use ASP NET to speed up the creation of Web applications and web an interactive Internet services from which to choose the outstanding features of Master Pages site administration enables developers to lay out that invariably by storing the excite in one place 3 To know Microsoft NET 3 1 Microsoft NET or call briefly that NET is the company s technology Microsoft NET platform is used to develop software for the operating system Windows 3 2 Proposed principles that can develop software with language Anything We Prefer and can be used in conjunction with other language programs Seamlessly NET has a new language occurs under the same standard rules such as C VB NET C NET J NET or even COBAL NET 3 3 Any language that supports NET will fall under the same standards Called Common Language Specifications CLS and infrastructure ranging from a basic set
30. e Report Members Fig 3 4 The Shows Booking Information DFD Level 1 of Process 2 32 X 5 Data Flow Diagram Level Members Data access services The code Reservation Members Futsal Field access information Service charge Members Cash Receipts 1 of Process 3 3al Member Information Member Details Member information Membership 9sn IP JOMO Data access services Futsal Field booking Information The subscription information Check the use of the Futsal Field Futsal Field information D2 Futsal Field Information Payment slip Payment information EJ D4 Payment information Payment Slip 7 Issue receipts Issue Receipts Fig 3 5 The Shows Receiving Payments DFD Level 1 of Process 3 33 6 Data Flow Diagram Level of Process 4 Member Information D1 Member Information Report Membership Member Details Administrator Information Member Information Member Details Report Member Details Futsal Field Information Report Futsal Field D2 Futsal Field information Administrator Information Futsal Field Information Details Futsal Field yoday Futsal Field Information Booking details Futsal Field gt Futsal Field booking Information Report Reservation Futsal Field Administrator Booking details Futsal Field Booking details Futsal Field Report Employee Information eene Rep
31. formation 7 Access to Information Services 3 6 The Design Output Data U The Booking Code Membership Card Ground Information Booking Information Payment Information Access to Data Services Cash Receipts Report 46 Chapter 4 Database System of Futsal Field Management System 4 1 Tools and Equipment used 1 Notebook Asus K56C 2 Mouse 3 Keyboard 4 Printer 5 Computer PC 6 Monitor 4 2 The Programs used in the Development 1 Microsoft Visual Studio 2013 2 Microsoft SQL Server 2014 3 Microsoft Word 2010 4 Microsoft PowerPoint 2010 4 3 Installation of the program System 1 Click My Computer gt Drive CD ROM gt Project FFMS gt Folder FFMS gt SETUP sjo 9 gt Computer DVD RW Drive E project Organze Close session Eject MEZE E in E pase Ji l 1 og SETUP Date modified 8 12 2557 10 18 File folder Fig 4 1 How to install Step 1 2 Select gt Setup gt Computer DVD RW Drive E project SETUP Organize Closesession Eject boatiea s program 00409 FEMS co Drive G i Network W setup Date modified 8 12 2557 1013 Date created 8 12 2557 10 18 kd Application Sae 116 MB Fig 4 2 How to install Step 2 48 3 Select Install Button to setup the project Ready to Install the Program The wizard is ready to begin installation If you want to review or change any of your installation settin
32. formation D1 Member information Futsal Field reservation Information Member information The Receiving Members The code Members ne Receipts Payments Payment information N Member information a Administrator information ND Futsal Field information Administrator The Data Report Report Futsal Field information eld Futsal Field booking Information Details of the Work Futsal Field booking Information Fig 3 2 Data Flow Diagram Level 1 3 Data Flow Diagram Level 1 Process 1 The application Members Member information Member information The subscription information Membership The Subscription information Want to become a member UOTJEULIOFUT uondrosqns oy Member information Member infi ti f E ESTRES Ne Member information i gt 5 oO Eh n g 3 gt an 2o E g z i Members A Membership Card A Membership Card Fig 3 3 The Shows Subscribe DFD Level of Process 1 31 4 Data Flow Diagram Level of Process 2 2 1 Member information Member information Members Membership Member information uoneunozur qW uoneunozur BuUTOog Booking information Manage information access service Check the use of the Futsal Field Manage information access service yoog p1090y Futsal Field booking Information Record book D3 Futsal Field booking Information yodoy 9poD L The code Reservation The Cod
33. ge flowchart is a picture or symbol use writes instead of a text description of the procedure or the words used in the algorithm because the proposed stages of work understanding between people involved with speech or text making it more difficult To display the algorithm of solving the problem from the beginning till the end gives the sequence of activities is concrete it is easier to understand and can be brought back to view again later flowchart is a virtual navigation map to indicate the sequence of events and as a template that is guidance in writing the sentence commands with unlimited computer language that is the language in which the benefits from the flowchart summaries have 3 reasons 1 Use the idea seeing as the image helps understanding and relationship between the various operating procedures allows the programming of work 2 Used as a medium to communicate ideas related between for example between a system analyst with programming or programming between users that education programs based on the flowchart to understand easily faster than the education program to reduce the time it takes to learn fewer tasks 3 Assist in testing or review procedure for errors both at the stage of testing and maintenance programs which need to be revised the program later when applied to the task and then if necessary to meet the needs of users at all times 3 1 1 Flowchart organized into 2 categories 1 Chart of the system Flowchart Flowchart
34. gs dick Back Click Cancel to Destination Folder C Program Files x86 FFMS My Product Name User Information Name Admin Fig 4 3 How to install Step 3 4 Select Next Button to setup the project License Agreement Please read the following license agreement carefully To add your own license text to this dialog specify your license agreement file in the Dialog editor Once in the Dialog editor select the Memo ScrollableText control Set FileName to the name of your license agreement RTF file After you build your release your license text will be displayed in the License Agreement dialog I accept the terms in the license agreement I do not accept the terms in the license agreement Fig 4 4 How to install Step 4 L 2 3 Choose to edit the dialog layout 4 5 InstallShield 49 5 Select Finish Button to setup the project InstallShield Wizard Completed The InstallShield Wizard has successfully installed FFMS Click Finish to exit the wizard Fig 4 5 How to install Step 5 4 4 The Steps to use the System Fig 4 6 The Page Download Program 50 Username aS 4 Password FITENI PIIR TIME 19 47 25 Fig 4 7 Login Page 2 MENU oJ e a E E l PAYMENT a GROUND STAFF REPORT EXIT Status Admin Access time 19 48 09 Current time 19 51 40 Fig 4 8 Home Page 51 Information Customer ID
35. l that is used to show the direction to transmitting data within the system to describe how the system is composed of work processes Process what smaller Each process is to import information Input Data and information on export Output Data as well as how each process is associated with how to understand that match between the team of analysts to programmers and system analysts to use the system 2 2 1 Symbols used in a stream plan Standardized symbols used to represent various types of data stream plan but in this case i will show only 2 types a standard symbol set developed by Gane and Sarson 1979 and a set of standard symbols developed by and DeMarco Yourdon DeMarco 1979 and Constantine Yourdon 1979 with the following symbols DeMarco amp Constantine Gane amp Sarson What it means Process the process of working within the system 7 Data store data sources can be both a data file and the database Agent external factors or environmental conditions that affect the system Data Store data flow path shows the direction of the information procedure from one to another one step Fig 2 6 Shows the symbols used in the Data Stream 16 2 2 2 The Benefits of database management Systems 1 Minimize the Duplication of Data Because the system uses a database it must be the design of the database so there is minimal data duplication the main purpose of database design
36. ly 23 2 5 Tools used in the development of a new System 2 5 1 Microsoft Visual Studio 2013 Professional Edition Microsoft Visual Studio 2012 Professional Edition is a comprehensive set of tools circuit which led to accelerated conversion speed vision to become a reality developers of Visual Studio 2008 Professional Edition has been customized to support application development for web applications such as ASP NET AJAX Windows Vista Windows Server 2012 Microsoft Office System 2010 SQL Server 2012 and Windows Mobile with the number of platforms that developers could be the development of advanced applications to meet the business needs with the number increasing rapidly Microsoft Visual Studio 2013 Professional Edition is a set of integrated tool to meet the needs of all forms via the function class that does not exist in the Microsoft Visual Studio 2008 the current old developer is required to face the challenges of the platform and the variety the need to develop applications with up to create value to the business as quickly properties in terms of design and language as well as integrated in Microsoft Visual Studio 2012 Professional Edition enables developers to create applications Connect the company s current needs It also takes advantage of INET Framework 4 5 to reduce development time too Developing applications with high performance connect to the information you want whether that information where it is including the development of
37. m Committee Members Mr Thanawut Wichai Mrs Ohmar Thwin We would like to request your approval for our project s title Please kindly check and approve SiQMature eceecceececeeseeseeeeeeeeeeseeeeeeeeeees Student Mr Gridsada Prasan Group Leader J Approve J Not Approve The Board of ITS CLOTS E E E A AE A E A EE EE AE E A EE A T SUQMALUIC eee eeeeeteeteeeeeeeeeeeeeeaees SIQMACUTC 0 eee eeeeeseeeseeeneeeeeeeeteeeees Committee Member Committee Member ATC 03 Progress Project Presentation Major in Business Computing Attawit Commercial Technology College August 4 2014 Subject Progress Project Presentation to defend the project related to business computing system To Committee members of the Board Group Members 1 Mr Gridsada Prasan Student Code 33827 Level 2 EP 2 Mr Worathon Picheansoonthon Student Code 33904 Level 2 EP We are developing the computer system with Database System Thai Name 2ULINITAANITAWINWATAA English Name Futsal Field Management System Committee Members Advisor Mr Thanawut Wichai And Mrs Ohmar Thwin Committee Member Mr Ditprapot Suwanasart With attached materials to evaluate the project M Software 1 set M Documents Chapter1 3 1 set Please kindly check and approve Mr Gridsada Prasan Group Leader ATC 03 Progress Project Presentation Major in Business Computing Attawit Commercial Technology College November 26 2014 Subject Progress Pr
38. of commands data type such as I O Manager Database that is located under the CLS enables software development using programming language in several languages 3 4 The program that we have written When compiling compile and is located in the Intermediate language called MSIL Microsoft Intermediate Language 4 To install the tools that he needs to learn there are three computers set up to use as an template a database provider the program Microsoft Visual Studio 2012 Professional Edition to create a spook writing practice CLR and learn to write a static queue LINQ and Microsoft Visual Studio 2012 Professional Edition which is a pro GSM RDBMS in this article the author describes the details of how to install and how to configure the program s initial two 26 4 1 hardware that is required for the hardware to work education and the Establishment of a service provider sales template for testing Test server can use if you want but moderate establishment of a service provider sales template to actual usage Production server which has a dense traffic should use high performance computers and reliable hardware for educational work and the establishment of a service provider sales template for testing is as follows CPU Pentium 4 Up RAM 2 GB Up Hard Disk 150 GB Up 4 2 Operating System Should I use Windows XP Windows Vista Windows 7 and Windows Server 2008 up Other versions of Windows or later can be used in both 32 bit and 64
39. ograms will be written in the system then began to decide how they should be structured how the program the link between the program is supposed to do At this stage of analysis analysts say must find a system to do something What but in the process of design you need to know how to do How in designing the program regardless of the security Security system to prevent errors that may occur such as the code for those users who have permission to back up all data files etc Next the system must be designed in such a way to use that input to do the number of personnel in various roles but if the system analysts decide to buy better programming software the design process is not needed at all because the software can be started as soon as finished What system analysts design and all in all these steps will be taken to write one set of documents is referred to as the identity of the system design specification to successfully programmers can use the programming key immediately before it is sent to professional programmers we should be examining with users that are satisfied or not and check with everyone on the team whether valid or not and of course that must be submitted to the administration to decide whether to continue to continue or not if approved it passed into the process of creating or developing the system Construction 1 5 Build or develop a System Construction At this stage the programmer can write and test a program that is working p
40. oint presentation and make the final Desc sca presentation to defend the Project 10 Submit Revised Application if any ANE ats 11 Chapter 4 Documents juan LRE 12 Chapter 5 Documents ss an EE ates 13 Submit the completed Documents s EE sites 14 Submit CD aaa Jensia 15 Payment for Binding report T seal vedas ATC 05 Record of Submitting Documents and program Page Group Members 1 Mr Gridsada Prasan Student Code 33827 Level 2 EP 2 Mr Worathon Picheansoonthon Student Code 33904 Level 2 EP Project Category Database System Name of Project Futsal Field Management System Advisors Mr Thanawut Wichai And Mrs Ohmar Thwin Committee Member Mr Ditprapot Suwanasart No Date Topics Signature Remarks ATC 05 Record of Submitting Documents and program Page 2 Group Members 1 Mr Gridsada Prasan Student Code 33827 Level 2 EP 2 Mr Worathon Picheansoonthon Student Code 33904 Level 2 EP Project Category Database System Name of Project Futsal Field Management System Advisors Mr Thanawut Wichai And Mrs Ohmar Thwin Committee Member Mr Ditprapot Suwanasart No Date Topics Signature Remarks ATC 05 Record of Submitting Documents and program Page 3 Group Members 1 Mr Gridsada Prasan Student Code 33827 Level 2 EP 2 Mr W
41. oject Presentation to defend the project related to business computing system To Committee members of the Board Group Members 1 Mr Gridsada Prasan Student Code 33827 Level 2 EP 2 Mr Worathon Picheansoonthon Student Code 33904 Level 2 EP We are developing the computer system with Database System Thai Name 2ULINIFAANIZAWINWATAA English Name Futsal Field Management System Committee Members Advisor Mr Thanawut Wichai And Mrs Ohmar Thwin Committee Member Mr Ditprapot Suwanasart With attached materials to evaluate the project M Software 1 set M Documents Chapter1 3 1 set Please kindly check and approve Mr Gridsada Prasan Group Leader Advisor Advisor Co Advisor ATC 04 Project progress Report to Advisor and Co Advisor JZUUMIIAMIA WINN AKA Futsal Field Management System Mrs Ohmar Thwin Mr Thanawut Wichai Mr Ditprapot Suwanasart No Job Description DD MM YY Advisor Co Advisor Semester 1 2014 1 Proposed project topic and Chapter1 AEE 2 Chapter 1 Documents fa cesses 3 Chapter2Documents uae EE AE 4 Chapter 3 Documents J ETE T 5 Send documents and PowerPoint presentation and make the progress Is Saved A Presentation Semester 2 2014 6 70 Progress of the System ere ree 7 80 Progress of the System eee eee 8 100 Progress of the System AE 9 Send Documents and PowerP
42. orathon Picheansoonthon Student Code 33904 Level 2 EP Project Category Database System Name of Project Futsal Field Management System Advisors Mr Thanawut Wichai And Mrs Ohmar Thwin Committee Member Mr Ditprapot Suwanasart No Date Topics Signature Remarks
43. ors can have facilities to store and update the customers information Futsal Field Management System has been developed with Visual Studio 2014 together with SQL Server 2014 and designed the system by using the Abode CS5 5 Photoshop A database system with the format in English is the most useful which can be able to solve the errors in the work of Futsal Field Management System This database system can be used in the real work which can be convenient for customers and administrators Acknowledgement We thank to Board of committee members who introduced to do this project The project will not be completed if we did not receive any helps and supports from our teachers We would like to thank to our teachers and our advisors We would like to special thanks to our advisor Mrs Ohmar Thwin and Mr Thanawut Wichai who gave suggestions encouragement and assisting in solving errors helped and edited the program to complete successfully We would like to thank to all teachers from computer department who tough and gave the knowledge regarding computer subjects We would like to give great thanks to our friends who shared knowledge time and helps during our project Finally we would like to thank to our parent and family members who cared with true love and support to complete our project successfully Team prepared February 12 2015 Introduction This project provides guidelines to people who are interested in establishing
44. ort Employee Empl Infi ti i a RAO Employee information Administrator Information Employee Details Employee Information Fig 3 6 The Shows Report DFD Level 1 of Process 4 34 3 2 The Current System Design Flowchart START Fill Out the customer information 1 Flowchart to Subscribe Member Information Fill out the subscription member Incomplete I let pened re Fill in the missing Information End to End The calculation of membership fees Save the subscription Membership card Fig 3 7 The Shows Subscription Flowchart 35 2 Flowchart login User input Username and Password Check User input Username Display error And Password Yes User input Username and Password Fig 3 8 The Shows Login Flowchart 36 3 Flowchart futsal field Booking START Fill out the membership Information Fill in the Yes Verify that a member reservation No Fill out the information Fill in the book plenty of customers Of members Reservation Information of the full Information of the full To save the data To save the data Plenty of customers Plenty of members Incomplete information Fig 3 9 Flowchart futsal field Booking 37 4 Flowchart receipt of Payment START Fill in the reservation Have access to the Data could not be found Fill in the payment
45. rmation Service 2 5 2 thrift di Microsoft SQL Server programming SQL Server Microsoft 2014 Isa database management program is a Server that has the capacity to accommodate large amounts of data to help manage the database efficiently fast responsiveness to the needs of large enterprise Microsoft SQL Server Database system amp the analytics solutions which offer reliability and performance System expansion at the site and the business enterprise with support for XML and HTTP to access and exchange of information can make it easier while capable of powerful analytics also help increase the value of data and with the availability of better systems enables the ability to work the system s continued rise handle daily tasks automatically better as well as updated programming tools and developing the service speed has improved as well the principle of using the SQL Server language is a language that is not the route Nonprocedural Language users the program will automatically use the commands asking what to do and does not need to describe how the system users and programmers do not need to know the process of storage and format of the data stored and the query can be written as the language that is used to dealing with the database must have the ability to create and manipulate the structure of the table has the message Table and must have the ability to manage data such as add delete and modify the data Add Modify and Delete and must be in the ability
46. roperly or does not need to be tested against actual data that is selected If everything already we will have a program that is ready to be the next runtime after that prepare user manual and training users of 13 system programmers write programs based on information from a specific data sheet design Design Specification system analysts typically have no duties are involved in programming but if programmers think that writing something else better than a system analyst consultant is required first so that analysts can tell the program to edit it affects all systems or not programmers write the review needs to be done to the system analysts and users to search for errors This method is also known as a test Walkthrough Structure the program will be tested with a set of data which may be selected by the user the test is a function of system analyst s programmers but must make sure that all programs must be no errors 1 6 Modifications Conversion This step the company introduced the new instead of the old under the supervision of system analysts data entry must be complete and in the end the company started with this new system implementation to come should be done gradually in small increments the best is to use the new system alongside an older system to a tattoo using the same set of data and then compare the results that match if the old system were successfully removed and then the new system continues 1 7 Maintenance After the newl
47. rrently using the database to fix the data structure will affect program because the data that is stored in the file system need to use a program that is written to the data file to retrieve such as when a list of employees whose salaries are more than 100000 baht per month is required to write a program to read data from a data file and print a report that shows only the data that meets nausea nashi defined if there is a change in the structure of the data file information such as an index by employee name instead of employee ID As a result a report that shows a list of employees whose salaries are more than 100000 Thai baht per month which was originally given by the employee ID cannot be printed Make the program needs to be corrected 17 according to the index structure that changed this style is called a data and program are not independent 4 Have Maximum Data Security If anyone can browse and change the data in the database at all may Cause damage to the data and some data is information that does not disclose your identity or executives if you do not have to manage the security of information the database will not be able to use some information 5 Sharing Information with central Control Control to a database in Microsoft SQL Server from the center database systems can accommodate multiple users work that is the database system will need to control the order in which to work properly for example while a user is editing a part of the unfini
48. shed it will not allow other users to change the data because the data into the database will be imported by system operators as sub divisions of the organization each authority will have the right to manage is not equal the database will be made available to any agency that handles database management system on which level who is the leader in information access who has the right to edit the information and who has the rights to run the information in order to provide the correct permissions on the table should use Because the database management system can manage the users to work simultaneously with several people therefore a program developed under the supervision of the database management system will be able to share data in the same database as the database system to lighten the burden on the development of the system if the system is not used to develop a database system using the file system data Developers will have to manage all these things 18 2 4 Analysis and System Requirements 2 4 1 Knowledge of system analysis and design is important because it is a factor in Creation and development of information systems analysis is an interesting story because Analysts must keep in touch with many people learn to manage and work in our organization contain knowledge about many of the computer systems more who can analyze the system should as well experience in programming with business knowledge of network and database system which is used as
49. system An analysis of the system starts from the study of the business functioning system in case of system we study is the information system is Unilever and so learn how it works because it is difficult to design a new system based on the original system don t know how it works or how it conducted business then define the requirements of the new system which system analysts will need to use a technique to store information Study of existing documents check how to work in on the interview and managers who are involved with the system existing documents such as manuals of report organization chart that circulate in the 12 system to learn how to work in the current system will allow analysts to know WA system really work which are sometimes discovered errors for example when a company receives a bill there will be a step in the settlement The steps that the clerk enters the billing coverage groups Regroup form monitoring the work of those involved to understand and really see how the work flows however which would make the system analysts found that where the focus of those system 1 4 Design In the first phase of the design systems analyst will bring to management decisions that result from the analysis step buying a computer with hardware and software then the system analysts will present various diagram written in the analysis step is converted into a phaplamdap stage to see the exact image of the program that is associated with it and what pr
50. t better jobs There is also a reliable data and saves time in managing data which can be added to customer services in the future 1 2 The project s objectives 1 To add the channel to the original booking system 2 To consumers over time and space 3 To system to record the information about booking in advance 4 To provide the fast and convenient customer services 1 3 Scope of the study The scope of the study will be divided into 2 sections 1 Member s Section 1 1 Can subscribe and edit the personal information 1 2 Can booking football through the program 1 3 Can check the information of the booking itself 1 4 Can verify the information itself 2 Administrator Section 2 1 Can handle booking date and rates 2 2 Can manage rules and regulations 2 3 Can manage information about the courses 2 4 Can learn about management courses 2 5 Can manage booking information 1 4 The benefits expected to be received 1 Customers can book their reservations through the systems 2 Customers can get sufficient information during the short time 3 The data can be handled easily with the booking system 1 5 Time schedule for developing project Gantt Chart June 57 July 57 August 57 September 57 List Note 2 3 4 1 2 3 2 3 1 2 3 4 Proposed project lt gt 18 20 June 2014 topic Chapter 1 Edit the project gt 24 June 2014 topic and chapter 1 Finalized the project gt 2
51. t of the system System Flowchart is a diagram that is used to display input output and processing Process of the system in some cases we use the flowchart system instead of the diagram render the information in some cases they use the same physical and visual semantic model Logical and Physical Model when we talk about logical to refer to one of the actions that we are talking about without interest that will do as we say we say we are not interested in data sorting that sorts data make it we call this kind of action in other words it is logical doing nothing while the physical damage to the contrary must know what to do what it must do such 21 As sorting data must know how to use the utility helps to sort the summary it is not logical to do matter but physical regardless of whether to do Logical DFD Physical DFD Report Data Report Print out Format Format Printer Fig 2 7 Example Diagrams logical and physical printable Reports 2 4 5 Techniques to gather information to find out the truth of the system to the new system design will need to understand how the original system how does it work there are steps to work however the issue is how the information will be stored what we know now is that if you want to design a new system will need to understand that the old system is how it works how the issue is what information will be stored to make understand the original system there are different data collection methods that will
52. tem development lifecycle SDLC Life Cycle Development System Process thinking Logical Process to develop information systems to solve business problems and meet the needs of the user system development cycle with all 7 steps 1 1 Problem Recognition To modify existing systems and not just one at atime difficult or even create a new shield system that should be studied before we demand that enough is going to be or does not include a feasibility study Feasibility Study 1 2 Feasibility Study The purpose of the feasibility study is to determine what is the problem and decided that the development of new information systems or to edit existing information systems is possible without the expense and waste little time and results are satisfactory the problem here is that the analysts botched must be given such problems feasibility and technical personnel technical problems would involve computers and old tools if any as well as computer software an example is a computer that is being used in the company enough your computer may have insufficient hard disk space as well as the software that may have to buy a new or newly developed etc The likelihood of people is the company with the appropriate parties to develop and install the system enough if there is nowhere to be found or not etc In addition there should be more interested in how people use the system and how opinions change as well as the opinion of the Director 1 3 Analysis The analysis of the
53. the design knowledge systems vary according to the therefore the duty of state analysts are studying the system and make recommendations for improving and developing the system to completion that all works must have procedures and learn how to analyze and design the system in each step we understand that systems analysis is better and can design new systems can be more difficult without having to decide whether a new system should use the computer category use the program s Input output design how etc 2 4 2 Design and Analysis System And system design is a method used to create information systems in which one business or business of subsystem in addition to creating a new information system analysis of the system of aid in correcting existing information systems to better with it system analysis is a requirement of the information system that is nothing more or nothing into the system and it is designed to bring system into a plan or so called blueprint to build information systems that actually works for example the sales system information system Requirements of the system is able to track sales to management can improve sales nick sample sales report said it suggests that we can keep track of how sales 2 4 3 The Development cycle system System Development Life Cycle Have the same life cycle from the grave this cycle is a sequence of steps from start to finish is an active system which system analysts to better understand how each step is done and
54. y developed system has been applied already the maintenance procedure it happens this is a fault in the operation of the program may have just discovered which will need to continue editing including cases where the data stored there is much more to this event supports the plan additionally maintenance tasks are associated with additional programming if a user has increased demand 2 Work Plan Flowchart Work Plan is a diagram with the use of graphic symbols and arrows represent the flow of a program or system step by step as well as the direction of data flow from the first until the desired result 14 2 1 Symbols of Flowchart Flowchart programming consists of using symbols that are called symbols ANSI the American National Institute to create work flows as in the following example Beginning end of the Program The arrows show the direction of the flow of Information Use the display command in the processing or configuration information to a Variable To receive or provide information without specifying the type of the Device Condition monitoring to do One of The Document video output to a Printer Displays the connection point of the flowchart O or multiple lines of convergence are to go to work one of the same L Display on screen Fig 2 5 Displays Symbols in the Written Program Flowchart 15 2 2 The information flow phapkrasae plan Data Flow Diagram DFD Is a too

Download Pdf Manuals

image

Related Search

Related Contents

HP F1381A User's Manual  Détecteur de passage infrarouge Détecteur de passage infrarouge  DevLink-P200_Protocols converter  Smart client User Manual    GAINSKEEPER USER MANUAL  

Copyright © All rights reserved.
DMCA: DMCA_mwitty#outlook.com.