ALTER TABLE AdditionalCargo ALTER COLUMN Weight SET NOT NULL;
ALTER TABLE AdditionalCargo ALTER COLUMN Height SET NOT NULL;
ALTER TABLE AdditionalCargo ALTER COLUMN Width SET NOT NULL;
ALTER TABLE AdditionalCargo ALTER COLUMN Length SET NOT NULL;
ALTER TABLE AdditionalCargo ALTER COLUMN FlightID SET NOT NULL;

ALTER TABLE Airplane ALTER COLUMN ModelID SET NOT NULL;
ALTER TABLE Airplane ALTER COLUMN RegistrationNumber SET NOT NULL;
ALTER TABLE Airplane ALTER COLUMN ManufactureDate SET NOT NULL;
ALTER TABLE Airplane ALTER COLUMN Active SET NOT NULL;
ALTER TABLE Airplane ALTER COLUMN TotalFlightHours SET NOT NULL;
ALTER TABLE Airplane ALTER COLUMN LastMaintenanceID SET NOT NULL;

ALTER TABLE AirplaneModel ALTER COLUMN Model SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN Manufacturer SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN NumberOfSeats SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN Width SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN Height SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN Length SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN EmptyWeight SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN EmptyWeight SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN MaxFlightDistance SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN FuelCapacity SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN RequiredAttendants SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN SeatColumns SET NOT NULL;
ALTER TABLE AirplaneModel ALTER COLUMN SeatRows SET NOT NULL;

ALTER TABLE Airport ALTER COLUMN Code SET NOT NULL;
ALTER TABLE Airport ALTER COLUMN Name SET NOT NULL;
ALTER TABLE Airport ALTER COLUMN CityID SET NOT NULL;
ALTER TABLE Airport ALTER COLUMN TimezoneID SET NOT NULL;

ALTER TABLE AirportEmployee ALTER COLUMN AirportID SET NOT NULL;

ALTER TABLE Baggage ALTER COLUMN BaggageTypeID SET NOT NULL;
ALTER TABLE Baggage ALTER COLUMN Weight SET NOT NULL;
ALTER TABLE Baggage ALTER COLUMN Height SET NOT NULL;
ALTER TABLE Baggage ALTER COLUMN Length SET NOT NULL;
ALTER TABLE Baggage ALTER COLUMN Width SET NOT NULL;
ALTER TABLE Baggage ALTER COLUMN TicketID SET NOT NULL;

ALTER TABLE BaggageHandler ALTER COLUMN ShiftTypeID SET NOT NULL;

ALTER TABLE BaggageStatus ALTER COLUMN BaggageStatusTypeID SET NOT NULL;
ALTER TABLE BaggageStatus ALTER COLUMN TimeStamp SET NOT NULL;
ALTER TABLE BaggageStatus ALTER COLUMN AirportID SET NOT NULL;

ALTER TABLE BaggageStatusType ALTER COLUMN Name SET NOT NULL;

ALTER TABLE BaggageType ALTER COLUMN Name SET NOT NULL;
ALTER TABLE BaggageType ALTER COLUMN MaxWeight SET NOT NULL;
ALTER TABLE BaggageType ALTER COLUMN MaxHeight SET NOT NULL;
ALTER TABLE BaggageType ALTER COLUMN MaxWidth SET NOT NULL;
ALTER TABLE BaggageType ALTER COLUMN MaxLength SET NOT NULL;
ALTER TABLE BaggageType ALTER COLUMN Price SET NOT NULL;

ALTER TABLE CanceledFlight ALTER COLUMN Reason SET NOT NULL;
ALTER TABLE CanceledFlight ALTER COLUMN CancellationTime SET NOT NULL;

ALTER TABLE City ALTER COLUMN Name SET NOT NULL;
ALTER TABLE City ALTER COLUMN CountryID SET NOT NULL;
ALTER TABLE City ALTER COLUMN TimeZoneID SET NOT NULL;

ALTER TABLE Country ALTER COLUMN Name SET NOT NULL;

ALTER TABLE Employee ALTER COLUMN Name SET NOT NULL;
ALTER TABLE Employee ALTER COLUMN Surname SET NOT NULL;
ALTER TABLE Employee ALTER COLUMN SSN SET NOT NULL;
ALTER TABLE Employee ALTER COLUMN DateOfBirth SET NOT NULL;
ALTER TABLE Employee ALTER COLUMN DateOfEmployment SET NOT NULL;
ALTER TABLE Employee ALTER COLUMN Gender SET NOT NULL;
ALTER TABLE Employee ALTER COLUMN Salary SET NOT NULL;
ALTER TABLE Employee ALTER COLUMN PhoneNumber SET NOT NULL;
ALTER TABLE Employee ALTER COLUMN Active SET NOT NULL;

ALTER TABLE Flight ALTER COLUMN FlightNumber SET NOT NULL;
ALTER TABLE Flight ALTER COLUMN Departure SET NOT NULL;
ALTER TABLE Flight ALTER COLUMN Arrival SET NOT NULL;
ALTER TABLE Flight ALTER COLUMN ScheduleID SET NOT NULL;
ALTER TABLE Flight ALTER COLUMN AirplaneID SET NOT NULL;
ALTER TABLE Flight ALTER COLUMN StatusID SET NOT NULL;
ALTER TABLE Flight ALTER COLUMN ActualGateDepartureID SET NOT NULL;
ALTER TABLE Flight ALTER COLUMN ActualGateArrivalID SET NOT NULL;
ALTER TABLE Flight ALTER COLUMN ActualDepartureSlot SET NOT NULL;
ALTER TABLE Flight ALTER COLUMN ActualArrivalSlot SET NOT NULL;

ALTER TABLE FlightAttendant ALTER COLUMN CertificationLevel SET NOT NULL;
ALTER TABLE FlightAttendant ALTER COLUMN PrimaryLanguage SET NOT NULL;
ALTER TABLE FlightAttendant ALTER COLUMN SecondaryLanguage SET NOT NULL;

ALTER TABLE FlightCertification ALTER COLUMN AirlineEmployeeID SET NOT NULL;
ALTER TABLE FlightCertification ALTER COLUMN AirplaneModelID SET NOT NULL;
ALTER TABLE FlightCertification ALTER COLUMN CertificationType SET NOT NULL;
ALTER TABLE FlightCertification ALTER COLUMN TestDate SET NOT NULL;
ALTER TABLE FlightCertification ALTER COLUMN ExpirationDate SET NOT NULL;

ALTER TABLE FlightStatus ALTER COLUMN Name SET NOT NULL;

ALTER TABLE Gate ALTER COLUMN TerminalID SET NOT NULL;
ALTER TABLE Gate ALTER COLUMN Number SET NOT NULL;
ALTER TABLE Gate ALTER COLUMN Capacity SET NOT NULL;

ALTER TABLE Item ALTER COLUMN Name SET NOT NULL;
ALTER TABLE Item ALTER COLUMN Price SET NOT NULL;

ALTER TABLE ItemsSold ALTER COLUMN Quantity SET NOT NULL;

ALTER TABLE Language ALTER COLUMN Name SET NOT NULL;

ALTER TABLE Maintenance ALTER COLUMN AirplaneID SET NOT NULL;
ALTER TABLE Maintenance ALTER COLUMN Date SET NOT NULL;

ALTER TABLE Meal ALTER COLUMN SeatClassID SET NOT NULL;
ALTER TABLE Meal ALTER COLUMN MealTypeID SET NOT NULL;

ALTER TABLE MealType ALTER COLUMN Name SET NOT NULL;

ALTER TABLE MedicalCheckup ALTER COLUMN CheckupDate SET NOT NULL;
ALTER TABLE MedicalCheckup ALTER COLUMN ExpirationDate SET NOT NULL;
ALTER TABLE MedicalCheckup ALTER COLUMN EmployeeID SET NOT NULL;

ALTER TABLE PartOnAirplane ALTER COLUMN PartTypeID SET NOT NULL;
ALTER TABLE PartOnAirplane ALTER COLUMN AirplaneID SET NOT NULL;
ALTER TABLE PartOnAirplane ALTER COLUMN InUse SET NOT NULL;

ALTER TABLE PartType ALTER COLUMN Name SET NOT NULL;
ALTER TABLE PartType ALTER COLUMN Material SET NOT NULL;
ALTER TABLE PartType ALTER COLUMN Price SET NOT NULL;
ALTER TABLE PartType ALTER COLUMN Weight SET NOT NULL;

ALTER TABLE Passenger ALTER COLUMN Name SET NOT NULL;
ALTER TABLE Passenger ALTER COLUMN Surname SET NOT NULL;
ALTER TABLE Passenger ALTER COLUMN DateOfBirth SET NOT NULL;
ALTER TABLE Passenger ALTER COLUMN Gender SET NOT NULL;
ALTER TABLE Passenger ALTER COLUMN Email SET NOT NULL;
ALTER TABLE Passenger ALTER COLUMN SSN SET NOT NULL;
ALTER TABLE Passenger ALTER COLUMN PhoneNumber SET NOT NULL;

ALTER TABLE Passport ALTER COLUMN PassengerID SET NOT NULL;
ALTER TABLE Passport ALTER COLUMN PassportNumber SET NOT NULL;
ALTER TABLE Passport ALTER COLUMN Expiration SET NOT NULL;
ALTER TABLE Passport ALTER COLUMN IssuingCountry SET NOT NULL;

ALTER TABLE Pilot ALTER COLUMN FlightHours SET NOT NULL;
ALTER TABLE Pilot ALTER COLUMN LicenceNumber SET NOT NULL;
ALTER TABLE Pilot ALTER COLUMN Rank SET NOT NULL;

ALTER TABLE PilotRank ALTER COLUMN Name SET NOT NULL;

ALTER TABLE Repair ALTER COLUMN PartOnAirplaneID SET NOT NULL;
ALTER TABLE Repair ALTER COLUMN Price SET NOT NULL;

ALTER TABLE RepairCertification ALTER COLUMN ExpirationDate SET NOT NULL;
ALTER TABLE RepairCertification ALTER COLUMN TestDate SET NOT NULL;
ALTER TABLE RepairCertification ALTER COLUMN AirplaneModelID SET NOT NULL;
ALTER TABLE RepairCertification ALTER COLUMN MechanicID SET NOT NULL;

ALTER TABLE Reservation ALTER COLUMN PassengerID SET NOT NULL;
ALTER TABLE Reservation ALTER COLUMN CreatedAt SET NOT NULL;

ALTER TABLE Runway ALTER COLUMN AirportID SET NOT NULL;
ALTER TABLE Runway ALTER COLUMN Number SET NOT NULL;
ALTER TABLE Runway ALTER COLUMN Length SET NOT NULL;
ALTER TABLE Runway ALTER COLUMN Width SET NOT NULL;
ALTER TABLE Runway ALTER COLUMN MaxWeight SET NOT NULL;

ALTER TABLE ScheduledFlight ALTER COLUMN Departure SET NOT NULL;
ALTER TABLE ScheduledFlight ALTER COLUMN Arrival SET NOT NULL;
ALTER TABLE ScheduledFlight ALTER COLUMN Distance SET NOT NULL;
ALTER TABLE ScheduledFlight ALTER COLUMN Active SET NOT NULL;

ALTER TABLE Seat ALTER COLUMN SeatConfigurationID SET NOT NULL;
ALTER TABLE Seat ALTER COLUMN FlightID SET NOT NULL;
ALTER TABLE Seat ALTER COLUMN Reserved SET NOT NULL;

ALTER TABLE SeatClass ALTER COLUMN Name SET NOT NULL;

ALTER TABLE SeatConfiguration ALTER COLUMN Number SET NOT NULL;
ALTER TABLE SeatConfiguration ALTER COLUMN Letter SET NOT NULL;
ALTER TABLE SeatConfiguration ALTER COLUMN ExitRow SET NOT NULL;
ALTER TABLE SeatConfiguration ALTER COLUMN SeatClassID SET NOT NULL;
ALTER TABLE SeatConfiguration ALTER COLUMN AirplaneModelID SET NOT NULL;
ALTER TABLE SeatConfiguration ALTER COLUMN Price SET NOT NULL;

ALTER TABLE ServedMeals ALTER COLUMN Quantity SET NOT NULL;
ALTER TABLE ServedMeals ALTER COLUMN Served SET NOT NULL;

ALTER TABLE ShiftType ALTER COLUMN Name SET NOT NULL;

ALTER TABLE Slot ALTER COLUMN GateID SET NOT NULL;
ALTER TABLE Slot ALTER COLUMN RunwayID SET NOT NULL;
ALTER TABLE Slot ALTER COLUMN Time SET NOT NULL;
ALTER TABLE Slot ALTER COLUMN DayOfWeek SET NOT NULL;
ALTER TABLE Slot ALTER COLUMN Active SET NOT NULL;

ALTER TABLE Terminal ALTER COLUMN AirportID SET NOT NULL;
ALTER TABLE Terminal ALTER COLUMN Name SET NOT NULL;
ALTER TABLE Terminal ALTER COLUMN TerminalTypeID SET NOT NULL;
ALTER TABLE Terminal ALTER COLUMN Capacity SET NOT NULL;

ALTER TABLE TerminalType ALTER COLUMN Name SET NOT NULL;

ALTER TABLE Ticket ALTER COLUMN PassengerID SET NOT NULL;
ALTER TABLE Ticket ALTER COLUMN BasePrice SET NOT NULL;
ALTER TABLE Ticket ALTER COLUMN FinalPrice SET NOT NULL;
ALTER TABLE Ticket ALTER COLUMN SeatClassID SET NOT NULL;
ALTER TABLE Ticket ALTER COLUMN TicketStatusID SET NOT NULL;
ALTER TABLE Ticket ALTER COLUMN ReservationID SET NOT NULL;
ALTER TABLE Ticket ALTER COLUMN FlightID SET NOT NULL;
ALTER TABLE Ticket ALTER COLUMN PurchaseDate SET NOT NULL;

ALTER TABLE TicketStatus ALTER COLUMN Name SET NOT NULL;

ALTER TABLE TicketingAgent ALTER COLUMN CounterNumber SET NOT NULL;

ALTER TABLE TimeZone ALTER COLUMN Name SET NOT NULL;
ALTER TABLE TimeZone ALTER COLUMN TimeZoneOffset SET NOT NULL;