Homework Opportunity No$.6$

Part I

Use the ER diagram given below to answer the following questions:

Which relationships exhibit:

a$.$ Total participation of each entity type

b$.$ Partial participation of each entity type

c$.$ Total participation of one entity type and partial participation of the second entity type Goes$-$for, Flies

Please designate the name of the relationship type as opposed to the entity types that participate in the relationship type.

Answer the following true$-$false questions.

a$.$ Each flight must have at least one reservation

b$.$ Each service must be associated with exactly one aircraft and exactly one technician

c$.$ It is possible for a reservation to be associated with more than one flight

d$.$ It is possible for a flight to have more than one connection

e$.$ The attribute Cost reflects the cost associated with the technicians performing a particular service.