Assignment $1($Check Flights Master & Transactio

Hide Assignment Information

Instructions

Create a Word document and describe how you checked data integrity for each of the following. Use headings to show the table and the type of check $($e$.$g$.,$ Mandatory$).$

Include your SQL statements, SQL results image and your conclusion.

Below are the tables, and types of checks.

AirportsStaging: Check Mandatory, Data$-$Type $($appropriate length$),$ Unique IATA$\_$Codes

Note: The Flat File Import inserts the NULL designation for empty cells. This means that you can use $"$IS NULL" to find rows where a mandatory cblumn is null.

FlightsStaging $$ Check all of the following:

Mandatory: Conduct for all the mandatory fields listed in the IC$-$Jan $31$ solution.

Note: The Import Data tool inserts an empty string for empty cells. This means that you can use $"=""($e$.$g$.,"=$ two single quotes $")$ to find rows where a mandatory column is empty.

Airline Foreign$-$key constraint: Check to see if all AIRLINE codes in