ASSET-CONNECTION DIAGRAM NEEDS TO BE DRAWN BECAUSE DATABASE MANAGEMENT OPERATON LESSON.

Draw the asset-correlation diagrams corresponding to the situations given in the requirement analyses below.

1. A bank stores account information belonging to its customers:

a. There are customer number, name, surname, phone number (work, home and mobile), address and customer type (individual or corporate) information for each customer.

b. There are account number, IBAN number, account opening date, account type (foreign currency, TL), account status (active or passive) and balance amount information for each account.

c. Every customer has at least one account. Each account must belong to a customer, either individually or institutionally. Any account can be opened for multiple customers as a joint account.

2. An airline company is switching to automation:

a. Every aircraft in the company's fleet is registered with a code number. In addition, the brand, model, passenger capacity and range information of this aircraft are also stored. Not all aircraft are in active use, some may be under maintenance/repair.

b. Every flight has a number. The departure and destination points of this flight are obvious. In addition, it is clear which aircraft will perform this flight with the date and time.

c. Each passenger is given a number by the company to be used on all flights with that company. In addition, the name, surname, phone number (work, home and mobile) and address of that passenger are also stored.

d. All flights operated by a passenger can be easily accessed through the relationship between flight and passenger information. Dec.

e. There may be more than one passenger on a flight. At least one passenger must be present on a flight. A passenger's

he must have made at least one flight. A passenger may have participated in more than one flight.

f. A plane can make more than one flight. An aircraft may not be used on some flights. There must be a plane belonging to a flight.