please answer only questions 47, 48,59, 60, 66, 84, 93, 101 Chapter 13 ERD for S

Question

please answer only questions 47, 48,59, 60, 66, 84, 93, 101

Chapter 13 ERD for SQL Project IRPORT 10,0) Arrival FLIGHT Contains Coptains P?LOT 1,n) 1,1 EQUIP TYPE Used in DEPARTURE Used in TICKET rvoived in Possess 1.n) RESERVATION Has PASSENGER An ERD for the SQL Project Example 1. On April 1, Ole Olson (assigned confirmation number 1 in the Reservation table) reserved two tickets on Flight Number 15, scheduled to leave on April 1, and return vi Number 329 on April 1 and April 10. As a result, the Passenger table shows Ole Olson a ltin- erary Number 1, and his wife, Lena Olson, as ltinerary Number 2. Observe that both have Confirmation Number 1 since both reservations were booked at the same time by Ole. Observe that the Ticket Table shows that Ole (itinerary Number 1) is sitting in Seat 10D on Flight Num- ber 15 and in Seat 12D in Flight Number 329. On the other hand, his wife, Lena (ltinera Number 2) is sitting in Seat 10E on Flight Number 15 and in Seat 12E in Flight Number 329. a Flight Example 2. On April 17, Andy Anderson (assigned confirmation number 6 in the Reserva- tion table) reserved two tickets on Flight Number 102, scheduled to leave on April 18. As a result, the Passenger table shows Andy Anderson as ltinerary Number 12, and his wife, Gloria Anderson, as ltinerary Number 13. Once again, observe that both have Confirmation Number6 since both reservations were booked at the same time by Andy. Observe that the Ticket table shows that Andy (Itinerary Number 12) has a ticket on Flight Number 102, with seat

Explanation / Answer

Please post other questions in a sepratae thread, as i can not answer all the questions in one thread. Please understand. Do comment if sometihng is not clear in this answer. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.