Question

Q. 2) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. [20 Marks] 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 of train "sahyadri express". 2. Display details of train in which "Mr. Roy" is travelling from "Pune" to "Uruli Kanchan".

Answer 1

Answer:

Please Like share comment and subscribe to my channel and don't forget to press the bell icon for latest updates of my channel