I have a case scenario where a customer can book accommodation or flight only or both.
I have modeled the accommodation part, however i am making things complex by over-thinking how stuff works in real life.
What i have thought is that a customer cannot book a flight because it is referring to a whole aircraft, very unlikely. Therefore i thought that a customer books a flight seat.
The following is what i have done so far, but i have made it too complex.
Can someone guide me to make this simpler? Could i merge flight_seat with flight and aircraft? please help