Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DATABASE // QUESTION: Identify relationship types by following the UML Diagram below: Solved Relationship Types Example from different UML: Staff Manages PropertyForRent PrivateOwner Owns PropertyForRent

DATABASE //

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

image text in transcribed

Solved Relationship Types Example from different UML:

Staff Manages PropertyForRent

PrivateOwner Owns PropertyForRent

PropertyForRent AssociatedWith Lease

SON HR SUPPLIERS SUPPLER_ID VARCHAR2(55 BYTE) "STOCK_ID VARCHAR(55 BYTE) SUPPLIER_NAME VARCHAR2(56 BYTE) SUPPLIER_CITY VARCHAR2(55 BYTE) SUPPLER STREET VARCHAR2 (56 BYTE) SUPPLIER_PCODE VARCHAR2(55 BYTE) SUPPLIER_EMAIL VARCHAR2 (56 BYTE) SUPPLIER_PHONE VARCHAR2(55 BYTE) SUPPLIERS_PK (SUPPLER_ID) HR STOCK STOCK_ID VARCHAR2(56 BYTE) VARCHAR2 (56 BYTE) AUTHOR_NAME VARCHAR2(56 BYTE) TITLE_NAME VARCHAR2(55 BYTE) PUBLISHER NAME VARCHAR2(55 BYTE) PUBLISHED_YEAR VARCHAR2(55 BYTE) - SUPPLER ID VARCHAR2(55 BYTE) RETAIL PRICE VARCHAR2(55 BYTE) STOCK_PK (STOCK_ID) HR RETURNS RETURN_ID VARCHAR2(55 BYTE) ITEMID VARCHAR2(55 BYTE) "STOCK_ID VARCHAR2 (56 BYTE) RETAIL PRICE VARCHAR2(56 BYTE) RETURNS_PK (RETURN_ID) HR ORDERS P" ORDER_ID VARCHAR BYTE) * CUSTOMERUD VARCHAR25 BYTE) ORDER DATE VARCHAR25 BYTE) * CREDIT_CARD_NUMB VARCHAR25 BYTE) CREDIT CARD_EXPIRY VARCHAR BYTE) ORDERS_PK (ORDER_ID) HR.ORDER_ITEMS P.ITEM_ID VARCHAR2 (56 BYTE) ORDERUD VARCHAR2 056 BYTE) STOCK_ID VARCHAR2 (56 BYTE) VARCHAR2 (56 BYTE) - SUPPLIER_ID VARCHAR2 (56 BYTE) RETAIL PRICE VARCHAR2 (56 BYTE) - QTY_SOLD VARCHAR2(55 BYTE) ORDER ITEMS_PKOTEM_ID) -ISON HR CUSTOMERS P" CUSTOMER_ID VARCHAR2(55 BYTE) FIRST_NAME VARCHAR2(55 BYTE) LAST_NAME VARCHAR2(55 BYTE) CUSTOMER_CITY VARCHAR2 (55 BYTE) CUSTOMER_STREET VARCHAR2 (55 BYTE) CUSTOMER_PCODE VARCHAR2(55 BYTE) CUSTOMER_EMAIL VARCHAR2 (56 BYTE) CUSTOMER_PHONE VARCHAR2 (56 BYTE) CUSTOMERS PK CUSTOMER_ID)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions