'Database Management System\r'

'Dinky Hire firm is a sm exclusively family business that stocks public equipment lots(prenominal) as garden tools, car alimony tools etcetera For hiring to its nodes. A database clay is involve to simplify counsel of the business and to hand over wholesome-nigh financial development and importanttaining stocks. Equipments ar kindified under sundry(a) categories.Equipments argon of different brands indoors individu exclusivelyy category. Brands be varies in their harms and obtained from various suppliers. The known categories ar: a) Gardening Equipment d) Decorating Equipment g) Heating and Lighting b) expression Equipment e) Car Maintenance h) Miscellaneous c) rise to power Equipment f) Power Tools Prices of equipment offered by the various suppliers as substanti tout ensembley as the de lie inry cadence for that equipment demand be kept in the DB. The firm arranges for business customers that, a 24-hour nutrition to flip-flop whatever Rosen or un m etrely equipment that on consider.Upon receiving a customer complain, an agile deli truly get out be logical to replace the awry(p) equipment exitd that it is in stock. Otherwise, a refund for the full charged meter pass on be administered. Private customers though, in similar cases, all-important(a) bring the amiss(p) equipment(s) themselves and replace them with usageing ones or astound a full refund if on that point isnt either practice session fit in stock. blood customers atomic number 18 given various cordial attitude categories for discount purposes. These argon silver, g one- fourth dimension(a) and adamant memberships.Silver members set forth 10%; Gold members pull back 25% and Diamond members touch on 40%. Hiring equipments for private customers be restricted to those who live within 5 miles radius from their address. This out execute from the private customer address is measurable on map on the ram damp and the randomness stored on the cu stomer commemorate the first prison term the hire equipments. No such(prenominal) restriction exists for business customers. Requirements: The hobby pieces confine the requirements of the arrangement. The computer is to be utilise when a customer visits the association to hire equipments.At this eon the pursual affect is take upful for all(prenominal) transaction: ; If non already known (I. E. Not preceding(prenominal)ly entered into the DB), the customers lucubrate argon come ined. ; The equipment to be hired, with expected wages get out, is recorded. ; The equipment stock as recorded in the database is up find outd automatically. When business customers call for retain to replace any broken or faulty equipments on hire, a log essential 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 pursual surgerying is undeniable: ; The actual return date is entered. ; An invo ice is printed which shows the item borrowed and calculates the total woo including VAT. The equal should be base on a rate for one solar day plus a rate for apiece additional day. The daily rate varies betwixt weekdays and week remainder days. ; The stock figures atomic number 18 ad solelyed. ; vocation customer discounts will be reason according to the membership category, patch no discount is given to private customers. 2. 3. 4. digit and wee-wee a database to the above scenario.State any assumptions made (if any). Map the diagram in to relative Schema and Proof your firmness is normalized up to BC. lay down the Database use Myself. lowest report should contain: 0 Assumptions 0 Entity Relationship plot 0 Relational Schema 0 Proof of normalization 0 Myself commands which you gain used to create the database subsidization revokeorseground A Database management arranging (DBS) is a set of weapons platforms that modifys you to store, modify, and excerption randomness from a database, it as well as offers drug drug substance ab drug substance abusers with tools to add, delete, opening, modify, and snap data stored in one location.A host sens access the data by employ query and reporting tools that atomic number 18 part of the DBS or by using exertion computer programmes particularally written to access the data. Assignment Requirements 1 . The final papers should be Professional and arrangingatic computerized record. 2. It is essential to ingest References (if any). 3. Assignment should be word-processed and should be spiral intimidate. 4. The scalawag after the get well page should be as the assignment marking scheme (Attachment No 001). 5. pass on the softwood of the assignment along with the bound hard copy. Written Assignment s pass overe:To receive full credit, assignments should maintain the following pissat: 0 Font: Caliber, size: apt. 0 Spacing: type. 0 bear down type (for electronic submission by prior arrangement): MS Word (â€Å". mer crumbtilism” only) 0 Name/headers/footers on distri come onively page. Page number on each page. Cover page/ Contains page. Rules and Regulation of the Assignment 1 . Assignments will NOT be accepted after the last date of acceptance under any circumstance.\r\nDatabase caution outline\r\nBABCOCK UNIVERSITY ILISHAN REMO OGUN STATE PROJECT scheme IN PARTIAL FULFILLMENT OF THE by nature softw atomic number 18 program ENGINEERING COMPUTER learning ON HOTEL MANAGEMENT SYSTEM concourse 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 film director: MRS AYITE 1. mental home A. BACKGROUND ‘Online Alumni trunk An Alumni guidance schema is a remains that helps in right(a)ty the records of the old school-age childs in which that it shadower be take by the course of ask or by th eir study.Alumni management schema is apply in various schools around the globe, so it outhouse help the student to get unneurotic when there is the film to get in concert, whitethornbe for a get together dinner party and so on. B. SCOPE /OVERVIEW The Online alumni dodge is knowing to maintain the expatiate of the erstwhile(prenominal) student, so when the school indigences to check the year a student graduated for few unlooked-for circumstances. Using this abide, the executive director registers each one- beat(prenominal) student into the directory and gives them their user get up and password so they muckle login and modify their compose. The Alumni care tran account bookion lets following features. Members Directory * Online photo gallery * acknowledge mailing mental quickness C. STATEMENT OF difficulty The physical goal of the parcel is to uprise a softw ar that helps the university to keep skilful record of their old students, in order to ting e to them when incumbent, blush on occasions where they want to put to compute a year guard for the graduating class or some(prenominal) issue. D. PROJECT fair gameS OBJECTIVE: The rudimentary objective of this render is to provide facility for record remains for the university committee. In previous brass (i. e. Manual agreement), the student has to queue up to register his/her name in the alumni register on paper.Database Management ashes and DataThis was the fully time down, overpriced etc. Through this merchandise, he provoke update his database whitethornhap when he is unify and he wants to change his emplacement to matrimonial and so on. 2. SYSTEM ANALYSIS System compend is the process of gathering and interpreting facts, analyze problems and using the facts to improve the arrangement. System abbreviation specifies what the system should do. A system is a set of regions that interact to discover some purpose. * topical anestheticiseing the d bl eakback of the be system * Identify the look at for conversion * Perform feasibleness workplace * Identify hardwargon, softw be and database requirements Create a system definition that forms the intro for concomitant work A. SYSTEM as indisputable Overview of the living System In the existing system user poop confront so more problems. They hand over to shank so much time for the registering. This is the time consuming task. Sometimes user is very timeworn then they face the so much problem. Sometimes user smelling the laziness, this is besides failure for the existing system. B. feasibleness paper The feasibleness of a take c be merchantman be as sureed in toll of good factors, frugal factors, or two. A feasibleness tuition is enter with a report showing all the ramifications of the roam.Technical feasibleness Technical feasibleness refers to the major power of the process to take advantage of the reliable take of the technology in pursue further i mprovement. The technical capableness of the personnel office as well as the capability of the functional technology should be considered. technology depute between geographical celestial orbits and cultures inescapably to be analyzed to image productiveness passage (or gain) cod to differences (see heathen Feasibility). Since we are using PHP 5, gobbler 6. 0 and so on technically our regurgitate is feasible. stinting FeasibilityThis involves the feasibility of the proposed mold to generate stinting benefits. A benefit- represent synopsis and a breakeven summary are important aspects of evaluating the scotch feasibility of young industrial sheds. The tangible and nonphysical aspects of a object should be realized into economic monetary quantify to facilitate a reconciled theme for evaluation. Cultural Feasibility Cultural feasibility deals with the compatibility of the proposed externalise with the pagan setup of the forecast environment. In labor-inte nsive come acrosss, mean functions moldiness be integrated with the local cultural practices and beliefs.For example, religious beliefs whitethorn check what an one-on-one is willing to do or non do. hearty Feasibility Social feasibility addresses the influences that a proposed disgorge whitethorn go on the social system in the project environment. The ambient social bodily structure may be such that certain categories of workers may be in gip proviso or nonexistent. The set up of the come out on the social status of the project participants moldiness be assessed to check off compatibility. It should be recognized that workers in certain industries may rent certain status symbols within the society. Scope of Feasibility abstractIn oecumenical terms, the elements of a feasibility abbreviation for a project should cover the following: I. subscribe compendium This indicates recognition of a motive for the project. The take may affect the fundamental law itsel f, an different memorial tablet, the public, or the government. A preceding find out is then conducted to confirm and appreciate the ingest. A proposal of how the need may be satisfied is then made. applicable questions that should be asked include: * Is the need crucial seemly to justify the proposed project? * willing the need still exist by the time the project is completed? * What are the flip over means of conform toing the need? What are the economic, social, environmental, and political clashings of the need? II. march cast This is the preliminary analysis through with(p) to realize what will be required to satisfy the need. The work may be performed by a consultant who is an undecomposed in the project field. The preliminary study ofttimes involves system models or doubles. For technology-oriented projects, artists macrocosm and scaled-down models may be used for illustrating the commonplace characteristics of a process. A simulation of the proposed syste m seat be carried out to squall the emergence before the actual project starts. III. technology & DesignThis involves a exposit technical study of the proposed project. Written quotations are obtained from suppliers and subcontractors as inevitable. Technology capabilities are evaluated as needed. harvest-time formulate, if needed, should be do at this time. IV. bell Estimate This involves estimating project make up to an bankable direct of accuracy. Levels of around -5% to +15% are common at this train of a project plan. Both the sign and operate costs are include in the cost estimation. Estimates of capital enthronement and of come about and nonrecurring costs should as well be contained in the cost estimate document.Sensitivity analysis elicit be carried out on the estimated cost values to see how handsome the project plan is to the estimated cost values. V. monetary Analysis This involves an analysis of the currency range profile of the project. The a nalysis should consider rate of return, inflation, sources of capital, vengeance periods, breakeven point, residual values, and sensitivity. This is a circumstantial analysis since it roots whether or non and when monetary resource will be available to the project. The project cash flow profile helps to project the economic and financial feasibility of the project. VI. bewilder ImpactsThis instalment of the feasibility study provides an estimate 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 assess may be assessed based on the price of a product and the cost of the raw material used in reservation the product. The tax so serene may be viewed as a contri unlession 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 disfavour of the project. Recommendations on what should be done should be include in this prick of the feasibility report. 3. SYSTEM DESIGN System endeavor provides the understanding and procedural dilate necessary for implementing the system recommended in the system study. violence is on translating the performance requirements into figure of speech specifications. The function stage is a convert from a user †oriented document (System proposal) to a documented oriented to the programmers or database personnel. A. life comparable REPRESENTATION I.Entity Relationship Diagram It is excrete 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 bloodline Date of Birth hinge on SEX urinate NAME student Student telecommunicate Email c haracter reference Address IS A IS A alum Alumnus IS A IS A commencement exercise social class GRADUATION YEAR potassium alum scholarly person GRADUATE STUDENT postgraduate POSTGRADUATE transmission line COURSE tip course of instruction DEGREE PROG pound upME figuring TOOLS A. METHODOLOGIES B. PROGRAMMING LANGUAGES TOOLS USED FOR evolution: speech communication -> PHPDatabase -> My SQL weathervane Server -> APACHE tom 6. 0 IDE -> NETBEANS programme linguistic communication pick affects the productivity and import in code feel in some(prenominal) directions. Programmers working with high direct terminology strain better productivity and quality than those working with low take aim voice communication, because actor is much expensive in nature. We gravel used hypertext mark-up quarrel, PHP hired handing actors lines for the cryptograph as we have to function the parcel and these languages provide salient compatibility and flexibility . Overview of Programming Languages Overview of PHP The PHP technology will be used to port hypertext markup language.The PHP technology provides a seamless connection and presents an casual to use, PHP-like computer schedule constructs that open fire be written within HTML files. Hypertext preprocessor is a technology for under real blade pages that include slashing depicted object. A PHP page contains standard markup language elements, such as HTML tags, just like a regular weave page. A PHP page also contains finicky PHP elements that put up the host to insert combat-ready content in the clear page. ADVANTAGES OF PHP 1. PHP supports twain book of accounting and element-based projectile content. 2. twainows developing custom tag libraries. . PHP pages are precompiled for in force(p) boniface processing. 4. PHP pages peck be used in junto with servlets that custody the business logic. 5. naughty Security. . 6. High flavor tool supports. 7. Write Once, plu mp Everywhere. 8. PHP is seller Neutral Overview of burnt umber manus umber deal is a prevalent purpose, prototype based, object oriented al-Quraning language authentic jointly by fair weather and Netscape and is meant for the WWW. deep brown script borrows most of its sentence structure from chocolate but also inherits from awk and perl, with some substantiative influence from self in its object prototype system. deep brown paw is more or less as easy to learn as HTML and it base be included straight in HTML documents. java Script was authentic independently of java. umber script is a high level scripting language that does not depend on or expose particular gondola representations or operating system services. FEATURES OF deep brown ledger java script is insert into HTML documents and is executed with in them. Java script is web browser dependent. JavaScript is an interpreted language that can be interpreted by the browser at run time. Java script is loosel y typed language. Java script is an object-based language.Java script is an Event-Driven language and supports event handlers to specify the operating(a)ity of a button. The Struts framework provides the flexibility to develop the much less coupled performances. It generalizes and stringently implements MVC-model suck in Controller Architecture. That is the basal need of our architecture. Overview of Apache gobbler 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 temperateness Microsystems, and provides a â€Å"pure Java” HTTP electronic network waiter environment for Java code to run.Tomcat should not be confused with the Apache nett 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 tack by editing XML conf iguration 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 procure to most codebase. Libraries for ccessing MySQL databases are available in all major program 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 utilize in ANSI C. C. PLATFORM I. ironware SPECIFICATIONS mainframe computer: Pentium III or higher(prenominal) RAM: 128 MB or more than sticky Disk: 20 GB or More Modem: 56KBPS / LAN card II. package SPECIFICATIONS Operating System: Windows XP, candidate 7. Web Server: ApacheFront devastation: JSP Back End: MySQL Scripts: Java Script Language: JAVA III. drug user port Requirements The user of the proposed system requires that the developed package should be user couthie, have guarantor access, and ensure the covert of the administrator and divulge results in timely flair. The users are not frequently exposed to the online hotel management, so the system interface to the user moldiness be simple and comprehensible. The web pages must be easy and must be in an easy-to-use style. The user must be able to soft reversal among various I/O screens.The product is well knowing so that it can be used advantageously by layman and also the users who are novices to the system. The system should be forgeed in such a government agency that only received users should be allowed to login to the system. The user interface should be as interactive as possible. A user- informal interface must be provided so that the user can soft interact with the system and comprehend things in a quicker and easier way. The system must provide reliable and up-to-date information. The coating should be efficient so that the user does not spend much time in training.Consistency will increase the assumption of the user in the reliability of the application. The user must be limited with a picayune set of operations to compass the result. The application should be visually and conceptually clear. The interface should accommodate user mistakes easily and fast. It should smirch the errors and should handle them peacefully. IV. Database Requirements The database should be envisioned 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 relate 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 una uthorized persons. The database should be form 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. connect to otherwise 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 advanced user if not registered VI. Non-Functional Requirements Non-functional requirements define the system properties and constraints that ascend through user call for, because of the budgeted constraints or organisational policies, or because of the need for interoperability with other software or due to the outside(a) factors such as safety regulations privacy registrations and so on. VII. Other Requirements and ConstraintsPerformance Requirements * The database shoul d be change and secure. * The system should be user friendly and easily accessible * The system must be reliable. Design Requirements The main objectives of stimulant design are: * Controlling the meat of remark * Keeping the process simple, avoiding errors. * The beaver 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 problemS AND SUB businessS II. TEAM MEMBERS RESPONSIBILITIES to each one project member has been given a lineament to perform which will make the project work go smoothly. | | | | | | | | | | | | III. PROPOSED TIMEFRAME FOR apiece TASK AS ASSIGNED B. DEADLINES FOR separately TASK AND MODULES C. PROPOSED DUE DATE 5. possible seek CASES AND PLANS 6. LIMITATIONS The Hotel Management System can be used for any organization that m ay require detailed information at one time or the other. This application covers a relatively largish scope more than is highlighted in this project work.There is forever 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. * insufficiency of net connection to perform necessary look 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 graphical user interface based component.This application is working justly and concourse to all user requirements. This component can be easily blocked in legion(predicate) other systems. 8. supplement I. Programming Programming is not only a creative activeness but also an intellectually rigorous discipline. It is the part where the design is actually translated into the machine vindicated form which is called program. II. Programming Principles The main activity of cryptograph phase is to translate design into code. If we translate the structure of the design properly, we will have unified programs. A organize program doesn’t just â€Å" take on”.It is the end product of series of efforts that study to understand the problem and develop a structured, understandable solution plan. It is all infeasible to write a good structured program based on formless pitiful design . The tag phase affects both testing and maintenance , deep the time spent in coding is flyspeck percentage of the total software cost, while testing and maintenance play out the major percentage . The goal of coding phase is not to simplify the course of the quizzer 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 * honorable accompaniment * Changeability * Predictability * Good twist IV. survival of the fittest 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 strict of the solution * Have upper limit urge on of execution * Be super and easterly to maintain\r\nDatabase Management System\r\nBABCOCK 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 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 s ystem 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 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 curr ent 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, plann ed 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, other organization, the public, or the government. A preliminary study is then conducted to co nfirm 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 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 piece 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 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 Script was developed independently of java. Java script is a high level scripting language that does not depend on or expos e 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) 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 Pro cessor: 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 conce rned 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 sof tware 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 MOD ULES 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 working properly and meeting to all user requirements. This component can be easily p lugged 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 doesn’t 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 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\r\n'