University of Agriculture, Faisalabad Department of Computer Science Synopsis for M.
Sc. Degree in Computer Sciences Title: Online Hotel Management System for The Pizza Shop, D-Ground, Faisalabad Name of the student: Registration No. : Abstract The purpose of this system is the development of a web-based system for managing information of The Pizza Shop, D-Ground, Faisalabad. This system will able to handle the menu selection and bill payment deal accurately and efficiently. This system will have a central database for its all branches.It will solve the problem of existing manual system which is difficult to serve and ordering services table. The proposed system will allow online ordering effectively and efficiently to customers and will provide immediate delivery. Customers can pay bills at delivery time.
The proposed system will be easy to use to manage and more convenient for customers when placing order. It will have a number of facilities to select or check the menu items and payments will also provide on interface to handle all transactions easily.The SQL or MYSQL Server will be used as a database backend database and PHP or ASP as frontend for programming user applications. University of Agriculture, Faisalabad Department of Computer Science Synopsis for M. Sc. Degree in Computer Sciences Title: Online Hotel Management System for The Pizza Shop, D-Ground, Faisalabad Date of Admission:October, 2010 Data of Initiation (Research):After approval Probable Duration (Research):4 Months PERSONNEL: a) Name of the student: b) Registration No. : c) Supervisory committee i)(Supervisor) ii)(Member) iii) Mr. Muhammad Zafar Iqbal(Member) Introduction t present the hotels and restaurants are using the manual system.
They recorded by hand in registers and notebooks. The physical system has a number of shortfalls. Customers can select any items using the planned system.
The database administrator in the administrative headquarters will entitle customers to a limited use. All branches sent daily reports to the main branch and manage record efficiently. The data will be centralized at the main branch.
Accurate information extracted by the choice of good database. Writing accurate statement will helps for getting precise information about the records good database keep records in well manner.Database backbone of every organization, insertion deletion and updation define in easy way. Correct information and good database going equivalent for precise result (Gogolla, 2007). The computer is converted in a need of the day. Because computers are involved in all areas of life, therefore, control of project managers is controlled by computers. The systems are based on computer are very helpful in solving difficult problems.
Large amount of data and complex calculations and repetitive tasks fall into the domain of computer use (Varshavsky, 2007).Many companies experienced the impact of new technologies in the 1980s and early 1990s. It has recently been realized that the technologies are converging, raising more primary skill and resourcing. Technology while still de-skill a large number of jobs.
The emphasis has shifted from people with technical staff to use sophisticated computer technology and display high levels of customer service (Nuseibe, 2010). The main purpose of this research is to facilitate customer orders online selection, online bill payments and facilitate customers by offering fast order delivery. All data management due to centralized data effectively.
The system will provide quick access in an easy to obtain the necessary information about the current state of the restaurant. The state will tell you about different deals offered by the restaurant. Different types of data are provided by the generation of reports that help in making decisions on the basis of these reports. Objective The main objective of developing the proposed system is to facilitate the customer by the easy accessibility and convenience, the user interface will so easy to use that customers can place orders, and can go through hotel information online 24 / 7.Review of Literature Al-Ahmad (2006) recognized that Object-Oriented Programming (OOP) can be explained as a model for building software. In OOP, a program execution is considered a physical model, simulating either a real or imaginary part of the world. In OOP, concepts in the classification (things, behavior, relationships, etc. ) and real phenomena (special cases of aircraft, flight, security stocks, etc.
) are represented as classes and objects, respectively, in the model of computer system.In OOP, key concepts are modeled as classes that are ordered hierarchically so that a new class (subclass) is generally defined based on a given class (super class) using inheritance. Dhamayanthi and Thangavel (2006) adopted the framework. NET is a set of products for the development and management of systems with tiered architectures and object oriented. A framework generally include several design patterns is too . NET, The Assist patterns composing the frame architecture suitable for many different applications without redesign. An additional advantage is that the framework recognizes the design pattern you use.This paper is intended to present .
NET versions for selected structural patterns. With the seven structural patterns discussed by Gang of Four (GOF), five are discover with the help of . NET framework. Gogolla et al.
(2007) stated that Unified Modeling Language (UML) It provides significant today as a standard for software development. UML tools however provide light support for model validation and inspection in the early stages of development. Nor is there significant support for the Object Constraint Language (OCL). We present an approach for the support of UML models and OCL constraints based on animation and documentation.The purpose tool (UML-based environment under) supports analysts, designers and developers in executing UML models and OCL constraints examination and therefore allows them to employ model-based techniques for software decision. Thomas et al. (2008) said the structured query language (SQL) is a language used with interactive usual relational databases.
A SQL statement is a unit of execution that returns a single result set from a database. An exhibition is the result of a software glitch that gives an attacker access to a computer system involuntary.SQLIV allow entry attacker to modify SQL structure via a SQL injection attack (SQLIA), which changes the logic of the SQL statement. An attack is a sequence of actions that exploit the vulnerability, often with devastating consequences. A SQLIA is a SQL injection attempt characters and / or keywords in the entrance of a SQL statement to modify the structure of the statement Koopmann (2009) explained that a word of caution with new unseen index function to be attentive to the other indexes created or changed without your knowledge invisible.If you have to watch over SQL index structures which now have to add checking this column visibility or else you will not see the full picture of the indexes that are being maintained by DML but do not contribute to the selectivity. This could become a nightmare for hidden applications when doing a lot of insertion, updating or deletion.
Farooq (2010) reported that The Unified Modeling Language (UML) is an Object Management Group. Object-oriented. Modeling information standard.
it consists of a set of notations for modeling systems diversity of viewpoints and at different levels of generalization.While the UML reflects some of the best models Object-oriented modeling experiences presented, there is a lack of semantic precision that is essential whether to use the notations to exactly model systems to cause severe and on the models. Zaveri and Hammerstrom (2010) discribed (SQL) Structured Query Language that is used to match the database middleware on these classes and modules database applications are one of the largest domain software and most important in the world. Some of the classes or modules in such applications are responsible for database operations.
SQL is used to exchange a few words with the database middleware on these classes or modules. It can be issued interactively or attached to a host language. The objective of this work is expected to software development defects in PL / SQL SQL files using metrics.
Based on actual project data desert, The SQL metrics are empirically validated by analyzing its association with the probability of error detection through PL / SQL files. Ruparelia (2010) explained a web application server assistances a standard HTTP web server applications from a standard Web server to perform a variety of tasks, such as form processing and database access.The predominant Web application server for the popular open source Apache Web server is PHP (PHP Hypertext Preprocessor). This document provides an overview of the PHP programming language and its important functionality, including form testing and database access.
The paper also discusses campus applications of PHP, including campus service projects, a field of computer science in the development of web applications and student projects. Liu (2010) said it is a popular result premise SQL database that can’t transmit recursive queries, such as skill range; in fact, a new building was added to SQL3 to overcome this limitation.However, the indication of this state is usually given in the form of a reference to the evidence that relational algebra can’t express such queries. SQL, on the other hand, in all its implementations has three aspects that differ fundamentally from relational algebra: namely, grouping, arithmetic operations, and aggregation.
Allison (2011) reported that development is an object-oriented analysis and software design approach where system designers assume in terms of” things” instead of operations and variables. This involves designing object classes and relations between these classes.A class module is an “idea” that provides a model for the attributes and services that the object is.
An object is an occurrence of the class module. Materials and Methods There are many problems in the manual system, because this system of web-based information is entered and also able to know the data is maintained in the computer system. There are many ways through which can be developed software application.
All business organizations so that you can easily recover, and the management system database is useful for these tasks. Reduced time consumption by using computerized systems.This is responsible for these tasks. Tabular data will be manipulated by giving orders (Sharifian, et al. 2011). The graphical user interface will be used as the front end, and developed in PHP or ASP.
SQL server is used for background design, storage and handling of data. Different reports are generated as required. Data redundancy is removed by the SQL server (Rao and Babu, 2009).
The method will be used water fall in the hotel management system. In the waterfall process method includes the identification and selection of projects, project initiation and planning, analysis, design, implementation and maintenance.In the first phase of the information needs of the system will be identified. After the first phase the gantt chart will be developed as a timeline for the determination of the task in the project initiation and planning phase. During analysis phase the investigation will be carried out, including the exchange of ideas on software, which will be going to be and what purpose will be fulfilled. Then, the logical design phase information system will be designed for the user interface. The interface plays an important role in connecting the user with the system.
In the last the phase of the waterfall model, where the complete software will be given to the customer after the test. After that software has been implemented at the client’s site, it will be the duty of the software development team to carry out routine maintenance activities by visiting the customer. LITERATURE CITED Al-Ahmad, W. 2006.
A framework for conceptual modeling in OOP. Journal of the Franklin Institute, 343(221): 532-544. Allison, C. and N. Liddle. 2011.
OOP: the rest of the story. Journal of Computing Sciences in Colleges, 27(2): 77-84. Dhamayanthi, N.
nd P. Thangavel. 2006. Structural Design Patterns and .
NET Framework 2. 0. Journal of Object Technology, 5(8): 59-80.
Farooq, S. U. and S.
M. K Quadri. 2010. Software Testing-Goals, Principles, and Limitations, Verification and Validation. International Journal of Computer Application, 6(9): 7. Gogolla, M. , F. Buttner and M.
Richters. 2007. A UML-based specification environment for validating UML and OCL. Journal of Science of Computer Programming, 7 (13): 7. Han, T. , C.
Woo and J. L. Zhao. 2008. Recent advances in information technology and systems in the Internet-era.
Decision Support Systems, 45(4): 663-664 Koopmann, J. 2009. Oracle Invisible Indexes and Index Usability, Create an index in production have not always been soundly rooted. Journal of database knowledge center for database professionals, 21(9): 81-82. Liu, C.
2010. Measuring and prioritising value of mobile phone usage. International Journal of Mobile Communications, 8(1): 41-52. Nuseibeh, B. 2010. Weaving Together Requirements and Architecture. Journal of IEEE Computer, 34(3): 117-125. Poole, L.
2005. Cellular Communications Explained From Basics to 3G.Oxford, Chapter 6 – GSM, 79-102. Rao, K. P. and G.
A. Babu. 2009. Microsoft C# .
NET program and electromagnetic depth sounding for large loop source. Journal of Microsoft . NET Program and Electromagnetic Depth Sounding for Large Loop Source, 35(7): 1369-1378.
Ruparelia, N. B. 2010. Software development lifecycle models. Newsletter ACM SIGSOFT Software Engineering Notes, 35(3):8-13. Sharifian, S.
, Seyed, A. M. and Mohammad, K.
A. 2011. A predictive and probabilistic load-balancing algorithm for cluster-based web servers Original Research Article. ournal of Applied Soft Computing, 11(1): 970-981. Thomas, S. , L. Williams and T. Xie.
2008. On automated prepared statement generation to remove SQL injection vulnerabilities. Journal of Information and Software Technology, 51(3): 589-598. Varshavsky, A. , E. D. Lara, J.
Hightower, A. LaMarca and V. Otsason. 2007.
GSM indoor localization, Journal of Pervasive and Mobile Computing, 3(6): 698-720. Zaveri, M. S. and D. Hammerstrom. 2010.
Performance price estimates for cortex-scale hardware: A design space exploration. Journal of Neural Networks, 24(3): 291-304.