DATABASE //

QUESTION: Identify relationship types by following the UML Diagram below:

Example:

Staff Manages PropertyForRent

PrivateOwner Owns PropertyForRent

PropertyForRent AssociatedWith Lease

HR SUPPLIERS P. SUPPLIER_ID VARCHAR2 (55 BYTE) - STOCK_ID VARCHAR2 (55 BYTE) SUPPLIER_NAME VARCHAR2 (55 BYTE) SUPPLIER CITY VARCHAR2 (55 BYTE) SUPPLIER_STREET VARCHAR2 (56 BYTE) SUPPLIER_PCODE VARCHAR2 (55 BYTE) SUPPLIER EMAIL VARCHAR2 (55 BYTE) - SUPPLIER_PHONE VARCHAR2 (55 BYTE) SUPPLIERS_PK (SUPPLIER_ID) HR STOCK P"STOCK_ID VARCHAR2 (55 BYTE) ISBN VARCHAR2 (55 BYTE) AUTHOR_NAME VARCHAR2 (55 BYTE) TITLE NAME VARCHAR2 (55 BYTE) PUBLISHER_NAME VARCHAR2 (55 BYTE) PUBLISHED_YEAR VARCHAR2 (56 BYTE) * SUPPLIER_ID VARCHAR2 (56 BYTE) RETAIL_PRICE VARCHAR2 (55 BYTE) STOCK_PK (STOCK_ID) HR RETURNS PRETURN_ID VARCHAR2 (55 BYTE) ITEM_ID VARCHAR2 (56 BYTE) STOCK_ID VARCHAR2 (55 BYTE) RETAIL_PRICE VARCHAR2 (56 BYTE) RETURNS_PK (RETURN_ID) HR ORDERS P - ORDER_ID VARCHAR2 (56 BYTE) * CUSTOMER_ID VARCHAR2 (56 BYTE) ORDER DATE VARCHAR2 (56 BYTE) * CREDIT CARD NUMB VARCHAR2 (55 BYTE) - CREDIT_CARD_EXPIRY VARCHAR2(55 BYTE) ORDERS_PK (ORDER_ID) HR.ORDER_ITEMS P.ITEM_ID VARCHAR2 (55 BYTE) ORDER_ID VARCHAR2 (55 BYTE) - STOCK_ID VARCHAR2 (56 BYTE) . ISBN VARCHAR2 (55 BYTE) - SUPPLIER_ID VARCHAR2 (55 BYTE) RETAIL_PRICE VARCHAR2 (55 BYTE) - QTY_SOLD VARCHAR2 (55 BYTE) ORDER_ITEMS_PK (ITEM_ID) HR CUSTOMERS P" CUSTOMER_ID VARCHAR2 (55 BYTE) FIRST_NAME VARCHAR2 (56 BYTE) LAST_NAME VARCHAR2 (55 BYTE) CUSTOMER_CITY VARCHAR2 (56 BYTE) CUSTOMER_STREET VARCHAR2 (56 BYTE) CUSTOMER_PCODE VARCHAR2 (56 BYTE) CUSTOMER_EMAIL VARCHAR2 (66 BYTE) CUSTOMER_PHONE VARCHAR2 (56 BYTE) CUSTOMERS_PK (CUSTOMER_ID)