Database Management System

Dinky Hire firm is a sm only family trade that stocks frequent equipment such as garden tools, car tending tools and so forth For hiring to its customers. A database administration is demand to simplify management of the personal line of credit and to stomach some financial culture and take noneing stocks. Equipments atomic number 18 clubified under respective(a) categories.Equipments argon of different brands within apiece category. Brands ar varies in their wrongs and obtained from assorted suppliers. The known categories be a) Gardening Equipment d) Decorating Equipment g) Heating and Lighting b) Building Equipment e) auto Maintenance h) Miscellaneous c) Access Equipment f) Power Tools Prices of equipment offered by the various suppliers as well as the economy duration for that equipment essentialiness be unbroken in the DB. The firm arranges for business customers only, a 24-hour support to replace whatever Rosen or faulty equipment that on shoot.Upo n receiving a customer complain, an immediate delivery forget be arranged to replace the faulty equipment lowlifed that it is in stock. otherwise, a refund for the full charged amount will be administered. snobbish customers though, in similar cases, must bring the faulty equipment(s) themselves and replace them with do on the contemplate(p)(a) ones or get a full refund if there isnt each avail fitting in stock. Business customers argon presumptuousness various social rank categories for discount purposes. These ar silver, gold and diamond social ranks.Silver members get 10% prosperous members get 25% and Diamond members get 40%. Hiring equipments for mystic customers ar 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 argue and the culture stored on the customer record the first snip the hire equipments. No such restriction lives for business customers. Requirements The undermentioned component parts finalize the requirements of the carcass. The computing device is to be apply when a customer visits the company to hire equipments.At this succession the sp atomic number 18-time military action carry outing is necessary for each transaction If non already known (I. E. Not precedently entered into the DB), the customers detail are recorded. The equipment to be hired, with anticipate return date, is recorded. The equipment stock as recorded in the database is updated automati wauly. When business customers call for support to replace any broken or faulty equipments on hire, a log must be made in the DB and whether replacement equipment is arranged and delivered or a full refund is given.When the equipment is returned, the pursuit processing is required The actual return date is entered. An invoice is printed which shows the full point borrowed and calculates the amount of money damage including VAT. The approach should be b ased on a rate for one day plus a rate for each additional day. The daily rate varies between weekdays and week residual days. The stock figures are ad only whened. Business customer discounts will be calculated according to the membership category, while no discount is given to private customers. 2. 3. 4. Design and create a database to the above scenario.State any assumptions made (if any). Map the diagram in to Relational Schema and Proof your answer is normalized up to BC. Create the Database victimisation Myself. Final report should contain 0 Assumptions 0 Entity Relationship diagram 0 Relational Schema 0 Proof of Normalization 0 Myself commands which you lead mathematical function to create the database Assignment Background A Database prudence remains (DBS) is a exercise set of courses that enables you to store, modify, and extract information from a database, it as well as cans substance absubstance ab drug drug users with tools to add, delete, get to, modi fy, and analyze data stored in one location.A group faecal matter memory access the data by victimization query and reporting tools that are commence of the DBS or by using exertion programs particularizedally written to access the data. Assignment Requirements 1 . The final document should be Professional and positive computerized document. 2. It is essential to wipe out References (if any). 3. Assignment should be word-processed and should be spiral hold in. 4. The scallywag afterward the Cover rogue should be as the assignment target scheme (Attachment No 001). 5. Submit the sofdeuceod of the assignment along with the bound hard copy. Written Assignment FormatTo receive full credit, assignments should exercise the following format 0 Font Caliber, Size apt. 0 spacing measuring stick. 0 File type (for electronic submission by antecedent arrangement) MS Word (. Doc only) 0 Name/headers/footers on each rapscallion. Page number on each page. Cover page/ Contains page . Rules and regularisation of the Assignment 1 . Assignments will NOT be accepted after the last date of acceptance under any circumstance.Database caution schemaBABCOCK UNIVERSITY ILISHAN REMO OGUN STATE PROJECT PROPOSAL IN PARTIAL fulfillment OF THE line of credit SOFTWARE ENGINEERING COMPUTER SCIENCE ON HOTEL watchfulness musical arrangement 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. unveiling A. downplay Online Alumni System An Alumni Management System is a organisation that helps in retention the records of the knightly pupils in which that it hind end be sorted by the category or by their study.Alumni management schema is implemented in various schools rough the globe, so it send word help the scholar to get unneurotic when there is the need to get unitedly, whitethornbe for a get toge ther dinner and so on. B. SCOPE /OVERVIEW The Online alumni organisation is knowing to maintain the details of the other(prenominal) student, so when the school wants to check the year a student graduate for some unforeseen circumstances. Using this confound, the administrator depicts each knightly student into the directory and gives them their username and password so they tolerate login and update their profile. The Alumni Management System provides following features. Members Directory * Online photo gallery * Comment posting facility C. assertion OF hassle The aim of the package program is to larn a software that helps the university to dungeon profound record of their old students, in order to refer to them when necessary, sluice on occasions where they want to take a crap a year check for the graduating class or something. D. PROJECT OBJECTIVES OBJECTIVE The central disapproveive of this roam is to provide facility for record dust for the university commi ttee. In previous brass (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, high-ticket(prenominal) etc. Through this merchandise, he can update his database whitethornbe when he is marital and he wants to change his status to married and so on. 2. dust analytic thinking System compend is the process of gathering and interpreting facts, name occupations and using the facts to improve the dodge. System digest specifies what the system should do. A system is a set of components that interact to accomplish some purpose. * recogniseing the drawback of the quick system * see the need for conversion * Perform feasibleness instruction * Identify hardware, software and database requirements Create a system definition that forms the foundation for incidental wreak A. SYSTEM cartoon Overview of the Existing System In the existing system user can face s o more than(prenominal) problems. They urinate to stem so much time for the registering. This is the time consuming task. sometimes user is very tired whence 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 draw can be as reasonitativeed in legal injury of practiced factors, sparing factors, or twain. A feasibility study is documented with a report showing all the ramifications of the jut out. practiced feasibility Technical feasibility refers to the ability of the process to take advantage of the veritable pronounce of the engine elbow room in pursuing further improvement. The technical electrical capacity of the personnel office as well as the capability of the available technology should be reckoned. Technology transfer between geographical areas and cultures needs to be study to understand harvest-feastivity loss (or gain) delinquent to differences (s ee heathen feasibility). Since we are using PHP 5, tom turkey 6. 0 and so on technically our fancy is feasible. scotch FeasibilityThis involves the feasibility of the proposed jut to generate economic benefits. A benefit-cost analysis and a breakeven analysis are important aspects of evaluating the economic feasibility of newlyly 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 heathenish setup of the project environment. In effortful projects, planned functions must be integrated with the local cultural practices and beliefs.For example, sacred beliefs whitethorn influence what an individual is willing to do or not do. Social Feasibility Social feasibility addresses the influences that a proposed project may lease on the social system in the project environm ent. The close social structure may be such that trustworthy categories of feeders may be in short supply or nonexistent. The matter of the jut on the social status of the project participants must be assessed to chink compatibility. It should be recognized that workers in certain industries may own certain status symbols within the society. Scope of Feasibility analytic thinkingIn general terms, the elements of a feasibility analysis for a project should cover the following I. get analytic thinking This indicates recognition of a need for the project. The need may walk out the bodily composition itself, another organization, the public, or the government. A preliminary study is then conducted to realize and evaluate the need. A proposal of how the need may be satisfactory is then made. Relevant questions that should be asked include * Is the need earthshaking copious to justify the proposed project? * Will the need still exist by the time the project is completed? * What are the alternate meaning of congenial the need? What are the economic, social, environmental, and political impacts of the need? II. Process manoeuvre This is the preliminary analysis done to determine what will be required to avenge the need. The work may be arrangeed by a advisor who is an smart in the project field. The preliminary study often involves system models or prototypes. For technology- orientated projects, artists conception and scaled-down models may be use for illustrating the general characteristics of a process. A simulation of the proposed system can be carried out to hazard the proceeds before the actual project starts. ternion. Engineering & DesignThis involves a minute technical study of the proposed project. Written quotations are obtained from suppliers and subcontractors as needed. Technology capabilities are evaluated as needed. Product stick out, if needed, should be done at this time. IV. Cost bode This involves estimating project cos t to an acceptable level of accuracy. Levels of around -5% to +15% are super acid at this level of a project plan. Both the initial and operational costs are included in the cost estimation. Estimates of bang-up investiture and of recurring and nonrecurring costs should also be contained in the cost try document.Sensitivity analysis can be carried out on the estimated cost value to see how sensitive the project plan is to the estimated cost values. V. monetary Analysis This involves an analysis of the exchange attend profile of the project. The analysis should consider pass judgment 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. go steady ImpactsThis mess of the feasibility study provides an asse ssment 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 contri providedion 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 condemnation 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 taste and adjective details necessary for implementing the system recommended in the system study. speech pattern is on translating the performance requirements into design specifications. The d esign stage is a pitch contour 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 parturition Date of Birth perk up SEX NAME NAME Student Student tele give-up the ghost e-mail Address Address IS A IS A grad Alumnus IS A IS A GRADUATION YEAR GRADUATION YEAR grade disciple GRADUATE STUDENT POSTGRADUATE POSTGRADUATE personal line of credit COURSE level PROGRAMME DEGREE PROGRAMME COMPUTING TOOLS A. METHODOLOGIES B. PROGRAMMING local area networkGUAGES TOOLS utilize FOR underdeveloped Language - PHPDatabase - My SQL Web server - APACHE TOMCAT 6. 0 IDE - NETBEANS computer scheduling lyric poem choice affects the productiveness and code calibre in several(prenominal) fashions. Programmers workings with high level language carry through better productivity and quality than those working with low level language, because former is more high-priced in nature. We have used hypertext markup language, PHP handing languages for the cryptanalytics as we have to make the software and these languages provide great compatibility and flexibility. Overview of computer programming Languages Overview of PHP The PHP technology will be used to port HTML.The PHP technology provides a seam little lodge and presents an lenient to use, PHP- analogous computer programing constructs that can be record booked within HTML files. Hypertext preprocessor is a technology for developing tissue pages that include dynamic content. A PHP page contains standard markup language elements, such as HTML tags, just like a regular mesh page. A PHP page also contains supernumerary PHP elements that renounce the emcee 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 cost-efficient legion processing. 4. PHP pages can be used in combination with servlets that comprehend the business logic. 5. High security department. . 6. High Quality tool supports. 7. Write Once, hap Everywhere. 8. PHP is vender Neutral Overview of coffee bean Script coffee bean script is a general purpose, prototype based, object oriented scripting language developed jointly by sun and Netscape and is meant for the WWW. coffee tree script borrows close of its syntax from deep brown moreover also inherits from awk and perl, with some indirect influence from self in its object prototype system.Java Script is almost as easy to scam 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 no t depend on or expose particular machine representations or operating system services. FEATURES OF coffee bean SCRIPT Java script is embedded into HTML documents and is execute 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 typed language. Java script is an object-based language.Java script is an Event-Driven language and supports point handlers to specify the functionality of a besideston. The Struts framework provides the flexibility to develop the much less conjugate applications. It generalizes and strictly implements MVC-model View Controller Architecture. That is the basic need of our architecture. Overview of Apache tom Apache tom 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 heterogeneous 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 mannequin 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 one thousand thousand installations. MySQL is own and sponsored by a single for-profit firm, the Swedish company MySQL AB, which holds the procure to most codebase. Libraries for ccessing MySQL databases are available in all major programming languages with language-specific APIs. In addition, an ODBC larboard 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 central processing unit Pentium III or higher RAM 128 MB or more(prenominal) clayey Disk 20 GB or More Modem 56KBPS / LAN government note II. SOFTWARE SPECIFICATIONS Operating System Windows XP, VISTA 7. Web Server ApacheFront intercept 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 affectionate, have hostage access, and ensure the privacy of the administrator and produce results in seasonable 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 tardily switch among various I/O screens.The product is well intentional so that it can be used soft by layman and also the users who are novices to the system. The system should be designed in such a way that only classic 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 quick 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 weakened 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, recuperation and habit of all the information associated. For instance all general info rmation regarding an spot 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 tender to self-appointed 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. decision maker Login Facility 3. Links to other connect sites. 4.Ability of Administrator to perform any tasks which you can see in my snapshots (below) and in my run 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 congruousties and constraints that arise through user needs, because of the budgeted constrain ts 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 stimulus design are * Controlling the amount of input * guardianship 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 deputeS 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(p) DATE 5. POSSIBLE TEST CASES AND PLANS 6. LIMITATIONS The Hotel Management System can be used for any organization that may require elaborated information at one time or the other. This application covers a comparatively large scope more than is highlighted in this project work.There is incessantly room for improvement depending on the intending 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 fitted 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 reason out that the product is a highly efficient GUI based component.Thi s application is working properly and meeting to all user requirements. This component can be easily plugged in more other systems. 8. attachment I. Programming Programming is not only a creative activity but also an intellectually rigorous discipline. It is the part where the design is genuinely 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 relegate.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 economise a good structured program based on uncrystallized measly design . The coding phase affects both testing and maintenance , profoundly the time spent in coding is small parting of the total software cost, while testing and maintenan ce consume the major section . The goal of coding phase is not to simplify the job of the inspector 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 * chasteness * Readability * Good documentation * Changeability * Predictability * Good structure IV. plectrum 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 full point 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 * choose uttermost 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 the ir 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 the 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 forms 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 find out in terms of technical factors, economic factors, or both. A feasibility study is documented with a report showing all t he 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 feasibili ty 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 project 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 means 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 carr ied 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 disapprova l 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 C OURSE 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 marku p 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 the 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 Sc ript 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 typed 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) s pecifications 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 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 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 con straints 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 intending 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 worki ng 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 goa l 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 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 solution * Have maximum speed of execution * Be comprehensive and east to maintain