Find the minimum mumber of tables required to represent the given ER diagram in relational model- b_city Ac_no Balance b_name Assets Account branch Account Branch Depositor Loan branch Customer Borrower Loan C_city C_street L_no Amt C_name

Create a relational model with foreign and primary keys

Consider the following ER diagram. Attribute 'Code' is an example of a for entity FARE. Airport_code City State Name AIRPORT Company M CAN_ LAND N Type_name Max_seats AIRPLANE TYPE TYPE N Airplane_id AIRPLANE Seat_no SEAT Scheduled_dep_time Dep_time Total_no_of_seats Customer_name DEPARTS N N ASSIGNED DEPARTURE AIRPORT N ARRIVES ARRIVAL AIRPORT RESERVATION N Cphone Scheduled_arr_time Arr_time N N INSTANCE_OF Instances N Number Airline Weekdays Restrictions Amount Code No_of_avail_seats LEG_INSTANCE Date Leg_no FLIGHT LEG N LEGS FLIGHT 1 FARES N FARE Notes: A LEG (segment) is a nonstop portion of a flight A LEG_INSTANCE is a particular occurrence of a LEG on a particular date.

Map the EER diagram to a relational schema and transform the relation into 3NF