hotel management database project
DESCRIPTION
MS Acess database projectTRANSCRIPT
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
RAWALPINDI COLLEGE OF COMMERCE
HSSC Part-II FEDERAL BOARD EXAMINATION
DATABASE PROJECT REPORTRESCUE 1122
Page 1
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
SUBMITTED BY:
ZARA AKHTAR NEHA HAFEEZ KHAN
KAINAT BIBI
Page 2
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
CERTIFICATE
It is certified that Mrs. _______________________________________ Roll
No. _______________ studying in __________ is a bonafide student of
RAWALPINDI COLLEGE OF COMMERCE, Rawalpindi. She has
completed the database project in MS-Access for the 2015-2016
according to the syllabus of the Federal Board of Intermediate and
Secondary Education, Islamabad.
__________________
Signature of Computer Science Teacher Date
___________________
Signature of Examiner Date
Page 3
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
TABLE OF CONTENTS
1. INTRODUCTION
Introduction 7
Preamble 7
History 7
Mission 7
Emergency Services Academy 8
Services 8
Aims And Objectives 8
2. EXISTING SYSTEM
Existing System 10
Drawbacks Of The Existing System 10
Time Factor 11
Data Inconsistency 11
Data Redundancy 11
Danger Of Losing Data 11
Expense On The Firm's Budge 11
3. PROPOSED SYSTEM
Proposed System 13
Advantages Of The Proposed System 13
Efficiency 13
Multi-User Environment 13
Useful For Data Entry, Modification And Detection 14
Data Centralization 14
Page 4
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
Parallel Approach 14
4. SYSTEM DESIGN
Data Dictionary 17
Entity Relation Diagram 19
Tables in Design and Datasheet view: 20
Relationship Diagram 25
Forms 26
Queries 29
5. REPORTS
Department Report 32
Employees Report 32
Task Report 33
Project Report 33
Vehicle Report 34
6. USER GUIDE 35
7. GLOSSARY 37
Page 5
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
CHAPTER 1
“INTRODUCTION”
Page 6
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
1.1 INTRODUCTION
Punjab emergency service (rescue1122) is the first successfully tested model of trained Emergency
service in Pakistan. The government of Punjab has established this emergency service through
legislation to provide a system for emergency Preparedness, Response and Prevention.
The service has been established for proper management of emergencies such as road traffic
accidents, building collapse, explosions, fires and disasters which cause dangers to the lives and
properties of citizens of Pakistan.
1.2 PREAMBLE
Whereas it is expedient to establish an emergency service to maintain a state of preparedness to
deal with emergencies, to provide timely response, rescue and emergency medical treatment to
the persons affected by emergencies and recommending measures to be taken by related
organizations to avoid emergencies.
1.3 HISTORY
Punjab emergency Service 1122 evolved from Punjab Emergency And Ambulance Service
(Rescue1122) Pilot Project on 14th Oct 2004. Rescue 1122 was launched in 2005 as a small project of
ambulance service (Punjab Emergency and Ambulance Service) under Provincial Health
Department, Punjab. This service has been a great success by rescuing over 36,000 victims of
emergencies since Oct 2004. Then the service accepted the challenge of establishing a modern fire
service and disaster emergency response teams in Pakistan.
1.4 MISSION
A safer Punjab by reducing the mortality due to accidents, emergencies and disasters.
Page 7
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
1.5 EMERGENCY SERVICE ACADEMY
In order to ensure sustainable human resource development in the long neglected and essential
field of emergency and disaster management, Emergency Service Academy has been established in
the vacant government premises and the construction of a purpose built campus is underway. The
Academy is also in process of getting international accreditation to ensure quality of training. This
emergency service academy with training manikins' lab, rescue simulation building, incident
training equipments and training for disaster management is the first training institute of its kind in
Pakistan and can potentially train human resource in the field of emergency not only for the
country but also for the region.
1.6 SERVICES
Rescue 1122 can provide following major services province wide:
Ambulance Service
Fire Emergency Service
Disaster Emergency Service
Water Rescue Service
1.7 AIMS AND OBJECTIVES
Establishment of a system for Emergency preparedness, Response and prevention.
Development of Safer Communities through proactive approach towards Emergency
Management and Training.
To have positive socio-economic impact on the society by reducing deaths and disabilities
due to injuries amongst young able bread winners.
Page 8
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
CHAPTER 2:
“EXISTING SYSTEM”
Page 9
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
2.1 EXISTING SYSTEM
Punjab Emergency Service (rescue 1122) is the tested model of trained Emergency Service in
Pakistan. In this organization it is crucial for the staff to work in manual environment. It should be
equipped with all modern facilities. As Rescue 1122 has many related organizations and branches
so these need to be linked with each other through proper system. So it has to be make sure that
its every branch is provided with everything a successful organization needs. A brief of some
facilities is as follows:
Modern Machinery
Internet Facility
Networking Infrastructure
Transport Facility
Database Research System
2.2 DRAWBACKS OF THE EXISTING SYSTEM
The problems with the current system in Rescue 1122 are:
2.2.1 TIME FACTOR
In such a system when information is of non routine nature is needed, it take weeks to assemble
data from various fields and write new program to produced the required reports. It becomes time
consuming to retrieve any previous record.
2.2.2 DATA INCONSISTANCY
Page 10
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
If one department has data that is required by any other department, it is awkward to obtain it. A
second copy of the file could be made but this would be obviously soon lead to problems of
inconsistency
2.2.3 DATA REDUNDANCY The same data is duplicated in many different files known as data redundancy
2.2.4 DANGER OF LOSING DATA
As there is no proper computerized system so much data is lost due to manual work.
2.2.5 EXPENSE ON THE FIRM'S BUDGET
Each department has to have a head which is an expense on the firm's budget because of manual
work.
CHAPTER NO. 3
Page 11
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
“PROPOSED SYSTEM”
3.1 PROPOSED SYSTEM
The system proposed to disorganization should be to maintain their data in order to save it from
being lost. In order to provide efficient solution for the problem being faced, A new system is
proposed after making comprehensive study of existing system. The proposed system should
Page 12
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
update data on regular basis and collect data for research and analysis purposes as it is a
computerized record keeping system known with a lot of advantages.
3.2 ADVANTAGES OF THE PROPOSED SYSTEM
The proposed system is very useful. Some of its advantages are:
3.2.1EFFICIENCY
The proposed system provided to this organization will be an efficient one.
3.2.2MILTI-USER ENVIORNMENT
It would be capable enough to be implemented on multi-user environment.
3.2.3 USEFUL FOR ENTRY, MODIFICATION AND
DETECTION
The sheared data will be resistant on the client computer. This would be useful for the entry,
modification and detection.
Page 13
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
3.2.4 DATA CENTRALIZATION
All the data belonging to the entire organization is centralized in a common pool of data, accessible
by all applications. This solve the problem of redundancy and inconsistency
3.3 PARALLEL APPROACH
The present system will be implemented using parallel approach. In this approach, the existing
system continuous to function in parallel with the new system so that results generated by it can be
verified. When the organization will become fully satisfied with the functionality and output of the
system, the old system will be discarded. This system will be useful for the organization as it is easy
to maintain and helpful for many purposes.
CHAPTER NO. 4
“SYSTEM DESIGN”
Page 14
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
DATA DICTIONARY
DEPARTMENT TABLE:
Page 15
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
EMPLOYEE TABLE:
PROJECT TABLE:
TASK TABLE:
Page 16
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
VEHICLES TABLE:
ENTITY RELATIONSHIP DIAGRAM
Department
Employee name
Vehicle code
Department ID
No of employee
Page 17
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
DEPARTMENT TABLE
TABLE IN DESIGN VIEW:
Task
Project
Employee
Vehicles
Department ID
Employee ID
Ending date
Department name
Starting date
Employee ID
Address
Project ID
Status
Project name
Project ID
Employee ID
Vehicle type
Vehicle code
Status
Contains
Performs
Drive
Works
Page 18
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
TABLE IN DATASHEET VIEW:
EMPLOYEE TABLE
TABLE IN DESIGN VIEW:
Page 19
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
TABLE IN DATASHEET VIEW:
Page 20
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
PROJECT TABLE
TABLE IN DESIGN VIEW:
TABLE IN DATASHEET VIEW:
Page 21
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
TASK TABLE
TABLE IN DESIGN VIEW:
TABLE IN DATASHEET VIEW:
Page 22
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
VEHICLES TABLE
TABLE IN DESIGN VIEW:
TABLE IN DATASHEET VIEW:
Page 23
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
RELATIONSHIP
Page 24
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
FORMS
DEPARTMENT FORM:
EMPLOYEE FORM
:
Page 25
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
PROJECT FORM
TASK FORM:
Page 26
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
VEHICLE FORM:
Page 27
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
QUERIES
DEPARTMENT QUERY:
EMPLOYEE QUERY:
Page 28
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
PROJECT QUERY:
TASK QUERY:
Page 29
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
VEHICLES QUERY:
Page 30
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
CHAPTER NO 5
"REPORTS"
Page 31
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
REPORTS
DEPARTMENT REPORT:
EMPLOYEES REPORT:
Page 32
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
PROJECT REPORT:
TASK REPORT:
Page 33
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
VEHICLES REPORT:
Page 34
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
CHAPTER NO 6:
"USER GUIDE"
Page 35
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
MAIN SWITCH BOARD:
When we click on Department form button on the switchboard, it will open Department form.
Page 36
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
CHAPTER NO 7
"GLOSSARY"
Page 37
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
ACCESS
Access is a Microsoft product and is commonly used by developers to develop small dynamics
applications. Access allows developers to create applications within Access itself for enabling easy
data manipulation by the users
DATABASE
A Database is used to hold relational information. It is computerized system for storing information
in a structured easily accessible form.
RDBMS
RDBMS stands for relational database management system. In a relational database, the data is
stored in rows and columns
TABLE
A Database table is made up of one or more column definitions and the associated data in the form
of database rows.
FORM
A form is a window that displays a collection of controls such as labels, check boxes, text boxes and
lists for Viewing, entering and editing the information in a database field.
Page 38
RAWALPINDI COLLEGE OF COMMERCE DATABASE PROJECT
QUERIES
Queries are grouped together information to your database and organize it either for use in reports
or for viewing on screen in datasheet view or in a form.
REPORTS
Reports are used for printing information from a database. A report can combine data from more
than one table
RELATIONSHIP
A relationship is a link or association between entities of the tables.
ENTITY-RELATIONSHIP DIAGRAM
An entity-relationship diagram is a diagrammatic way of representing the relationship between the
entities of tables in a database.
Page 39