## Aircraft Entity ### Properties - An `Aircraft` has a property `aircraftReg` (`string`) (`pk`) - An `Aircraft` has a property `name` (`string`) - An `Aircraft` has a property `model` (`string`) - An `Aircraft` has a property `economicClassCapacity` (`int`) - An `Aircraft` has a property `executiveClassCapacity` (`int`) - An `Aircraft` has a property `firstClassCapacity` (`int`) - An `Aircraft` has a property `fuelCapacity` (`int`) (`optional`) ### Relations - An `Aircraft` has a relation `flies` (`Flight`) ## Ticket Entity ### Properties - A `Ticket` has a property `ticketNumber` (`string`) (`pk`) - A `Ticket` has a property `customerID` (`string`) (`fk`) - A `Ticket` has a property `classCode` (`string`) - A `Ticket` has a property `flightID` (`string`) (`fk`) - A `Ticket` has a property `status` (`boolean`) ### Relations - A `Ticket` has a relation `validate` (`Flight`) ## Customer Entity ### Properties - A `Customer` has a property `customerID` (`string`) (`pk`) - A `Customer` has a property `customerName` (`string`) - A `Customer` has a property `customerPhone` (`string`) - A `Customer` has a property `email` (`string`) - A `Customer` has a property `age` (`int`) (`optional`) ### Relations - A `Customer` has a relation `buys` (`Ticket`) - A `Customer` has a relation `makes booking` (`Booking`) ## Flight Entity ### Properties - A `Flight` has a property `flightID` (`string`) (`pk`) - A `Flight` has a property `depLocation` (`string`) - A `Flight` has a property `arrLocation` (`string`) - A `Flight` has a property `flightDate` (`string`) - A `Flight` has a property `depTime` (`string`) - A `Flight` has a property `arrTime` (`string`) - A `Flight` has a property `routeID` (`string`) (`optional`) ### Relations - A `Flight` has a relation `has booking` (`Booking`) ## Booking ### Properties - A `Booking` has a property `BookingID` (`string`) (`pk`) - A `Booking` has a property `customerID` (`string`) (`fk`) - A `Booking` has a property `bookingDate` (`string`) - A `Booking` has a property `flightID` (`string`) (`fk`) - A `Booking` has a property `seatNumber` (`string`) - A `Booking` has a property `classCode` (`int`) - A `Booking` has a property `status` (`boolean`) ### Relations - A `Booking` has a relation `generates flight` (`Flight`)