كود بلغة SQL ل Airport database مع تعديل normalization

لدي ER diagram جاهز بالاضافة الى relations واحتاج تعديل على normalization

وكتابة كود SQL باستخدام Oracle live SQL على الويب. وبالنهاية ارسال سكرين شوت للاوتبوت tables

وهذه المتطلبات:

Use Oracle to create the normalized tables

Populate your tables with 5 rows at least

• Design and implement at least 4 queries.

As specified below

- Data Retrieval Queries with Select (total of 4 Queries)

Where Order By Group By Aggregate functions Subquery Join query

Note:

- You are free to mix between all those clauses in one or more query but you have to use them all so the total number of queries for Data Retrieval Queries with Select in the end will be 4.

- Using select all (*) is NOT accepted.

• - All schemas before and after normalization.

- All SQL statements of:

Creating tables

Inserting data in tables

Queries.

- Screenshots from oracle of all the tables after population and queries results.