22-08-2012, 12:48 PM
Railway Reservation System
srs railway reservation system.docx (Size: 73.06 KB / Downloads: 106)
ABSTRACT
Designing a database for local train reservation
system and trying to get an access to the database and reserve.
This project deals with reserving tickets for the
local trains which is heck these days .So in order to
make it convenient to travel we can book tickets
priorily. This makes the travel smooth and
convenient. This also helps in checking the details
after wards.
INTRODUCTION
Designing a database for local train reservation
system and trying to get an access to the database and reserve.
This project deals with reserving tickets for the
local trains which is heck these days .So inorder to
make it convenient to travel we can book tickets
priorily. This makes the travel smooth and
convenient. This also helps in checking the details
after wards.
SQL (Structured Query Language)
SQL (Structured Query Language) is a database computer language designed for
managing data in relational database management systems (RDBMS), and originally based upon Relational Algebra. Its scope includes data query and update, schema creation and modification,and data access control.
The most common operation in SQL is the query, which is performed with the
declarative SELECT statement. SELECT retrieves data from one or more tables, or
expressions.
A query includes a list of columns to be included in the final result immediately
following the SELECT keyword. An asterisk ("*") can also be used to specify that the
query should return all columns of the queried tables. SELECT is the most complex
Transaction controls
Transactions, if available, DML operations:
COMMIT causes all data changes in a transaction to be made permanent.
•ROLLBACK causes all data changes since the last COMMIT or ROLLBACK to
be discarded, leaving the state of the data as it was prior to those changes.
Once the COMMIT statement completes, the transaction's changes cannot be rolled back.Commit;
Data definition
The Data Definition Language (DDL) manages table and index structure. The most basic items of DDL are the CREATE, ALTER, RENAME, DROP and TRUNCATE statements:
UML DIAGRAMS:
UML stands for Unified Modeling Language. This object-oriented system of
notation has evolved from the work of Grady Booch, James Rumbaugh, Ivar Jacobson,
and the Rational Software Corporation. These renowned computer scientists fused their
respective technologies into a single, standardized model. Today, UML is accepted by the Object Management Group (OMG) as the standard for modeling object oriented
programs.
srs railway reservation system.docx (Size: 73.06 KB / Downloads: 106)
ABSTRACT
Designing a database for local train reservation
system and trying to get an access to the database and reserve.
This project deals with reserving tickets for the
local trains which is heck these days .So in order to
make it convenient to travel we can book tickets
priorily. This makes the travel smooth and
convenient. This also helps in checking the details
after wards.
INTRODUCTION
Designing a database for local train reservation
system and trying to get an access to the database and reserve.
This project deals with reserving tickets for the
local trains which is heck these days .So inorder to
make it convenient to travel we can book tickets
priorily. This makes the travel smooth and
convenient. This also helps in checking the details
after wards.
SQL (Structured Query Language)
SQL (Structured Query Language) is a database computer language designed for
managing data in relational database management systems (RDBMS), and originally based upon Relational Algebra. Its scope includes data query and update, schema creation and modification,and data access control.
The most common operation in SQL is the query, which is performed with the
declarative SELECT statement. SELECT retrieves data from one or more tables, or
expressions.
A query includes a list of columns to be included in the final result immediately
following the SELECT keyword. An asterisk ("*") can also be used to specify that the
query should return all columns of the queried tables. SELECT is the most complex
Transaction controls
Transactions, if available, DML operations:
COMMIT causes all data changes in a transaction to be made permanent.
•ROLLBACK causes all data changes since the last COMMIT or ROLLBACK to
be discarded, leaving the state of the data as it was prior to those changes.
Once the COMMIT statement completes, the transaction's changes cannot be rolled back.Commit;
Data definition
The Data Definition Language (DDL) manages table and index structure. The most basic items of DDL are the CREATE, ALTER, RENAME, DROP and TRUNCATE statements:
UML DIAGRAMS:
UML stands for Unified Modeling Language. This object-oriented system of
notation has evolved from the work of Grady Booch, James Rumbaugh, Ivar Jacobson,
and the Rational Software Corporation. These renowned computer scientists fused their
respective technologies into a single, standardized model. Today, UML is accepted by the Object Management Group (OMG) as the standard for modeling object oriented
programs.