Answer:
Hi Riahroo! This is a good question on the concept of relational databases.
We can normalize the relations as follows:
Flight
(flightnumber (unique), flighttime, airline_id, departure_city, arrival_city, passenger_id, pilot_id, airplane_id)
has_one_and_belongs_to :airline
has_many :passengers
has_one :pilot
Itinerary(passenger_id, flight_id)
Belongs_to
Passenger_details
(passengername (unique), gender, date_of_birth)
has_many :flights
Pilot
(pilotname (unique), gender, date_of_birth)
has_many :flights
airline(airlinename)
airplane(planeID, type, seats))
Explanation:
To normalize a relation, we have to remove any redundancies from the relationships between database objects/tables and simplify the structure. This also means simplifying many-to-many relationships. In this question, we see there is a many-to-many relationship between flights and passengers. To resolve this we can introduce a join table which simplifies this relationship to a one-to-many between the objects.
In the context of in-house software development options, a firm that enhances a commercial package by adding custom features and configuring it for a particular industry is called a(n) value-added reseller (VAR).
<h3>What is VAR?</h3>
A Value-Added Reseller (VAR) is a company that depends on the production of other firms. They improve the commission of a product or add a unique feature on it and sell that part as a whole apart good. The disadvantage of this practice relies on not maintaining control over the manufacturing prices since these things do not understand what precisely will be delivered next.
To learn more about VAR, refer to:
brainly.com/question/22679694
#SPJ4
PUT THAT COOKIE DOWN!!!!!
