(Solved) : Lab 4 Relational Schema 40 Marks Individual Lab Submission Assume Hired Design Database Ai Q26506181 . . . .

Lab 4: Relational Schema (40 marks) Individual Lab SubmissionAssume you have been hired to design a database for an airport.Your first task is to organize the information about all theairplanes stationed and maintained at the airport. The relevantinformation is as follows: · Every airplane has a registrationnumber, and each airplane is of a specific model. · The airportaccommodates a number of airplane models, and each model isidentified by a model number (e.g., DC-10) and has a capacity and aweight. · A number of technicians work at the airport. You need tostore the name, social security number (SSN), address, phonenumber, and