DATABASE //

QUESTION: Draw (ER) Diagram by following the UML below and mention Multiplicity weather it's *..1 or 1..* or 1..1 besides Identify relationship types.

( Check The Example ER To Understand My Point)

SOLVED ER Diagram EXAMPLE:

NEED YOUR OWN ANSWER PLEASE! Thanks

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) Supervises 0..1 Supervisor 0..10 Staff Supervisee 1..1 Registers Business Owner 0...1 0...1 BOwns Manages 0..100 0..* 1..* Views PropertyForRent Client 0.. 0.. 1... 1..1 1..1 1..1 POwns Associated With Holds States 0..1 0.. 0.. 1..1 Private Owner Lease Preference