software requirements specification (SRS)
Specification of Software Requirements (SRS) is a detailed description of the purpose and environment of the software under development. SRS fully describes what the software will do and how it will be expected.
The purpose of this document is to build an online system to manage flights and passengers to reduce flight management. << Include goals that are applicable to your project >>
1.2 CONVENTIONS OF DOCUMENTS
This document uses the following conventions. << Include conventions as per your application >>
DDB Distributed Database
ER Entity Relationship
1.3 SUGGESTED SITUATION AND READING SUGGESTIONS
This project is a prototype for flight management system and is restricted within college areas. It was implemented under the guidance of college professors. This project is useful for flight management teams as well as for passengers.
1.4 SCOPE PROJECT
The purpose of the online flight management system is to reduce flight management and to create a convenient and easy-to-use application for passengers, trying to buy airline tickets. The system is based on a relational database with its flight management functions and reservation. We will have a database server that supports hundreds of major cities around the world as well as thousands of flights by various airline companies. Above all, we hope to provide a comfortable user experience with the best available pricing.
Basis of database systems by ramez elmarsi and shamkant b.navathe
2. GENERAL DESCRIPTION
2.1 PRODUCT PERSPECTIVE
A distributed database system of the airline stores the following information.
This includes the origin of the flight terminal and destination terminal, including stops between, the number of seats booked / available seats between the two destinations etc.
This includes customer code, name, address and phone number. This information may be used for maintaining customer records for any emergency or for any other type of information.
This includes customer details, code number, flight number, booking date, travel date.
2.2 PRODUCT FEATURES
The main features of the airline database system as shown below entity-relationship model (ER model)
2.3 USER CLASS and CHARACTERISTICS
System users should be able to get flight information between two provided cities with the provided date / travel time from the database. A route from city A to city B is a sequence of connecting flights from A to B such that: a) with the most two connecting stops, excluding the city's starting city and destination travel, b) the connection time is between one to two hours. The system supports two types of user privileges, Customer, and Employee. Customers will have access to customer functions, and employees will have access to both customer management and flight management functions. Customer must have the following functions:
Make a new reservation
• A lane
• Back and forth
• Multiple cities
• Flexible Date / time
Cancel an existing reservation
See his itinerary
The employee must have the following management functions:
• Get all customers with seats available on a given flight.
• Get all the flights for a given airport.
• View the flight schedule.
• Get all the flights that the arrival and departure times are timely / delayed.
• Calculate total sales for a given flight.
• Add / Remove flight
• Add a new airport
• Update fares for flights.
• Add a new flight leg opportunity.
• Update departure / arrival times for flight leg instance.
Each flight has a limited number of available seats. There are a number of flights to leave or come to different cities at different dates and times.
2.4 LOCAL CHANGES
The operating environment for the airline management system is as listed below. << Include details according to your application >>
client / server system
Operating system: Windows.
database: sql + databases
2.5 DESIGN and IMPLEMENTATION CONSTRAINTS
The global schema, fragment schema, and allocation scheme.
SQL commands for the above questions / applications
How to generate response for application 1 and 2. Assume they are global queries. Explain how different fragments work together to do this.
Implement the database at least using a centralized database management system.
2.6 DEPENDENCY OF ASPLEMENTS
Let's say that this is a distributed airline management system and is used in the following applications:
A request for reservations / cancellations of a flight from any source at any destination, providing connected flights in case of no direct flight between the specified Source-Destination pair exists.
Calculating the high fliers (most frequently fliers) and calculating the appropriate rewards points for the fliers.
Assuming both transactions are single transactions, we design a distributed geographic database by dispersed in four cities Delhi, Mumbai, Chennai, and Kolkatta as shown in fig. below.
3. SYSTEM FEATURES
DESCRIPTION and PRIORITY
The airline reservation system maintains information about flights, seat classes, personal preferences, prices, and bookings. Of course, this project has a high priority because it is very difficult to travel to countries without prior reservations.
STIMULUS / RESPONSE SEQUENCES
Find Airline Flights for two Travel Cities
Displays a detailed list of available flights and make "Reservation" or Book a ticket on a particular flight.
Cancel an existing Reservation.
Other system features include:
The provided database indicates that a single application should work well with data that spreads across different databases and connected through a network of communications as shown below.
CLIENT / SERVER SYSTEM
The term client / server mainly refers to an architectural or logical division of responsibilities, the client is the application (also known as front-end), and the server is the DBMS (also known as back-end).
A client / server system is a distributed system where,
Some sites are client sites and others are server sites.
All data is located on server sites.
All applications execute on client sites.
4. REQUIREMENTS OF EXTERNAL INTERFACE
4.1 USER INTERFACES
Front-end software: Vb.net version
Back-end software: SQL +
4.2 hardware INTERFACES
4.3 INTERFACES OF SOFTWARE
The following are the software used for online flight management management. << Include software details as per your project >>
4.4 COMMUNICATIONS INTERFACES
This project supports all kinds of web browsers. We use simple electronic forms for reservation forms, ticket reservations etc.
5. NONFUNCTIONAL REQUIREMENTS
5.1 REQUIREMENTS OF PERFORMANCE
The steps involved to carry out the implementation of the airline database are as listed below.
A) E-R DIAGRAM
The E-R Diagram generates a technique for representing the logical structure of a database in a pictorial way. After this analysis is used to sort the data as a relation, normalizing the relationship and finally getting a database of relevance.
ENTITIES: Which distinguish real-world objects in an application.
REQUIREMENTS / REQUIREMENTS: Which define the characteristics of an entity and relationships.
RELATIONSHIP: Which entities connect and represent significant dependencies between them.
The primary purpose of normalization is to reduce the redundancy which means that information should be stored only once. Information storage several times leads to waste storage space and increase in total data size stored.
If a database is not properly designed it can increase with anomalous change. Changing anomalies will appear when the data is added to, modified or deleted from a database table. Similarly, in traditional databases as well as improperly designed relational databases, data redundancy can be a problem. These can be removed by normalizing a database.
Normalisation is the process of collapse of a table into smaller tables. So that each table is related to a single theme. There are three different types of anomaly changes and consists of the first, second and third normal forms (3NF) being considered sufficient for most practical purposes. It should be considered only after careful analysis and complete understanding of its implications.
5.2 SAFETY REQUIREMENTS
If there is extensive damage to a large portion of the database due to failure of failure, such as a disk crash, the recovery method returns a previous copy of the database that is backed up to archival storage (usually tape ) and reconstructs a more current state by reapply or reduces the operations of the assigned transactions from backed up logs, to the time of failure.
5.3 SECURITY REQUIREMENTS
Security systems require database storage like many other applications. However, special security requirements in the market means that vendors should choose their database partner carefully.
5.4 SOFTWARE QUALITY QUALITY
REQUIREMENTS: The flight must be available at the specified date and specified time many customers are making advance reservations.
KATARUNGANG: The flight must reach the start of the right starting terminal and must reach the correct destination.
MAINTAINABILITY: Administrators and flight chargers must maintain proper flight schedules.
USABILITY: Flight schedules should satisfy a maximum number of customer needs.