Slip 22 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Train (train_no, train_name, depart_time, arrival_time,source_stn, dest_stn) Passenger (p_id,p_name,address,age, gender) Relation between Train and Passenger is Many to Many with seat_no, amount and date as descriptive attribute. Constraint: Primary key, seat_no should not be null. Consider the above tables and execute the following queries: 1. Display passenger names and their seat no’s of train “sahyadri express”. 2. Display details of train in which “Mr. Roy” is travelling from “Pune” to “Uruli Kanchan”.
0 Comments