A Report On A Software

Course code: IP401

Course Name : Internship Program III

A REPORT ON

“HOTEL MANAGEMENT SYSTEM”

BY RAJEEV KR. CHATURVEDI (05JPCS018)

1

The ICFAI Institute of Science and Technology (Jaipur) A Report On

Hotel Management System By Rajeev Kr. Chaturvedi ID No. 05JPCS018 Approved by: Dr. O.P. Daga The Dean, ICFAI Tech, Jaipur Evaluated by: Mr. Arun Kumar Saini Instructor-In-charge

A report submitted in partial fulfillment of course requirement IP 401 (Internship Program III)

The ICFAI Institute of Science & Technology Jaipur February 19, 2009 2

3

ACKNOWLEDGEMENT

I would like to express my deep sense of gratitude to Dr. O.P. Daga, the Dean, ICFAI Tech, Jaipur for providing me an opportunity to Internship Program III as per the course requirements. Words indeed are inadequate to express my deep sense of gratitude to Mr. Arun Kumar Saini for providing guidance at every stage of our work. It is a great privilege to have an opportunity to work and learn a lot under his guidance.

4

The ICFAI Institute of Science and Technology

Date of Submission: - February 19, 2009 Title of the project: - HOTEL MANAGEMENT SYSTEM

Name of Student Rajeev Kr. Chaturvedi

Faculty In-charge: -

Keyword: -

ID. No. 05JPCS018

Discipline CSE

Mr. Arun Kumar Saini

HOTEL MANAGEMENT SYSTEM

Abstract: This project deals with the development of a system called ‘Hotel Management System’ to be developed in Visual Basic programming language. To start with, this system indulges in the task of managing the the general tasks of a hotel like room management, staf in the hotel, guset check-ins etc.

Signatures of Student Date:

Signature of faculty Date:

Introduction 5

Today computer have become an indispensable part of our lives, and when it is ushered into the fields of hospitality management a new and promising path is open to us. Visual BAsic lets us write our programs clearly and simply it has decent control flow facilities so our code can be read straight down the page, it lets us write code that is compact without being too cryptic; it encourages modularity and good program organization; and it provides good data-structuring facilities. The need to develop this system has found its importance, realizing today’s advancement in technology. It is apparent that today’s fast paced life is totally dependent on automated working feature. By using this type of software the Hotel management can keep records of all the functions and events. This user friendly program delivers a direct interface with users. So in this project, an effort is being made to develop a system which would provide a mean to make the Hotel Management very easy without facing any difficulties.

6

Table of Contents Topics

Page Nos.

ACKNOWLEDGEMENT Abstract Introduction

I II III

1. The Language Used 1.1 Visual Basic 1.2 Evolution of Visual Basic 1.3 Timeline of Visual Basic (VB1 to VB6) 1.4 Language features 1.5 Characteristics present in Visual Basic 1.6 Derivative languages 1.7 Performance and other issues 1.8 Other criticisms levelled at Visual Basic

7 7 8 8 10 12 13 13 14

2. The Back End 2.1 MySQL 2.2 Uses 2.3 Platforms and interfaces 2.4 History 2.5 Features

15 15 16 16 17 17

3. About the Project 3.1 Introduction 3.2 Minimum System Requirments

18 18 18

4. Snaps of Main Project

19

5. References

27

7

1. The Language Used 1.1 Visual Basic: Visual Basic (VB) is the third-generation event-driven programming language and integrated development environment (IDE) from Microsoft for its COM programming model. VB is also considered a relatively easy to learn and use programming language, because of its graphical development features and BASIC heritage. Visual Basic was derived from BASIC and enables the rapid application development (RAD) of graphical user interface (GUI) applications, access to databases using Data Access Objects DAO, Remote Data Objects RDO, or ActiveX Data Objects ADO, and creation of ActiveX controls and objects. Scripting languages such as VBA and VBScript are syntactically similar to Visual Basic, but perform differently. A programmer can put together an application using the components provided with Visual Basic itself. Programs written in Visual Basic can also use the Windows API, but doing so requires external function declarations. The final release was version 6 in 1998. Microsoft's extended support ended in March 2008 and the designated successor was Visual Basic .NET (now known simply as Visual Basic).

8

1.2 Evolution of Visual Basic: VB 1.0 was introduced in 1991. The drag and drop design for creating the user interface is derived from a prototype form generator developed by Alan Cooper and his company called Tripod. Microsoft contracted with Cooper and his associates to develop Tripod into a programmable form system for Windows 3.0, under the code name Ruby (no relation to the Ruby programming language). Tripod did not include a programming language at all. Microsoft decided to combine Ruby with the Basic language to create Visual Basic. The Ruby interface generator provided the "visual" part of Visual Basic and this was combined with the "EB" Embedded BASIC engine designed for Microsoft's abandoned "Omega" database system. Ruby also provided the ability to load dynamic link libraries containing additional controls (then called "gizmos"), which later became the VBX interface.

1.3 Timeline of Visual Basic (VB1 to VB6): • •

Project 'Thunder' was initiated Visual Basic 1.0 (May 1991) was released for Windows at the Comdex/Windows World trade show in Atlanta, Georgia.

Visual Basic for MS-DOS •

Visual Basic 1.0 for DOS was released in September 1992. The language itself was not quite compatible with Visual Basic for Windows, as it was actually the next version of Microsoft's DOS-based BASIC compilers, QuickBASIC and BASIC Professional Development System. The interface used the "COW" (Character Oriented Windows) interface, using extended ASCII characters to simulate the appearance of a GUI.

9

•

•

•

•

•

•

Visual Basic 2.0 was released in November 1992. The programming environment was easier to use, and its speed was improved. Notably, forms became instantiable objects, thus laying the foundational concepts of class modules as were later offered in VB4. Visual Basic 3.0 was released in the summer of 1993 and came in Standard and Professional versions. VB3 included version 1.1 of the Microsoft Jet Database Engine that could read and write Jet (or Access) 1.x databases. Visual Basic 4.0 (August 1995) was the first version that could create 32-bit as well as 16-bit Windows programs. It also introduced the ability to write non-GUI classes in Visual Basic. Incompatibilities between different releases of VB4 caused installation and operation problems. While previous versions of Visual Basic had used VBX controls, Visual Basic now used OLE controls (with files names ending in .OCX) instead. These were later to be named ActiveX controls. With version 5.0 (February 1997), Microsoft released Visual Basic exclusively for 32-bit versions of Windows. Programmers who preferred to write 16-bit programs were able to import programs written in Visual Basic 4.0 to Visual Basic 5.0, and Visual Basic 5.0 programs can easily be converted with Visual Basic 4.0. Visual Basic 5.0 also introduced the ability to create custom user controls, as well as the ability to compile to native Windows executable code, speeding up calculationintensive code execution. A free, downloadable Control Creation Edition was also released for creation of ActiveX controls. It was also used as an introductory form of Visual Basic: a regular .exe project could be created and run in the IDE, but not compiled. Visual Basic 6.0 (Mid 1998) improved in a number of areas including the ability to create web-based applications. VB6 has entered Microsoft's "non-supported phase" as of March 2008. Mainstream Support for Microsoft Visual Basic 6.0 ended on March 31, 2005. Extended support ended in March 2008. In response, the Visual Basic user community expressed its grave concern and lobbied users to sign a petition to keep the product alive. Microsoft has so far refused to change their position on the matter. Ironically, around this time (2005), it was exposed that Microsoft's new anti-spyware offering, Microsoft AntiSpyware (part of the GIANT Company Software purchase), was coded in Visual Basic 6.0. Its replacement, Windows Defender, was rewritten as C++ code.

10

1.4 Language features: Like the BASIC programming language, Visual Basic was designed to be easy to learn and use. The language not only allows programmers to create simple GUI applications, but can also develop complex applications. Programming in VB is a combination of visually arranging components or controls on a form, specifying attributes and actions of those components, and writing additional lines of code for more functionality. Since default attributes and actions are defined for the components, a simple program can be created without the programmer having to write many lines of code. Performance problems were experienced by earlier versions, but with faster computers and native code compilation this has become less of an issue. Although programs can be compiled into native code executables from version 5 onwards, they still require the presence of runtime libraries of approximately 1 MB in size. This runtime is included by default in Windows 2000 and later, but for earlier versions of Windows like 95/98/NT it must be distributed together with the executable. Forms are created using drag-and-drop techniques. A tool is used to place controls (e.g., text boxes, buttons, etc.) on the form (window). Controls have attributes and event handlers associated with them. Default values are provided when the control is created, but may be changed by the programmer. Many attribute values can be modified during run time based on user actions or changes in the environment, providing a dynamic application. For example, code can be inserted into the form resize event handler to reposition a control so that it remains centered on the form, expands to fill up the form, etc. By inserting code into the event handler for a keypress in a text box, the program can automatically translate the case of the text being entered, or even prevent certain characters from being inserted. Visual Basic can create executables (EXE files), ActiveX controls, DLL files, but is primarily used to develop Windows applications and to interface web database systems. Dialog boxes with less functionality can be used to provide pop-up capabilities. Controls provide the basic functionality of the application, while programmers can insert additional logic within the appropriate event handlers. For example, a drop-down combination box will automatically display its list and allow the user to select any element. An event handler is called when an item is selected, which can then execute additional code created by the programmer to perform some action based on which element was selected, such as populating a related list. Alternatively, a Visual Basic component can have no user interface, and instead provide ActiveX objects to other programs via Component Object Model (COM). This allows for server-side processing or an add-in module. The language is garbage collected using reference counting, has a large library of utility objects, and has basic object oriented support. Since the more common components are included in the default project template, the programmer seldom needs to specify 11

additional libraries. Unlike many other programming languages, Visual Basic is generally not case sensitive, although it will transform keywords into a standard case configuration and force the case of variable names to conform to the case of the entry within the symbol table entry. String comparisons are case sensitive by default, but can be made case insensitive if so desired. The Visual Basic compiler is shared with other Visual Studio languages (C, C++), but restrictions in the IDE do not allow the creation of some targets (Windows model DLL's) and threading models.

12

1.5 Characteristics present in Visual Basic: Visual Basic has the following traits which differ from C-derived languages: •

•

•

• • •

•

Boolean constant True has numeric value −1. This is because the Boolean data type is stored as a 16-bit signed integer. In this construct −1 evaluates to 16 binary 1s (the Boolean value True), and 0 as 16 0s (the Boolean value False). This is apparent when performing a Not operation on a 16 bit signed integer value 0 which will return the integer value −1, in other words True = Not False. This inherent functionality becomes especially useful when performing logical operations on the individual bits of an integer such as And, Or, Xor and Not. This definition of True is also consistent with BASIC since the early 1970s Microsoft BASIC implementation and is also related to the characteristics of CPU instructions at the time. Logical and bitwise operators are unified. This is unlike some C-derived languages (such as Perl), which have separate logical and bitwise operators. This again is a traditional feature of BASIC. Variable array base. Arrays are declared by specifying the upper and lower bounds in a way similar to Pascal and Fortran. It is also possible to use the Option Base statement to set the default lower bound. Use of the Option Base statement can lead to confusion when reading Visual Basic code and is best avoided by always explicitly specifying the lower bound of the array. This lower bound is not limited to 0 or 1, because it can also be set by declaration. In this way, both the lower and upper bounds are programmable. In more subscript-limited languages, the lower bound of the array is not variable. This uncommon trait does exist in Visual Basic .NET but not in VBScript. Relatively strong integration with the Windows operating system and the Component Object Model. Banker's rounding as the default behavior when converting real numbers to integers with the Round function. Integers are automatically promoted to reals in expressions involving the normal division operator (/) so that division of an odd integer by an even integer produces the intuitively correct result. There is a specific integer divide operator (\) which does truncate. By default, if a variable has not been declared or if no type declaration character is specified, the variable is of type Variant. However this can be changed with Deftype statements such as DefInt, DefBool, DefVar, DefObj, DefStr. There are 12 Deftype statements in total offered by Visual Basic 6.0. The default type may be overridden for a specific declaration by using a special suffix character on the variable name (# for Double, ! for Single, & for Long, % for Integer, $ for String, and @ for Currency) or using the key phrase As (type). VB can also be set in a mode that only explicitly declared variables can be used with the command Option Explicit.

13

1.6 Derivative languages: Microsoft has developed derivatives of Visual Basic for use in scripting. Visual Basic itself is derived heavily from BASIC, and subsequently has been replaced with a .NET platform version.

Some of the derived languages are: •

•

•

• •

•

Visual Basic for Applications (VBA) is included in many Microsoft applications (Microsoft Office), and also in many third-party products like SolidWorks, AutoCAD, WordPerfect Office 2002, ArcGIS and Sage Accpac ERP. There are small inconsistencies in the way VBA is implemented in different applications, but it is largely the same language as VB6 and uses the same runtime library. VBScript is the default language for Active Server Pages. It can be used in Windows scripting and client-side web page scripting. Although it resembles VB in syntax, it is a separate language and it is executed by vbscript.dll as opposed to the VB runtime. ASP and VBScript should not be confused with ASP.NET which uses the .NET Framework for compiled web pages. Visual Basic .NET is Microsoft's designated successor to Visual Basic 6.0, and is part of Microsoft's .NET platform. Visual Basic.Net compiles and runs using the .NET Framework. It is not backwards compatible with VB6. An automated conversion tool exists, but for most projects automated conversion is impossible. Star Basic is a Visual Basic compatible interpreter included in StarOffice suite, developed by Sun Microsystems. Gambas is a Visual Basic inspired free software programming language for GNU/Linux. It is not a clone of Visual Basic, but it does have the ability to convert Visual Basic programs to Gambas. KBasic is a Visual Basic inspired free software programming language for Linux, Mac and Windows. It is not a clone of Visual Basic, but it does have the ability to convert Visual Basic programs to KBasic.

1.7 Performance and other issues: Earlier counterparts of Visual Basic (prior to version 5) compiled the code to P-Code or Pseudo code only. Visual Basic 5 and 6 are able to compile the code to either native or PCode as the programmer chooses. The P-Code is interpreted by the language runtime, also known as virtual machine, implemented for benefits such as portability and small code. However, it usually slows down the execution by adding an additional layer of interpretation of code by the runtime although small amounts of code and algorithms can be constructed to run faster than the compiled native code. Visual Basic applications require Microsoft Visual Basic runtime MSVBVMxx.DLL, where xx is the relevant version number, either 50 or 60. MSVBVM60.dll comes as standard with Windows in all editions after Windows 98 while MSVBVM50.dll comes with all editions after Windows 95. A Windows 95 machine would however require inclusion with the installer of whichever dll was needed by the program. 14

1.8 Other criticisms levelled at Visual Basic editions prior to VB.NET include: • • • • • • •

Versioning problems associated with various runtime DLL's Poor support for object-oriented programming Inability to create multi-threaded applications, without resorting to Windows API calls Lack of unicode support Inability to create Windows services Inability to create console applications Variant types have a greater performance and storage overhead than stronglytyped programming languages

15

2. The Back End 2.1 MySQL: MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout its history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates the major problems associated with downtime, maintenance and administration for modern, online applications. Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume Web sites, critical business systems, and packaged software — including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, Wikipedia, and Booking.com. MySQL is a key part of LAMP (Linux, Apache, MySQL, PHP / Perl / Python), the fastgrowing open source enterprise software stack. More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost and freedom from platform lock-in. The MySQL database is owned, developed and supported by Sun Microsystems, one of the world's largest contributors to open source software. MySQL was originally founded and developed in Sweden. MySQL is a relational database management system (RDBMS) which has more than 11 million installations. The program runs as a server providing multi-user access to a number of databases. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems, which holds the copyright to most of the codebase. The project's source code is available under terms of the GNU General Public License, as well as under a variety of proprietary agreements.

16

2.2 Uses: MySQL is popular for web applications and acts as the database component of the LAMP, BAMP, MAMP, SAMP, and WAMP platforms, and for open-source bug tracking tools like Bugzilla. Its popularity for use with web applications is closely tied to the popularity of PHP, which is often combined with MySQL. Several high-traffic web sites (including Flickr, Facebook, Wikipedia, Google, Nokia and YouTube) use MySQL for its data storage and logging of user data.

2.3 Platforms and interfaces: MySQL is written in C and C++. The SQL parser uses yacc and a home-brewed lexer. MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HPUX, i5/OS, Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, eComStation , OS/2 Warp, QNX, IRIX, Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos, Tru64, Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP, and Windows Vista. A port of MySQL to OpenVMS is also available. Libraries for accessing 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/ANSI C++. To administer MySQL databases one can use the included command-line tool (commands: mysql and mysqladmin). Also downloadable from the MySQL site are GUI administration tools: MySQL Administrator and MySQL Query Browser. Both of the GUI tools are now included in one package called tools/5.0.html MySQL GUI Tools. In addition to the above-mentioned tools developed by MySQL AB, there are several other commercial and non-commercial tools available. Examples include SQLyog Community Edition, a free desktop based GUI tool and phpMyAdmin, a free Web-based administration interface implemented in PHP.

17

2.4 History Milestones in MySQL development include: • • • • • • • •

MySQL was first released internally on 23 May 1995 Windows version was released on 8 January 1998 for Windows 95 and NT Version 3.23: beta from June 2000, production release January 2001 Version 4.0: beta from August 2002, production release March 2003 Version 4.1: beta from June 2004, production release October 2004 Version 5.0: beta from March 2005, production release October 2005. Sun Microsystems acquired MySQL AB on 26 February 2008. Version 5.1: production release 27 November 2008

2.5 Features As of August 2007, MySQL offers MySQL 5.0 in two different variants: the MySQL Community Server and Enterprise Server. They have a common code base and include the following features: • • • • • • • • • • • • • • • • • •

A broad subset of ANSI SQL 99, as well as extensions Cross-platform support Stored procedures Triggers Cursors Updatable Views True VARCHAR support INFORMATION SCHEMA Strict mode X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using Oracle's InnoDB engine Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity, MySQL Archive for storing historical data in little space) Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB SSL support Query caching Sub-SELECTs Replication with one master per slave, many slaves per master, no automatic support for multiple masters per slave. Full-text indexing and searching using MyISAM engine Embedded database library

18

3. About the Project 3.1 Introduction: The Hotel Management System is a comprehensive software consisting of integrated modules for various aspects of hotel management. This class of software is often referred to as Property Management System in the industry. The important modules in the Software include, Hotel Management Software, Hotel Reservation Software (Billing Software), Hotel Reception Software and Hotel accounting software. In this lodging software all modules are tightly integrated. This Hotel management software is developed for Microsoft Windows operating system. This is general purpose hospitality software that can be used at hotels, motels, inns, resorts, lodges, hostel, military guest houses, ranch, suites, apartments, medical centers and bed & breakfast operations.

3.2 Minimum System Requirments: • • • • • • • • • •

Pentium 4 or better processor 256 MB of RAM or better (512 MB recommended) 20 GB of free hard disk space Color monitor with a resolution of 1024x768 pixel Broadband internet connection recommended for online support USB port for Swipe card reader, ScanShell reader, Signature pad and Webcam. Mouse or compatible pointing device Backup device such as USB Storage or External hard disk drive Modern Laser printer or Jet printer Windows Vista or XP operating system

19

4. Some SnapShots

20

21

22

23

24

25

26

27

References 5.1 Websites: •

www.programmersheaven.com

•

www.osborne.com

28