Database Management SystemTU Board 2025
a) What is inner join? Perform inner join to find the customer names who are going on flight to 'South Wales': Customer (Cid, Name, Address, Age, Email) Booking(Cid(FK), FlightID(FK), BookedDate)…
10a) What is inner join? Perform inner join to find the customer names who are going on flight to 'South Wales': Customer (Cid, Name, Address, Age, Email) Booking(Cid(FK), FlightID(FK), BookedDate) Flight(FlightID, AirplaneCode, DepartureTime, Destination, Duration) b) What are unary and ternary relationship? Write with examples.
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Define transaction. Describe ACID properties with example. [1+4]TU Board 20265Explain physical data independence and logical data independence. [2.5+2.5]TU Board 20265What is stored procedure? Describe statement level trigger and multi row enabled trigger? [1+4]TU Board 20265Define schedule and serializability with example. How can you test the serializability? [2+3]TU Board 20265What is data model? What are its types? [1+4]TU Board 20265Define query processing and steps in query processing. [1+4]TU Board 20265