Ask
Login
0
83kviews
Draw E-R diagram for online Ticket Railway Reservation System. Convert E-R diagram into tables.
written 9.4 years ago by gravatar for teamques10 teamques10 ★ 70k modified 3.8 years ago by gravatar for sagarkolekar sagarkolekar ★ 11k
database management systems
ADD COMMENT EDIT
1 Answer
5
1.7kviews
written 9.4 years ago by gravatar for teamques10 teamques10 ★ 70k •   modified 9.4 years ago

Step 1: E-R Diagram

enter image description here

Step 2: Converting the E-R Diagram into Tables

a. Converting entity to table and attribute to columns

USER

U_id Primary Key
Password  
Security_quest  

Passenger

PNR Primary Key
P_name  
Age  
Gender  
Seat_no.  
Reserve_status  
U_id Foreign key references to U_id of User table.
Status_id Foreign key references to …

Create a free account to keep reading this post.

and 2 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.