Preview

Term Paper of Database Management System

Powerful Essays
Open Document
Open Document
1584 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Term Paper of Database Management System
TERM PAPER

OF

DATABASE MANAGEMENT SYSTEM

Topic: Railway reservation system for Indian railways

Submitted To:- Submitted By:-

Mr. Dinesh Kumar Rohit Kapoor

B.Tech CSE

Section- C1701

Roll No.-41

Regd. No.-1050070080

TABLE OF CONTENTS:

1. INTRODUCTION

2. ABOUT THE DATABASE

3. PHYSICAL DATA MODEL FOR RAILWAY RESERVATION

4. E-R DIAGRAM

5. CREATION OF THE DATABASE

1. TRAIN_INFO

2. STATION_INFO

3. TRAIN_SCHEDULE

4. TRAIN_SEATS

5. RESERVATION

6. PASSENGER

6. INSERTION OF THE VALUES INTO THE DATABASE

1. TRAIN_INFO

2. STATION_INFO

3. TRAIN_SEATS

4. STATION_SCHEDULE

5. RESERVATION

6. PASSENGER

7. ACKNOWLEDGEMENT

8. REFERENCES

1. INTRODUCTION

This concept is basically about the reserving railway tickets for passengers. This method can be used as an online method for reserving tickets as well as canceling of reserved tickets. This system maintains whole of the database in an efficient way as it uses SQL database. This is permanent data storage method and chances of data loss are only if the database crashes. This system is meant for use by Indian Railways for handling reservations only. The system must cater to all passenger services provided by Indian Railways and must minimally provide support for reservation of different classes of seats/berths, onward journeys, wait-listed tickets and RAC tickets. Providing support for reservation will also require that the system records
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Software Design Document
    • 854 Words
    • 4 Pages

    Software Design Document

    The Reservations System for a new small company B&B will be robust. The system will be designed to manage reservations and also to monitor expenses and profits. This will produce easy understandable reports that will increase productivity by reducing the managing and monitoring process time. The project scope will…

    • 854 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Database Management System and Data
    • 579 Words
    • 3 Pages

    Database Management System and Data

    * In an inventory order system, you don't want an order to be deleted if there are inventory order items, or those items will be orphaned.…

    • 579 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Database Systems Week 1 Paper
    • 414 Words
    • 2 Pages

    Database Systems Week 1 Paper

    A database is a digital storage area that helps people keep track of things. A database can also be considered a digital list because in the real world work environment keeping track of lists is very valuable to an organization but in other cases a simple list is not agile and versatile enough to avoid data inconsistencies and other problems that may arise. Databases are valuable because they are not only objects that remain in list form; but also a tool that can be split into table data that may then help to solve organizational problems that lead to more efficient business operation. The best way to organize valuable information within an organization is rational database tables because they are designed to solve all of the problems and limitations that comes with simple lists.…

    • 414 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Database Paper
    • 672 Words
    • 3 Pages

    Database Paper

    Whatis.com (2004) defines a database as "a collection of information that is organized so that it can easily be accessed, managed, and updated." In my current job at Wellco Tank Trucks, Inc., we do not use any type of databases in the daily operations of our business. My only job that involved regular use of a database was at Chilcutt Direct Marketing (CDM) in Oklahoma City, Oklahoma. From February 2003 to June 2004, I was an Account Executive of Brokerage at CDM. CDM is a direct marketing company that manages and brokers customer mailing lists for companies across the United States.…

    • 672 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Database Design Paper
    • 429 Words
    • 2 Pages

    Database Design Paper

    A database system is a computer term for a structured set of data that can be saved, retrieved, added to or deleted from relatively easy. There are a variety of different databases and the type of database will determine how the data is arranged when it is stored and how that data will be located when it is called upon.…

    • 429 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Database Term Paper
    • 455 Words
    • 2 Pages

    Database Term Paper

    -Audit the industry 's widest range of databases for security, configuration and operational vulnerabilities, exploit root level access to collect evidence for reporting and ensure you secure you most valuable assets.…

    • 455 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Modernized Integrated Database Paper
    • 758 Words
    • 4 Pages

    Modernized Integrated Database Paper

    Databases are defined as: a usually large collection of data organized especially for rapid search and retrieval (as by a computer). Without databases the world of technology wouldn’t be as far along as it is. Databases are used in every organization, online websites, home computer systems, and other various ones. The contents of this paper will analyze the use of Modernized Integrated Database (MIDB) within L3 Communications, Titan’s, Product Support Team (PST) in reference to Global Command and Control Systems-Maritime (GGCS-M).…

    • 758 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    thesis of dbms
    • 1111 Words
    • 5 Pages

    thesis of dbms

    The Mallows, also known as Alida Chanler Emmet and Christopher Temple Emmet Estate, is a historic home located at Head of the Harbor in Suffolk County, New York. It is a Colonial Revival estate home designed in 1906 by noted architect Charles A. Platt (1861–1933). It is an imposing structure, finished in stucco with powerful wooden detailing at the principal doorways, roof cornice and porch. It is a large rectangular mass, two full stories in height, seven bays long, with projecting wings. It features a simple pitched gable roof and a two story porch on the west wing with large Doric order piers.[2]…

    • 1111 Words
    • 5 Pages
    Good Essays
    Read More
  • Better Essays

    Relational Database Management System
    • 1168 Words
    • 5 Pages

    Relational Database Management System

    Oracle provides a flexible RDBMS called Oracle7. Using its features, you can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provides you with the ability to store and execute program units. The server offers the options of retrieving data based on optimization techniques. It includes security features that control how a database is accessed and used. Other features include consistency and protection of data through locking mechanisms.…

    • 1168 Words
    • 5 Pages
    Better Essays
    Read More
  • Powerful Essays

    Mis Indian Railways
    • 5318 Words
    • 22 Pages

    Mis Indian Railways

    Indian Railways is a Department of the Government of India, under the Ministry of Railways, and is tasked with operating the rail network in India. The Ministry is headed by a cabinet rank Railways Minister, while the Department is managed by the Railway Board. Indian Railways is not a private corporate body; however, as of recently, IR has adopted a corporate management style.…

    • 5318 Words
    • 22 Pages
    Powerful Essays
    Read More
  • Good Essays

    Computer Database Technology
    • 435 Words
    • 2 Pages

    Computer Database Technology

    This paper investigates such important aspect of car business as database technology, in particular workflow database technology and its influence on the productivity. The main aim of this paper is to investigate the role of database technology in car plants. Nowadays there are hundred of workflow products and technologies at the market. Thus the database technologies are influencing this area this or that way.…

    • 435 Words
    • 2 Pages
    Good Essays
    Read More
  • Powerful Essays

    Train Schedule Srs
    • 2759 Words
    • 12 Pages

    Train Schedule Srs

    [pic] Online Train Schedule Information System Software Requirement Specification Table of Contents 1. Introduction 3 1.1 Purpose 3 1.2 Scope 3 2. Overall Description 2.1 Product Perspective 4 2.2 Product Functions 5 2.3 User Characteristics 6 2.4 Constraints 6 2.5 Assumptions and Dependencies 7 3. Specific Requirements 7 3.1 Functionality 7 3.1.1 Search Capabilities 7 3.1.2 Mobile Devices 7 3.1.3 Alerts 7 3.2 Usability 8 3.3 Reliability 8 3.3.1 Availability 8 3.3.2 Mean Time Between Failures (MTBF) 8 3.3.3 Mean Time to Repair (MTTR) 8 3.3.4 Accuracy 8 3.3.5 Maximum Bugs or Defect Rate 8 3.3.6 Access Reliability 8 3.4 Performance 8 3.4.1 Response Time 8 3.4.2 Administrator Response 9 3.4.3 Throughput 9 3.4.4 Capacity 9 3.4.5 Resource Utilization 9 3.5 Supportability 9 3.5.1 Internet Protocols 9 3.5.2 Information Security Requirement 9 3.5.3 Billing System Data Compatibility 9 3.5.4 Maintenance 9 3.5.5 Standards 9 3.6 Design Constraints 9 3.6.1 Software Language Used 9 3.6.2 Development Tools 10…

    • 2759 Words
    • 12 Pages
    Powerful Essays
    Read More
  • Good Essays

    Database Management
    • 796 Words
    • 3 Pages

    Database Management

    As we are all aware, health care has drastically changed and keeps changing. Many have embraced this change, however, several are still skeptical of these changes due to the availability of health care information and health data that is so candidly available. The collection of health care data is vital to the nation’s health care organizations. Data that is collected from each individual patient is essential for purposes of increasing awareness of diseases, sickness of specific race or authenticity, dangers of long-term use in medications or lifestyles. An enormous amount of research for specific cures is based on the data that is collected from health care organizations. There are also government organizations that will pave the road for programmers to be able to develop the framework of the database. The data that is collected from an electronic medical record system is imperative in supporting new knowledge of the manner in which a person’s health can be prolonged, or even saved.…

    • 796 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Database Paper
    • 440 Words
    • 2 Pages

    Database Paper

    There have been 6 revisions in SQL, 3 major revisions and 4 minor revisions as well. The three major revisions were SQL-86, SQL-92, and SQL:1999, and the four minor revisions were SQL:2003, SQL:2006, SQL:2008, and SQL:2011. [1] The updates in SQL:2011 are Periods, Application-time period tables, System-versioned tables, and Bitemporal tables. Application-time period tables have Primary keys, Referential constraints, and Querying and System-versioned tables have Primary key, Referential constraints, Querying. [2]…

    • 440 Words
    • 2 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Related Of Related Literature Systems
    • 615 Words
    • 2 Pages

    Related Of Related Literature Systems

    This program can be used by the users in performing online reservation via internet for their all business purposes. The software program “Online Bus Reservation System” provides bus transportation system, a facility to reserved seats, cancellation of seats and different types of enquiry which need an instant and quick reservation. This system can be used by the users. A ticket is a voucher that indicates that one has paid for admission to an event or establishment such as a theatre, amusement park or tourist attraction, or permission to travel on a vehicle (such as with an airline ticket, bus ticket or train ticket) typically because one has paid the fare. A ticket may be free, and serve simply as a proof of reservation.…

    • 615 Words
    • 2 Pages
    Satisfactory Essays
    Read More

Related Topics