DATABASE //

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

SOLVED ER Diagram EXAMPLE:

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) 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