We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Check Writers' Offers

What's Your Topic?

Hire a Professional Writer Now

The input space is limited by 250 symbols

What's Your Deadline?

Choose 3 Hours or More.
Back
2/4 steps

How Many Pages?

Back
3/4 steps

Sign Up and Get Writers' Offers

"You must agree to out terms of services and privacy policy"
Back
Get Offer

Analysis Of A Hotel Database Management System Computer Science Essay

Paper type: Analysis
Pages: 5 (1223 words)
Categories: Computer, Data, Essay, Management, Science
Downloads: 20
Views: 1

This is package which has chiefly made for direction of a Hotel. The package has been designed with front-end as VB and backend as Oracle. The undertaking Hotel Management manages maintains the records of clients and room in the hotel. The suites have different classs. So there charges and records will be maintained consequently. This package has been made in a user friendly interface, so that normal individuals can add, cancel the entries of clients and manage all the minutess easy.

SYSTEM ANALYSIS

The initial analysis is made by cognizing the user demands. In analysis stage, we have analyzed the

user ‘s demand such as: –

Addition of the record of the client who comes into the hotel, omission of the record when client leaves the hotel, printing and computation of the measure, record of installations available in the hotel, allocation of the suites etc. In this undertaking we have besides analyzed that the merchandise or package should non be really dearly-won but its quality and interface must be attractive.

If any incorrect operation is being performed so the package must raise the operator consequently.

FEASIBILITY STUDY

A feasibleness survey is carried out to choose the best system that must public presentation demand

and its working ability in an organisation. The feasibleness of the system has been done in three types: –

-Technical Feasibility Study

-Economical Feasibility Study

-Behavioral Feasibility Study

TECHANICL FEASIBILITY

Technically we have made feasibleness in maintaining head about the hardware so that the designed package can work swimmingly with maximal efficiency with the hardware.

ECONOMICAL FEASIBILITY

In this we chiefly calculate the cost of proposed system and the cost of client and compare the cost to run into the users cost. The cost of hardware, installation cost, runing and supply costs are considered. The cost of feasibleness is besides considered on this such as wiring, lightning, A.C. etc.

BEHAVIOURAL FEASIBILITY

We have to see the cost of staff which has particular attempts to educate, sell train on new

ways.

SOFTWARE & A ; HARDWARE REQUIREMENTS

There are some package and hardware demands of the package hotel direction system.

Software REQUIREMENTS

-Visual Basic.net as frontend

-Oracle Database as backend

-Windows 7 place Premium

Hardware REQUIREMENTS

-Pentium- 4 processor

-40 & A ; more GB for informations storage

-128 to 512 KB RAM

-Printer for describing and printing

Execution

To implement this undertaking, HOTEL MANEGEMENT will necessitate a ocular BASIC as frontend & A ;

Oracle Database as backend.

SYSTEM DESIGN

In this package we have developed some signifiers. The brief description about them is as follow: –

MDI FORM

This is the chief signifier. It contains following Fieldss: –

Hotel

Customer

Reservation

Room

Room Category

Search

On traveling the pointer to any of the above Fieldss, drop down bill of fares will be displayed user can snap on any of the options available in them and their several signifiers will open.

Hotel

The chief intent of this signifier is to add a new hotel to the database. For this intent, the user will be required to make full the Hotel Idaho, Hotel Name and their reference. After make fulling all the entries, when we click on the on the saveA button, the record will be added to the database.

Customer

In this signifier, user can add a new client to the records. For this intent, the user will be required to make full the client Idaho, name of the residents, their reference. After make fulling all the entries, when we click on the Submit button, the record will be added to the database.

Reservation

This is the reserve signifier where the user inputs client ‘s reserve inside informations, for illustration: Reservation Id, Customer Id, Hotel Id, Reservation day of the month, Arrival day of the months and so on. The user can choose the type of suites by inputting the room class Idaho from the list box. The charges per twenty-four hours of this room are displayed in the list itself. After make fulling all the entries, when the user chink save button, the records will be added to the database.

Degree centigrades: UsersWindows 7DesktopUntitled.png

Room

This is the room signifier, where the user hunt entire suites in the hotel by the room inside informations like hotel Idaho, room figure and room class Idaho. After make fulling all the entries, when the user chink hunt button, the user will be able to see the types of room by their room inside informations.

Room Category

This is the room class signifier where the user inputs inside informations in the room classs in the hotel by the room inside informations like class Idaho, class name and figure of beds. After make fulling all the entries, when the user chink save button, the user will be able to see the types of room by their room inside informations

Search

This signifier hunt all the database harmonizing the input of the user, If the input is found in the database, so message box “ input found ” and the consequence will be displayed, In the other manus, if the user inputs incorrect input, a monosodium glutamate box displays “ input non found please seek once more ” . And no consequence will be displayed.

Degree centigrades: UsersWindows 7Desktopsearch.png

System Study & A ; Analysis

PRINCIPLES OF SYSTEM ANALYSIS

-Understand the job before you begin to make the analysis theoretical account.

-Develop paradigms that enable a user to understand how human machine interaction will happen.

-Record the beginning of and the ground for every demand.

-Use multiple positions of demands like edifice informations, map and behavioural theoretical accounts.

-Work to extinguish ambiguity.

ENTITY RELATIONSHIP DIAGRAM ( ERD )

Entity-Relationship Diagram

This depicts relationship between informations objects. The property of each information objects noted in the entity- relationship diagram can be described utilizing a information object description. Data flow diagram serves two intents:

-To provide an initiation of how informations are transformed as they move through the system.

-To depict the maps that transformation the information flow.

Datas Objects

A information object is a representation of about any composite information that must be understood by the package. By composite information, we mean something that has a figure of different belongingss or properties. A information object encapsulates informations merely there is no mention within a information object to operations that act on the information.

Properties: Attributes define the belongingss of a information object and take on one of three different features. They can be used to ;

-Name an case of informations object.

-Describe the case

-Make mention to another case in other tabular array.

Relationship

Datas objects are connected to one another in a assortment of different ways. We can specify a set of object relationship braces that define the relevant relationships.

E-R DIAGRAM

Customer

Hotel

Check IN

Room

Information

Room

Room Record

Customer

Hotel

Check OUT

Customer

Room

ROOM PRICE

Hotel

DATA Mold

Data mold defines primary informations objects, composing of each information object, and properties of the object and other objects and between objects and procedures.

Hotel Table

William claude dukenfields

Type

Hotel Id

Varchar2

Hotel Name

Varchar2

Address

Varchar2

City

Varchar2

Telephone No

Number

Number of Stars

Varchar2

Customer Table

William claude dukenfields

Type

Customer Id

Varchar2

First Name

Varchar2

Last Name

Varchar2

Gender

Varchar2

Address

Varchar2

Telephone No

Number

Email Address

Varchar2

Reservation

William claude dukenfields

Type

Reservation Id

Varchar2

Customer Id

Varchar2

Hotel Id

Varchar2

Reservation Date

Date

Arrival Date

Date

Departure Date

Date

Room Category

Varchar2

Status

Varchar2

Entire Cost

Number

Room

Field

Type

Hotel Id

Varchar2

Room Number

Number

Category Id

Varchar2

Room Category

Field

Type

Category Id

Varchar2

Class Name

Varchar2

Number Of Beds

Number

Search

In this map, room, client as user can seek item from the database harmonizing to their hallmark.

Decision

This undertaking have been designed in a great user friendly and mostly supplying attribute interface and tp meet the demand of a Hotel Management System.. The undertaking is working with speedy response and same degree of security is besides maintained. The Oracle database is maintained and frontend with Visual Basic.

In this designing system, I have used an ER Diagrams ; overall this undertaking teaches us the indispensable accomplishment like ;

-Understanding the Oracle database handling and question processing.

-Using system analysis and design techniques like ER diagram and Data mold in planing the system.

Cite this essay

Analysis Of A Hotel Database Management System Computer Science Essay. (2020, Jun 01). Retrieved from https://studymoose.com/analysis-of-a-hotel-database-management-system-computer-science-new-essay

How to Avoid Plagiarism
  • Use multiple resourses when assembling your essay
  • Use Plagiarism Checker to double check your essay
  • Get help from professional writers when not sure you can do it yourself
  • Do not copy and paste free to download essays
Get plagiarism free essay

Not Finding What You Need?

Search for essay samples now

image

Your Answer is very helpful for Us
Thank you a lot!