Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
DATABASE MANAGEMENT Explain about Normalization 1NF and so on in database management system detailed report on project.
Typology: Assignments
1 / 15
This page cannot be seen from the preview
Don't miss anything!
Seal of institution MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION CERTIFICATE
RUBRIC FOR EAVLUATION ON MICRO PROJECT
ANNEXTURE-II EVALUATION SHEET FOR THE MICRO PROJECT
Roll. no Enrollment No. Student name Marks out of 6 for performance in group activity Marks out of 4 for performance in group activity Total out of 10
INTRODUCTION The railway reservation system facilitates the passengers to enquire about the trains available on the basis of source and destination, booking and cancellation of tickets, enquire about the status of the booked ticket, etc. The aim of case study is to design and develop a database maintaining the records of different trains, train status, and passengers. The record of train includes its number, name, source, destination, and days on which it is available, whereas record of train status includes dates for which tickets can be booked, total number of seats available, and number of seats already booked.
ER Diagram of Railway Reservation System
Passenger:- PNR Primary Key P_name Attributes Age Attributes Gender Attributes Seat_no. Attributes Reserve_status Attributes U_id Foreign key references to U_id of User table. Status_id Foreign key references to Status_id of Train_Status Table. Train_id Foreign key references to Train_id of Train Table Station:-
Route:- Step 2 : Mapping of Attributes a. Simple Attributes Simple attributes which cannot be divided into subparts. Example: Seat Number of passenger b. Composite Attributes Composite attributes which can be divided into subparts. Example: Passenger Name, Reservation status P_name Station_id Primary Key Station_name Attributes Arr_time Attributes Depart_time Attributes Stop no. Attributes Station_id Foreign key references to Station_id of Station table. Train_id Foreign key references to Train_id of Train Table
U_id Passenger table makes foreign key references to U_id of User table. Train_id Passenger table makes foreign key references to Train_id of Train Table Train_Status Train_id Train_status table makes foreign key references to Train_id of Train Table PNR Train_status table makes foreign key references to PNR of Passenger table. Train Route Station_i d Route table makes foreign key references to Station_id of Station table. Train_id Route table makes foreign key references to Train_id of Train Table Step 5: Identifying the relationships a. Passenger can book many tickets. Therefore the relations are 1……..N. b. Trains are associated with each Train_status
Therefore the relation is M……..1. c. Trains can route from one route. Therefore the relations are N……..1. d. Station has a set of Route. Therefore the relations are 1……..N. Conclusion In our project Railway reservation system we have stored all the information about the Trains scheduled and the users booking tickets and even status of trains, seats etc. This data base is helpful for the applications which facilitate passengers to book the train tickets and check the details of trains and their status from their place itself it avoid inconveniences of going to railway station for each and every query they get. We had considered the most important requirements only, many more feachers and details and be added to our project inorder to obtain even more user friendly applications.
