DATABASE //

QUESTION: Identify and associate attributes with entity or relationship types

i. It is important to note whether an attribute is simple or composite.

Solved EXAMPLE from different UML:

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) Tables Attributes Staff staffNo, name (composite: fName, IName), position, sex, DOB Property For Rent property No, address (composite: street, city, postcode), type, rooms, rent PrivateOwner ownerNo, name (composite: fName, IName), address, telNo Business Owner ownerNo, bName, bType, address, telNo, contactName Client clientNo, name (composite: fName, IName), telNo, eMail Preference prefType, maxRent leaseNo, paymentMethod, deposit (derived as PropertyForRent.rent*2), Lease depositPaid, rentStart, rentFinish, duration (derived as rentFinish rentStart)