Airline Database - 1533 Words

SOFTWARE REQUIREMENTS SPECIFICATION(SRS) FOR AIRLINE DATABASE Table of Contents 1. Introduction 1.1 Purpose 1.2 Document Conventions 1.3 Intended Audience and Reading Suggestions 1.4 Project Scope 1.5 References 2. Overall Description 2.1 Product Perspective 2.2 Product Features 2.3 User Classes and Characteristics 2.4 Operating Environment 2.5 Design and Implementation Constraints 2.6 Assumptions and Dependencies 3. System Features 4. External Interface Requirements 4.1 User Interfaces 4.2 Hardware Interfaces 4.3 Software Interfaces 4.4 Communications Interfaces 5. Other Nonfunctional Requirements 5.1 Performance Requirements 5.2 Safety Requirements 5.3 Security Requirements 5.4 Software Quality Attributes 1. INTRODUCTION 1.1†¦show more content†¦Ã¢â€"  database: sql+ database ââ€"  platform: vb.net 2.5 DESIGN AND IMPLEMENTATION CONSTRAINTS i) The global schema, fragmentation schema, allocation schema. ii) SQL commands for above queries/applications iii) How the response for application 1 and 2 will be generated. Assuming these are global queries. Explain how various fragments will be combined to do so. iv) Implement the database at least using a centralized database management system. 2.6 ASSUPMTION DEPENDENCIES Let us assume that this is a distributed airline database system and it is used in the following application: ââ€"  A request for booking/cancellation of flight from any source to any destination, giving connected flights in case no direct flight between the specified Source-Destination pair exist. ââ€"  Calculation of high fliers (most frequent fliers) and calculating appropriate reward points for these fliers. Assuming both the transactions are single transactions, we have designed a distributed database that is geographically dispersed at four cities Delhi, Mumbai, Chennai and Kolkatta as shown in fig.2 above. 3. SYSTEM FEATURES ââ€"  DESCRIPTION AND PRIORITY The airline reservation system maintains information on flights, classes of seats, personal preferences, prices and bookings. Of course this project has high priority because it is very difficult to travelShow MoreRelatedAnnotated Bibliography On Database Security1383 Words   |  6 PagesIntroduction: Database security is the system, processes and procedure that protect the database from unauthorized individual or malicious attacks. The researches on database security has been increased gradually over the years as the most of critical business functionalities and military secrets became digitized. Database is an integral part of the information system and often holds the sensitive data. The database have to be protected from external connections like firewalls or routers on the networkRead MoreThe Application Of The Apache Hadoop Open Source Database Program1647 Words   |  7 Pagesoutline and describe three vendors that provide the Hadoop NoSQL database program to enterprises. Each of these companies see themselves as uniquely different, thus positioning themselves within a market place that has begun to become highly competitive in the â€Å"Big Data† age. I will provide an outline of the talking points that will be discussed for each company, starting with a brief desc ription of the Hadoop NoSQL open-source database program, then I will discuss each company on the evaluation categoriesRead MoreObject Relational Mapping Tool For Java1805 Words   |  8 Pagest do directly with most of the popular relational databases. ORM helps achieving this. Once you start using any ORM technology then you forget about how internally the data is transformed back and forth and you get a feeling that the objects are getting stored and retrieved the same way as numbers, for instance. What is JDBC? Java Database Connectivity is a standard application programming interface that allows Java programs to access database management systems like Oracle, Microsoft SQL, etc.Read MoreSecondary Data2036 Words   |  9 PagesSmall b. Available dollar sales potential c. Current sales penetration d. Existing bids/contracts by customer location product Q) What is a computerized Data Base? COMPUTERIZED DATA BASE A database is simply a collection of related information. More specifically a computerized database is a computerized record keeping system. More completely, it is a system involving data, the hardware that physically stores that data, the software that utilizes the hardware s file system in order toRead MoreInformation Is The Backbone Of Todays Society2064 Words   |  9 Pagesthat is shared freely can be just a text/csv file of information without any real database schema defined like the one used in this experiment. This information can be manipulated, the structure changed and indexes can be created to aid in what queries that individual is running. An industry example of a single database that is copied and distributed for users to set up on their own servers is a drug information database that contains various information about pharmaceuticals and their interactionsRead MoreHuman Resource Industry Audit - Reflection Paper1325 Words   |  6 Pagesenvironment. The commercial airline industry is an extremely competitive, safety-sensitive, high technology service industry (Appelbaum and Fewster, 2002). This industry is struggling to remain competitive and effective management of personnel plays a large role in its viability. People, employees, and customers must remain the center of the industry s core competence (Appelbaum and Fewster, 2002). The human resource audit focuses on the management of people in the airline industry. The purpose ofRead More The Database Dilemma Essay3843 Words   |  16 PagesThe Database Dilemma Personal privacy today is a controversial and complex topic, which is influenced by a number of factors. There is an integral role that databases play in this highly debated topic. The fact that many people now carry out their transactions electronically is another important factor. There is also pressure on personal privacy for increased national security around the world to combat terrorism. In addition, personal privacy is even threatened by commercial factors and theRead MoreLaudon - Business Information Systems16132 Words   |  65 Pagesinformation systems? How is this relationship changing over time? Information systems are increasingly tied to the organization’s business strategy, rules and procedures. A change in strategy, rules or procedures requires changes in software, hardware, databases, and telecommunications, and vice-versa. An organization’s present and future accomplishments depend in many respects on what its systems will permit it to do. Whereas ear ly information systems addressed primarily technical or operational issuesRead MoreQNT561 Sampling and Data Collection Pla Essay957 Words   |  4 Pagesï » ¿ Sampling and Data Collection Plan Name QNT/561 October 27, 2014 Instructor Introduction Royal Blue Airlines is a medium sized airline company offering flights throughout the United States, Mexico, Caribbean Islands, and Latin America. The company operates a fleet of Boeing 737 aircrafts and is in the process of replacing older ones with newer, state-of-the-art planes. These new planes are very expensive, so management wants to maximize passenger count. A study has been authorizedRead MoreThe Strategy Of Airasia X1236 Words   |  5 PagesProblem Statement In 2001, AirAsia was founded by Tony Fernandes. After six years, Fernandes realized the company should create a airline separated from AirAsia to focus on the low cost long-haul market which he called AirAsia X. Azran Osman-Rani was appointed to the become the CEO of the newly established company. The company had an initial success by being the first mover. However, there were some problems that they had to face along the way as they were in a completely new market using an untried