Consider the following extract of an E-R diagram for Demi's Goods (DG) Pty Ltd and answer the following questions:

a) There is an attribute missing from the Shipping Document entity - what is the attribute? Explain with reference to the diagram. (2 marks)

b) The diagram is only a partial extract of the full system used by DG Pty Ltd. EXCLUDING Suppliers and Sales Price entities, what other two entities could be added to the diagram? How would this entity be related to other entities that are included in the diagram? (3 marks

consists of triggers Goods Movement Goods Receipt PK GR ID Date Item ID Date triggered by Item ID Received by Quantity Goods Receipt PO ID Purchase Qty Purchase Price Purchase Total Shipping ID PK Item ID Sales Price ID Description Sale Total FK Sales Price ID Quantity _ tracked by . Cost Prlce 4 Cost Prrce Quantity on Value hand Quantity triggered by Reserved Reorder Point On order requested by appears on picks triggers requests /+\\ A , Pickling Line Shipping Line Sales Order LIne PK Pickin ID PK Shi in ID PK Sales ID 9 pp 9 PK Item ID Item ID uantit Quantity Q y part of part of part of consists of consists of consists of triggers triggers Picking Slip Sales Order _ 4 Shipping Document trlggered by PK Sales ID PK Picking ID PK Shipping ID Customer ID FK Sales ID ? Order Date Date Picking ID Shipping Date Status (not Shipping Date icked, artiali . Sicked p ty FK Shipped by completed) FK Picked by triggered by placed by places Customer PK Customer ID Address Name