Database Management System

little Hire firm is a sm each(prenominal) family descent that stocks habitual equipment such(prenominal) as garden tools, railroad car maintenance tools etc. For hiring to its customers. A entropybase schema is required to simplify management of the business and to entrust nigh pecuniary information and maintaining stocks. Equipments argon bodified under various categories.Equipments atomic number 18 of opposite brands at heart each(prenominal) category. Brands are varies in their prices and obtained from various suppliers. The know categories are a) Gardening Equipment d) Decorating Equipment g) Heating and Lighting b) Building Equipment e) gondola car Maintenance h) Miscellaneous c) Access Equipment f) Power Tools Prices of equipment offered by the various suppliers as well as the sales pitch clipping for that equipment mustinessiness be kept in the DB. The firm arranges for business customers only, a 24-hour stand out to deputise any Rosen or faulty equipme nt that on hire.Upon receiving a customer complain, an immediate delivery leave al unmatched be arranged to replace the faulty equipment provided that it is in stock. Otherwise, a refund for the full charged amount forget be administered. Private customers though, in similar cases, must bring the faulty equipment(s) themselves and replace them with working cardinals or engage a full refund if there isnt any ready(prenominal) in stock. Business customers are given various membership categories for discount purposes. These are silver, gold and diamond memberships.Silver members get 10% coin members get 25% and Diamond members get 40%. Hiring equipments for private customers are restricted to those who live within 5 miles radius from their address. This distance from the private customer address is measured on map on the wall and the information stored on the customer record the first time the hire equipments. No such restriction exists for business customers. Requirements The s pare-time activity sections specify the requirements of the organization. The computer is to be use when a customer visits the company to hire equipments.At this time the following processing is necessary for each transaction If not already known (I. E. Not introductoryly entered into the DB), the customers exposit are enter. The equipment to be hired, with expected return date, is recorded. The equipment stock as recorded in the database is updated automatically. When business customers call for support to replace any broken or faulty equipments on hire, a log must be do in the DB and whether replacement equipment is arranged and delivered or a full refund is given.When the equipment is returned, the following processing is required The actual return date is entered. An bank bill is printed which shows the item borrowed and calculates the total appeal including VAT. The cost should be establish on a rate for one day plus a rate for each additional day. The daily rate var ies between weekdays and weekend days. The stock figures are ad notwithstandinged. Business customer discounts leave be calculated according to the membership category, fleck no discount is given to private customers. 2. 3. 4. physical body and create a database to the above scenario.State any assumptions made (if any). Map the diagram in to Relational abstract and Proof your answer is normalized up to BC. Create the Database turnment Myself. Final report should contain 0 Assumptions 0 Entity Relationship plot 0 Relational Schema 0 Proof of Normalization 0 Myself commands which you founder utilise to create the database naming Background A Database charge frame (DBS) is a set of programs that en fittings you to store, modify, and extract information from a database, it also provides substance ab drug users with tools to add, delete, access, modify, and analyze data stored in one location.A group endure access the data by using query and account tools that are part of the DBS or by using activity programs specifically written to access the data. subsidisation Requirements 1 . The final written document should be Professional and dodge of rulesatic computerized document. 2. It is essential to bind References (if any). 3. Assignment should be word-processed and should be spiral bound. 4. The scallywag after the lead page should be as the assignment patsy scheme (Attachment No 001). 5. Submit the sof twainod of the assignment along with the bound hard copy. Written Assignment FormatTo receive full credit, assignments should maintain the following format 0 Font Caliber, Size apt. 0 Spacing standard. 0 File type (for electronic submission by prior arrangement) MS leger (. Doc only) 0 Name/headers/footers on each page. Page number on each page. Cover page/ Contains page. Rules and Regulation of the Assignment 1 . Assignments will NOT be accepted after the coda date of acceptance under any circumstance.Database wariness SystemBABCOCK UNIVER SITY ILISHAN REMO OGUN STATE bug emerge PROPOSAL IN PARTIAL FULFILLMENT OF THE COURSE SOFTWARE ENGINEERING COMPUTER SCIENCE ON HOTEL MANAGEMENT scheme GROUP 8 labor MEMBERS 1. XXXXXXX 2. XXXXXXXXXXX 3. XXXXXXXXXXXX 4. XXXXXXXXXX 5. OBRUTSE ONAJITE 09/1635 6. OKOROSOBO TEMITOPE 7. OLAJIDE SEGUN 8. XXXXXXXXXX 9. XXXXXXXX 10. XXXXXXXXXX PROJECT MANAGER MRS AYITE 1. INTRODUCTION A. BACKGROUND Online Alumni System An Alumni Management System is a system that helps in keeping the records of the past students in which that it tail assembly be sorted by the class or by their major.Alumni management system is implemented in various schools almost the globe, so it arsehole help the student to get together when there is the deal to get together, whitethornbe for a get together Dinner and so on. B. SCOPE /OVERVIEW The Online alumni system is blueprinted to maintain the enlarge of the past student, so when the school wants to check the year a student graduated for most unforeseen c ircumstances. Using this take to, the executive director registers each past student into the directory and gives them their username and password so they tin login and update their profile. The Alumni Management System provides following features. Members Directory * Online photo gallery * Comment posting facility C. STATEMENT OF PROBLEM The rent of the software package is to mount a software that helps the university to keep good record of their old students, in vagabond to refer to them when necessary, even up on occasions where they want to make a year book for the graduating class or something. D. PROJECT OBJECTIVES OBJECTIVE The central objective of this stomach is to provide facility for record system for the university committee. In previous system (i. e. Manual System), the student has to queue up to register his/her name in the alumni register on paper.Database Management System and DataThis was the fully time consuming, expensive etc. Through this return, he send word update his database whitethornbe when he is married and he wants to change his status to married and so on. 2. arrangement psychodepth psychology System analysis is the process of gathering and interpreting facts, diagnosing problems and using the facts to make better the system. System analysis specifies what the system should do. A system is a set of components that interact to accomplish some purpose. * Identifying the drawback of the animated system * Identify the sine qua non for conversion * Perform feasibility orbit * Identify hardware, software and database requirements Create a system definition that forms the foundation for subsequent work A. SYSTEM get a line Overview of the brisk System In the existing system user female genitalia calculate so much problems. They set about to waist so much time for the registering. This is the time consuming task. Sometimes user is very shopworn and then they face the so much problem. Sometimes user feel the lazi ness, this is also failure for the existing system. B. FEASIBILITY STUDY The feasibility of a realise underside be ascertained in foothold of technical factors, economical factors, or both. A feasibility work is documented with a report presentation all the ramifications of the formulate.Technical feasibility Technical feasibility refers to the ability of the process to take advan drop behinde of the current bow of the technology in pursuing further improvement. The technical capability of the personnel as well as the capability of the in stock(predicate) technology should be considered. Technology transfer between geographical areas and cultures needs to be analyzed to fancy productiveness loss (or gain) due to differences (see Cultural feasibility). Since we are using PHP 5, tom 6. 0 and so on technically our project is feasible. Economic feasiblenessThis involves the feasibility of the proposed project to generate economic benefits. A benefit-cost analysis and a break even analysis are important aspects of evaluating the economic feasibility of new industrial projects. The real and intangible aspects of a project should be translated into economic terms to facilitate a consistent fundament for evaluation. Cultural Feasibility Cultural feasibility deals with the compatibility of the proposed project with the cultural setup of the project environment. In effortful projects, planned functions must be integrated with the local cultural practices and beliefs.For example, religious beliefs may yield what an undivided is willing to do or not do. Social Feasibility Social feasibility addresses the influences that a proposed project may have on the social system in the project environment. The ambient social building may be such that certain categories of workers may be in short supply or nonexistent. The effect of the cypher on the social status of the project participants must be assessed to turn back compatibility. It should be recognized that workers in certain industries may have certain status symbols within the society. Scope of Feasibility psychoanalysisIn general terms, the elements of a feasibility analysis for a project should cover the following I. Need Analysis This indicates recognition of a need for the project. The need may affect the organization itself, another organization, the public, or the giving medication. A preliminary playing area is then conducted to confirm and evaluate the need. A proposal of how the need may be satisfied is then made. Relevant questions that should be asked include * Is the need significant enough to justify the proposed project? * Will the need still exist by the time the project is completed? * What are the utility(a) means of substantive the need? What are the economic, social, environmental, and political impacts of the need? II. Process Work This is the preliminary analysis done to set apart what will be required to satisfy the need. The work may be serveed by a cons ultant who is an expert in the project field. The preliminary study often involves system models or prototypes. For technology-oriented projects, artists conception and scaled-down models may be utilise for illustrating the general characteristics of a process. A simulation of the proposed system can be carried out to predict the outcome before the actual project starts. III. Engineering & DesignThis involves a little technical study of the proposed project. Written quotations are obtained from suppliers and subcontractors as needed. Technology capabilities are evaluated as needed. Product intention, if needed, should be done at this time. IV. Cost Estimate This involves estimating project cost to an acceptable level of accuracy. Levels of around -5% to +15% are greens at this level of a project plan. Both the initial and operating cost are include in the cost estimation. Estimates of capital investment and of recurring and nonrecurring costs should also be contained in the cost estimate document.Sensitivity analysis can be carried out on the estimated cost set to see how cranky the project plan is to the estimated cost values. V. Financial Analysis This involves an analysis of the cash lead profile of the project. The analysis should consider rates of return, inflation, sources of capital, payback periods, breakeven point, residual values, and sensitivity. This is a critical analysis since it determines whether or not and when finances will be available to the project. The project cash flow profile helps to support the economic and financial feasibility of the project. VI. Project ImpactsThis portion of the feasibility study provides an assessment of the impact on the proposed project. Environmental, social, cultural, political, and economic impacts may be some of the factors that will determine how a project is perceived by the public. The value added electric potential of the project should also be assessed. A value added tax revenue may be assesse d based on the price of a product and the cost of the raw material used in making the product. The tax so collected may be viewed as a contri stillion to government coffers. Conclusions and Recommendations The feasibility study should end with the overall outcome of the project analysis.This may indicate an endorsement or disapproval of the project. Recommendations on what should be done should be included in this section of the feasibility report. 3. SYSTEM DESIGN System design provides the understanding and procedural details necessary for implementing the system recommended in the system study. Emphasis is on translating the performance requirements into design specifications. The design phase is a transition from a user oriented document (System proposal) to a documented oriented to the programmers or database personnel. A. GRAPHICAL REPRESENTATION I.Entity Relationship Diagram It is clear that the physiologic objects from the previous section the administrator, styles, custo mer all correspond to entities in the Entity-Relationship model, and the operations to be done on those entities. Date of Birth Date of Birth SEX SEX wee-wee NAME educatee Student Email Email Address Address IS A IS A graduate Alumnus IS A IS A GRADUATION YEAR GRADUATION YEAR GRADUATE assimilator GRADUATE STUDENT postgraduate POSTGRADUATE COURSE COURSE DEGREE PROGRAMME DEGREE PROGRAMME COMPUTING TOOLS A. METHODOLOGIES B. scheduling LANGUAGES TOOLS USED FOR ontogenesis talking to - PHPDatabase - My SQL Web Server - APACHE TOMCAT 6. 0 IDE - NETBEANS programming quarrel excerpt affects the productivity and enter quality in several ways. Programmers working with high level language give better productivity and quality than those working with low level language, because former is more expensive in nature. We have used HTML, PHP account booking languages for the mark as we have to make the software and these languages provide great compatibility and flexibility. Overview of programing Languages Overview of PHP The PHP technology will be used to interface HTML.The PHP technology provides a seamless conjunction and presents an unaffixed to use, PHP-like programming constructs that can be scripted within HTML files. Hypertext preprocessor is a technology for developing weather vane pages that include energising content. A PHP page contains standard markup language elements, such as HTML tags, just like a regular weave page. A PHP page also contains special PHP elements that allow the master of ceremonies to insert self-propelled content in the web page. ADVANTAGES OF PHP 1. PHP supports both scripting and element-based dynamic content. 2. totallyows developing custom tag libraries. . PHP pages are precompiled for good server processing. 4. PHP pages can be used in combination with servlets that handle the business logic. 5. last Security. . 6. High Quality tool supports. 7. Write Once, Run Everywhere. 8. PHP is vender Neutral Overview of burnt umber helping hand java script is a general purpose, prototype based, object oriented scripting language highly-developed together with by insolate and Netscape and is meant for the WWW. coffee tree script borrows most of its syntax from java but also inherits from awk and perl, with some indirect influence from self in its object prototype system. deep brown Script is almost as sonant to learn as HTML and it can be included directly in HTML documents. Java Script was developed independently of java. Java script is a high level scripting language that does not depend on or expose particular machine representations or operating system services. FEATURES OF coffee SCRIPT Java script is embedded into HTML documents and is executed with in them. Java script is browser dependent. JavaScript is an interpreted language that can be interpreted by the browser at run time. Java script is by and large typed language. Java script is an object-based language.Java script is an Event-Driv en language and supports event handlers to specify the operativeity of a button. The Struts fashion model provides the flexibility to develop the much less coupled applications. It generalizes and strictly implements MVC-model View Controller Architecture. That is the basic need of our architecture. Overview of Apache Tomcat Apache Tomcat is a servlet container developed by the Apache Software Foundation (ASF). Tomcat implements the Java Servlet and the Java Server Pages (JSP) specifications from insolate Microsystems, and provides a pure Java HTTP web server environment for Java statute to run.Tomcat should not be confused with the Apache web server, which is a C implementation of an HTTP web server these two web servers are not bundled together. Apache Tomcat includes tools for configuration and management, but can also be configure by modify XML configuration files. Overview of MySQL MySQL is a multithreaded, multi-user SQL database management system (DBMS) which has, accordi ng to MySQL AB, more than 10 one thousand thousand installations. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, which holds the copyright to most codebase. Libraries for ccessing MySQL databases are available in all major programming languages with language-specific APIs. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The MySQL server and official libraries are broadly implemented in ANSI C. C. PLATFORM I. HARDWARE SPECIFICATIONS Processor Pentium III or higher RAM 128 MB or more than Hard Disk 20 GB or More Modem 56KBPS / LAN batting order II. SOFTWARE SPECIFICATIONS operate System Windows XP, VISTA 7. Web Server ApacheFront End JSP Back End MySQL Scripts JavaScript Language JAVA III. user Interface Requirements The user of the proposed system requires that the developed software should be user friendly , have security access, and ensure the privacy of the administrator and produce results in timely manner. The users are not much exposed to the on-line hotel management, so the system interface to the user must be simple and understandable. The web pages must be user-friendly and must be in an easy-to-use style. The user must be able to slow teddy among various I/O screens.The product is well knowing so that it can be used easily by layman and also the users who are novices to the system. The system should be knowing in such a way that only beginningized users should be allowed to login to the system. The user interface should be as interactive as possible. A user-friendly interface must be provided so that the user can easily interact with the system and comprehend things in a quicker and easier way. The system must provide safe and up-to-date information. The application should be efficient so that the user does not expend much time in training.Consistency will increase th e confidence of the user in the reliability of the application. The user must be limited with a small set of operations to achieve the result. The application should be visually and conceptually clear. The interface should accommodate user mistakes easily and fast. It should minimize the errors and should handle them peacefully. IV. Database Requirements The database should be designed in such a way that it enhances the efficient storage, retrieval and manipulation of all the information associated. For representative all general information regarding an item attribute should be stored in a particular table.The concerned users should have the facility to query to the database and supply the basic information easily. Security mechanisms should be provided so that no confidential details should be accessible to unauthorized persons. The database should be organized in such a way that it helps in preparing various essential summaries needed for users. V. Functional Requirements The v arious functional requirements of the system can be summarized as 1. A home page that is user friendly and ambiguous. 2. Administrator Login Facility 3. relate to other colligate sites. 4.Ability of Administrator to perform any tasks which you can see in my snapshots (below) and in my trial project. 5. A login page for alumnus to create a new user if not registered VI. Non-Functional Requirements Non-functional requirements define the system properties and constraints that arise by means of user needs, because of the budgeted constraints or organizational policies, or because of the need for interoperability with other software or due to the immaterial factors such as safety regulations privacy registrations and so on. VII. Other Requirements and ConstraintsPerformance Requirements * The database should be centralize and secure. * The system should be user friendly and easily accessible * The system must be reliable. Design Requirements The main objectives of stimulation desig n are * Controlling the amount of input * Keeping the process simple, avoiding errors. * The lift out thing in the input design is to achieve all the objectives mentioned in the simplest manner possible. The main objectives of takings design are * Identifying the specific outputs. * Creating reports for displaying and storing information. 4. MILESTONES A.TIMELINES I. DISTRIBUTION OF TASKS AND SUBTASKS II. TEAM MEMBERS RESPONSIBILITIES Each project member has been given a role to perform which will make the project work go smoothly. III. PROPOSED TIMEFRAME FOR distributively TASK AS ASSIGNED B. DEADLINES FOR EACH TASK AND MODULES C. PROPOSED DUE DATE 5. POSSIBLE TEST CASES AND PLANS 6. LIMITATIONS The Hotel Management System can be used for any organization that may require detailed information at one time or the other. This application covers a relatively large scope more than is highlighted in this project work.There is always room for improvement depending on the in tending area of application. For the purpose of this project, however, we will use Arzu Hotels as a set case. The limitations of this project are * Unavailability of sufficient time due to tight academic schedule. * deficiency of internet connection to perform necessary research Despite these limitations, we will be able to design a functional Hotel Management System. 7. CONCLUSION From a proper analysis of positive points and constraints on the component, it can be safely concluded that the product is a highly efficient GUI based component.This application is working the right way and meeting to all user requirements. This component can be easily out of use(p) in many an(prenominal) other systems. 8. APPENDIX I. schedule Programming is not only a inventive activity but also an intellectually rigorous discipline. It is the part where the design is actually translated into the machine clean form which is called program. II. Programming Principles The main activity of coding ph ase is to translate design into code. If we translate the social organization of the design properly, we will have structured programs. A structured program doesnt just extend.It is the end product of series of efforts that try to understand the problem and develop a structured, understandable resolvent plan. It is all unattainable to write a good structured program based on unregulated poor design . The coding phase affects both testing and maintenance , profoundly the time spent in coding is small dower of the total software cost, while testing and maintenance fine-tune the major percentage . The goal of coding phase is not to simplify the job of the tester and maintainer. III. Programming style A well written program is more easily read and understood both by the author and by others who work that program.A good Programming style is characterized by the following * ease * Readability * nigh(a) documentation * Changeability * Predictability * Good Structure IV. Selection of Coding Language All the programs coded should be based on a standard which can tend to the needs of all readers, i. e. it should provide degree of predictability in programs of a common type. There are many aspects to what the programs must do so to enable the different users to comfortably work on it. For example the program should * Be corrective of the root * Have maximum speed of execution * Be comprehensive and east to maintainDatabase Management SystemBABCOCK UNIVERSITY ILISHAN REMO OGUN STATE PROJECT PROPOSAL IN PARTIAL FULFILLMENT OF THE COURSE SOFTWARE ENGINEERING COMPUTER SCIENCE ON HOTEL MANAGEMENT SYSTEM GROUP 8 PROJECT MEMBERS 1. XXXXXXX 2. XXXXXXXXXXX 3. XXXXXXXXXXXX 4. XXXXXXXXXX 5. OBRUTSE ONAJITE 09/1635 6. OKOROSOBO TEMITOPE 7. OLAJIDE SEGUN 8. XXXXXXXXXX 9. XXXXXXXX 10. XXXXXXXXXX PROJECT MANAGER MRS AYITE 1. INTRODUCTION A. BACKGROUND Online Alumni System An Alumni Management System is a system that helps in keeping the records of the past students in which that it can be sorted by the year or by their major.Alumni management system is implemented in various schools around the globe, so it can help the student to get together when there is the need to get together, maybe for a get together Dinner and so on. B. SCOPE /OVERVIEW The Online alumni system is designed to maintain the details of the past student, so when the school wants to check the year a student graduated for some unforeseen circumstances. Using this project, the administrator registers each past student into the directory and gives them their username and password so they can login and update their profile. The Alumni Management System provides following features. Members Directory * Online photo gallery * Comment posting facility C. STATEMENT OF PROBLEM The aim of the software is to develop a software that helps the university to keep good record of their old students, in order to refer to them when necessary, even on occasions where they want to make a year book for th e graduating class or something. D. PROJECT OBJECTIVES OBJECTIVE The central objective of this project is to provide facility for record system for the university committee. In previous system (i. e. Manual System), the student has to queue up to register his/her name in the alumni register on paper.Database Management System and DataThis was the fully time consuming, expensive etc. Through this product, he can update his database maybe when he is married and he wants to change his status to married and so on. 2. SYSTEM ANALYSIS System analysis is the process of gathering and interpreting facts, diagnosing problems and using the facts to improve the system. System analysis specifies what the system should do. A system is a set of components that interact to accomplish some purpose. * Identifying the drawback of the existing system * Identify the need for conversion * Perform feasibility study * Identify hardware, software and database requirements Create a system definition that for ms the foundation for subsequent work A. SYSTEM STUDY Overview of the Existing System In the existing system user can face so much problems. They have to waist so much time for the registering. This is the time consuming task. Sometimes user is very tired then they face the so much problem. Sometimes user feel the laziness, this is also failure for the existing system. B. FEASIBILITY STUDY The feasibility of a project can be ascertained in terms of technical factors, economic factors, or both. A feasibility study is documented with a report showing all the ramifications of the project.Technical Feasibility Technical feasibility refers to the ability of the process to take advantage of the current state of the technology in pursuing further improvement. The technical capability of the personnel as well as the capability of the available technology should be considered. Technology transfer between geographical areas and cultures needs to be analyzed to understand productivity loss (or gain) due to differences (see Cultural Feasibility). Since we are using PHP 5, Tomcat 6. 0 and so on technically our project is feasible. Economic FeasibilityThis involves the feasibility of the proposed project to generate economic benefits. A benefit-cost analysis and a breakeven analysis are important aspects of evaluating the economic feasibility of new industrial projects. The tangible and intangible aspects of a project should be translated into economic terms to facilitate a consistent basis for evaluation. Cultural Feasibility Cultural feasibility deals with the compatibility of the proposed project with the cultural setup of the project environment. In labor-intensive projects, planned functions must be integrated with the local cultural practices and beliefs.For example, religious beliefs may influence what an individual is willing to do or not do. Social Feasibility Social feasibility addresses the influences that a proposed project may have on the social system in the p roject environment. The ambient social structure may be such that certain categories of workers may be in short supply or nonexistent. The effect of the Project on the social status of the project participants must be assessed to ensure compatibility. It should be recognized that workers in certain industries may have certain status symbols within the society. Scope of Feasibility AnalysisIn general terms, the elements of a feasibility analysis for a project should cover the following I. Need Analysis This indicates recognition of a need for the project. The need may affect the organization itself, another organization, the public, or the government. A preliminary study is then conducted to confirm and evaluate the need. A proposal of how the need may be satisfied is then made. Relevant questions that should be asked include * Is the need significant enough to justify the proposed project? * Will the need still exist by the time the project is completed? * What are the alternate mea ns of satisfying the need? What are the economic, social, environmental, and political impacts of the need? II. Process Work This is the preliminary analysis done to determine what will be required to satisfy the need. The work may be performed by a consultant who is an expert in the project field. The preliminary study often involves system models or prototypes. For technology-oriented projects, artists conception and scaled-down models may be used for illustrating the general characteristics of a process. A simulation of the proposed system can be carried out to predict the outcome before the actual project starts. III. Engineering & DesignThis involves a detailed technical study of the proposed project. Written quotations are obtained from suppliers and subcontractors as needed. Technology capabilities are evaluated as needed. Product design, if needed, should be done at this time. IV. Cost Estimate This involves estimating project cost to an acceptable level of accuracy. Levels of around -5% to +15% are common at this level of a project plan. Both the initial and operating costs are included in the cost estimation. Estimates of capital investment and of recurring and nonrecurring costs should also be contained in the cost estimate document.Sensitivity analysis can be carried out on the estimated cost values to see how sensitive the project plan is to the estimated cost values. V. Financial Analysis This involves an analysis of the cash flow profile of the project. The analysis should consider rates of return, inflation, sources of capital, payback periods, breakeven point, residual values, and sensitivity. This is a critical analysis since it determines whether or not and when funds will be available to the project. The project cash flow profile helps to support the economic and financial feasibility of the project. VI. Project ImpactsThis portion of the feasibility study provides an assessment of the impact on the proposed project. Environmental, social, cultural, political, and economic impacts may be some of the factors that will determine how a project is perceived by the public. The value added potential of the project should also be assessed. A value added tax may be assessed based on the price of a product and the cost of the raw material used in making the product. The tax so collected may be viewed as a contribution to government coffers. Conclusions and Recommendations The feasibility study should end with the overall outcome of the project analysis.This may indicate an endorsement or disapproval of the project. Recommendations on what should be done should be included in this section of the feasibility report. 3. SYSTEM DESIGN System design provides the understanding and procedural details necessary for implementing the system recommended in the system study. Emphasis is on translating the performance requirements into design specifications. The design phase is a transition from a user oriented document (System proposal) to a documented oriented to the programmers or database personnel. A. GRAPHICAL REPRESENTATION I.Entity Relationship Diagram It is clear that the physical objects from the previous section the administrator, rooms, customer all correspond to entities in the Entity-Relationship model, and the operations to be done on those entities. Date of Birth Date of Birth SEX SEX NAME NAME Student Student Email Email Address Address IS A IS A Alumnus Alumnus IS A IS A GRADUATION YEAR GRADUATION YEAR GRADUATE STUDENT GRADUATE STUDENT POSTGRADUATE POSTGRADUATE COURSE COURSE DEGREE PROGRAMME DEGREE PROGRAMME COMPUTING TOOLS A. METHODOLOGIES B. PROGRAMMING LANGUAGES TOOLS USED FOR DEVELOPING Language - PHPDatabase - My SQL Web Server - APACHE TOMCAT 6. 0 IDE - NETBEANS Programming language choice affects the productivity and code quality in several ways. Programmers working with high level language achieve better productivity and quality than those working with low level language, because former is more expensive in nature. We have used HTML, PHP scripting languages for the coding as we have to make the software and these languages provide great compatibility and flexibility. Overview of Programming Languages Overview of PHP The PHP technology will be used to interface HTML.The PHP technology provides a seamless connection and presents an easy to use, PHP-like programming constructs that can be scripted within HTML files. Hypertext preprocessor is a technology for developing web pages that include dynamic content. A PHP page contains standard markup language elements, such as HTML tags, just like a regular web page. A PHP page also contains special PHP elements that allow the server to insert dynamic content in the web page. ADVANTAGES OF PHP 1. PHP supports both scripting and element-based dynamic content. 2. Allows developing custom tag libraries. . PHP pages are precompiled for efficient server processing. 4. PHP pages can be used in combination with servlets that handle th e business logic. 5. High Security. . 6. High Quality tool supports. 7. Write Once, Run Everywhere. 8. PHP is vender Neutral Overview of Java Script Java script is a general purpose, prototype based, object oriented scripting language developed jointly by sun and Netscape and is meant for the WWW. Java script borrows most of its syntax from java but also inherits from awk and perl, with some indirect influence from self in its object prototype system.Java Script is almost as easy to learn as HTML and it can be included directly in HTML documents. Java Script was developed independently of java. Java script is a high level scripting language that does not depend on or expose particular machine representations or operating system services. FEATURES OF JAVA SCRIPT Java script is embedded into HTML documents and is executed with in them. Java script is browser dependent. JavaScript is an interpreted language that can be interpreted by the browser at run time. Java script is loosely type d language. Java script is an object-based language.Java script is an Event-Driven language and supports event handlers to specify the functionality of a button. The Struts framework provides the flexibility to develop the much less coupled applications. It generalizes and strictly implements MVC-model View Controller Architecture. That is the basic need of our architecture. Overview of Apache Tomcat Apache Tomcat is a servlet container developed by the Apache Software Foundation (ASF). Tomcat implements the Java Servlet and the Java Server Pages (JSP) specifications from Sun Microsystems, and provides a pure Java HTTP web server environment for Java code to run.Tomcat should not be confused with the Apache web server, which is a C implementation of an HTTP web server these two web servers are not bundled together. Apache Tomcat includes tools for configuration and management, but can also be configured by editing XML configuration files. Overview of MySQL MySQL is a multithreaded, multi-user SQL database management system (DBMS) which has, according to MySQL AB, more than 10 million installations. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, which holds the copyright to most codebase. Libraries for ccessing MySQL databases are available in all major programming languages with language-specific APIs. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The MySQL server and official libraries are mostly implemented in ANSI C. C. PLATFORM I. HARDWARE SPECIFICATIONS Processor Pentium III or higher RAM 128 MB or More Hard Disk 20 GB or More Modem 56KBPS / LAN Card II. SOFTWARE SPECIFICATIONS Operating System Windows XP, VISTA 7. Web Server ApacheFront End JSP Back End MySQL Scripts JavaScript Language JAVA III. User Interface Requirements The user of the proposed system requires that the develop ed software should be user friendly, have security access, and ensure the privacy of the administrator and produce results in timely manner. The users are not frequently exposed to the on-line hotel management, so the system interface to the user must be simple and understandable. The web pages must be user-friendly and must be in an easy-to-use style. The user must be able to easily switch among various I/O screens.The product is well designed so that it can be used easily by layman and also the users who are novices to the system. The system should be designed in such a way that only authorized users should be allowed to login to the system. The user interface should be as interactive as possible. A user-friendly interface must be provided so that the user can easily interact with the system and comprehend things in a quicker and easier way. The system must provide reliable and up-to-date information. The application should be efficient so that the user does not spend much time in training.Consistency will increase the confidence of the user in the reliability of the application. The user must be limited with a small set of operations to achieve the result. The application should be visually and conceptually clear. The interface should accommodate user mistakes easily and fast. It should minimize the errors and should handle them peacefully. IV. Database Requirements The database should be designed in such a way that it enhances the efficient storage, retrieval and manipulation of all the information associated. For instance all general information regarding an item attribute should be stored in a particular table.The concerned users should have the facility to query to the database and supply the basic information easily. Security mechanisms should be provided so that no confidential details should be accessible to unauthorized persons. The database should be organized in such a way that it helps in preparing various essential summaries needed for users. V. Functional Requirements The various functional requirements of the system can be summarized as 1. A home page that is user friendly and ambiguous. 2. Administrator Login Facility 3. Links to other related sites. 4.Ability of Administrator to perform any tasks which you can see in my snapshots (below) and in my running project. 5. A login page for alumnus to create a new user if not registered VI. Non-Functional Requirements Non-functional requirements define the system properties and constraints that arise through user needs, because of the budgeted constraints or organizational policies, or because of the need for interoperability with other software or due to the external factors such as safety regulations privacy registrations and so on. VII. Other Requirements and ConstraintsPerformance Requirements * The database should be centralized and secure. * The system should be user friendly and easily accessible * The system must be reliable. Design Requirements The main objectives of input design are * Controlling the amount of input * Keeping the process simple, avoiding errors. * The best thing in the input design is to achieve all the objectives mentioned in the simplest manner possible. The main objectives of output design are * Identifying the specific outputs. * Creating reports for displaying and storing information. 4. MILESTONES A.TIMELINES I. DISTRIBUTION OF TASKS AND SUBTASKS II. TEAM MEMBERS RESPONSIBILITIES Each project member has been given a role to perform which will make the project work go smoothly. III. PROPOSED TIMEFRAME FOR EACH TASK AS ASSIGNED B. DEADLINES FOR EACH TASK AND MODULES C. PROPOSED DUE DATE 5. POSSIBLE TEST CASES AND PLANS 6. LIMITATIONS The Hotel Management System can be used for any organization that may require detailed information at one time or the other. This application covers a relatively large scope more than is highlighted in this project work.There is always room for improvement depending on the intendin g area of application. For the purpose of this project, however, we will use Arzu Hotels as a set case. The limitations of this project are * Unavailability of sufficient time due to tight academic schedule. * Lack of internet connection to perform necessary research Despite these limitations, we will be able to design a functional Hotel Management System. 7. CONCLUSION From a proper analysis of positive points and constraints on the component, it can be safely concluded that the product is a highly efficient GUI based component.This application is working properly and meeting to all user requirements. This component can be easily plugged in many other systems. 8. APPENDIX I. Programming Programming is not only a creative activity but also an intellectually rigorous discipline. It is the part where the design is actually translated into the machine readable form which is called program. II. Programming Principles The main activity of coding phase is to translate design into code. If we translate the structure of the design properly, we will have structured programs. A structured program doesnt just happen.It is the end product of series of efforts that try to understand the problem and develop a structured, understandable solution plan. It is all impossible to write a good structured program based on unstructured poor design . The coding phase affects both testing and maintenance , profoundly the time spent in coding is small percentage of the total software cost, while testing and maintenance consume the major percentage . The goal of coding phase is not to simplify the job of the tester and maintainer. III. Programming style A well written program is more easily read and understood both by the author and by others who work that program.A good Programming style is characterized by the following * Simplicity * Readability * Good documentation * Changeability * Predictability * Good Structure IV. Selection of Coding Language All the programs coded should be bas ed on a standard which can tend to the needs of all readers, i. e. it should provide degree of predictability in programs of a common type. There are many aspects to what the programs must do so to enable the different users to comfortably work on it. For example the program should * Be corrective of the solution * Have maximum speed of execution * Be comprehensive and east to maintain