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

    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
  • 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
  • Powerful Essays

    Database Management Systems
    • 960 Words
    • 4 Pages

    Database Management Systems

    Due date: 1 August 2012 NB: Make sure you select the correct unique number for your module from those indicated below. Unique number 759546 Tutorial matter covered in the prescribed book Chapters 1 - 3: Chapter 5: Chapter 6: Chapter 7: Chapter 12: Chapter 14: Chapter 16: Revise as for Assignment 01 Entity relationship modelling Advanced data modelling Normalisation of database tables Transaction management and concurrency control Distributed database management systems Database connectivity and web development…

    • 960 Words
    • 4 Pages
    Powerful 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

    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
  • 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
  • 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
  • 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
    • 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
  • 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
  • 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
  • Powerful Essays

    Database Management System
    • 936 Words
    • 4 Pages

    Database Management System

    The research that I have done for this individual assignment where I need to provide a brief explanation of OLAP, Data Warehouse and Data Mart, Three-tier architecture and ASP was through a research online. I found that most of these acronyms for computer terminology are hard to find when the meanings that apply to your subject or acronym you are un-aware of it. In conclusion all the above words are related one to each other.…

    • 936 Words
    • 4 Pages
    Powerful Essays
    Read More

Related Topics