Answer:
- Print the values days of bottles.
- Display total number of bottles collecting.
- Display the payout for this transaction.
Explanation:
Program:-
DEPOSIT_PER_BOTTLE = 0.10
another = "Y"
while another=="Y":
print("Input Values 7 days of bottles:")
total = 0
for I in range(7):
collected_bottles = int(input())
total += collected_bottles
payout = total*DEPOSIT_PER_BOTTLE
print("Total number of bottles collected: {:,}".format(total))
print("Payout for this transaction $%.2f"%payout)
another = input("Do you want to complete another transaction? ").upper()
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.