Database design and optimization
Show the output for the natural join on tables, TRUCK and BASE
Based on Figure P3.17’s database (split into 3 parts):
– Show the output for the natural join on tables, TRUCK and BASE
– Show the output for the right outer join on tables, TRUCK and BASE
– Show the output for the left outer join on tables, TRUCK and BASE
Problem 25 (says ERD, but use exclusively a Chen diagram only),
“(Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT, that a MODEL references many AIRCRAFT but that each AIRCRAFT references a single MODEL, and so on.)
”
Text: Database Systems: Design, Implementation, & Management