Slip 24 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Bus(bus_no, capacity, depo_name) Route(Route_no, source, destination, no_of_stations) Relation between Bus and Route is Many to One. Constraint: Bus capacity should be greater than 0, depo_name should not be null. Consider the above tables and execute the following queries: 1. List all buses at depo “kothrud”. 2. Delete bus details whose number is “MH12HL7812”.
0 Comments