ITIS213

database

i want all 24 blank

Question 26 6 Points A company purchases items from a number of different vendors, who then ship the items to the manufacturer. The items are assembled into products that are sold to customers who order the products. Each customer's order may include one or more lines corresponding to the products appearing in that order. The following points may clarify the problem A supplier may supply many terms. Each item is supplied by any number of supplers. Each item must be used in at least one product and may be used in many products. Conversely, each product must use one or more items - A suppiler may send many shipments. On the other hand, each shipment must be sent by exactly one supplier A shipment must include one or more) items. An item may be included in several shipments. A customer may submit any number of orders. However, each order must be submitted by exactly one customer An order must request one for more products. A given product may not be requested on ary order, or may be requested in one or more orders. For simplicity, the ER diagram has been developed as shown below, what you are required to do is to write the proper multiplicities for each relationshi. AB Product Item itembo Usedey Order ordero prodo Requested M.N UV Supplies KI Supplier supplier OR Submits A WX Customer customer Shipment ship Sends A. Bis Blank 1 Blank 2 CD is Blank 3. Blank 4 E.Fis Blank Blank 6 G.His Blank 7 Blank 8 Jis Blank 9 Blank 10 KL Blank 11.Blank 12 M.Nis Blank 13. Blank 14 0. Pis Blank 15. Blank 16 O... Ris Blank 17 Blank 18 S... Tis Blank 19. Blank 20 U..Vis Blank 21 Blank 22 w.xis Blank 23. Blank 24 Mint in the above blanks write eller: 2.1., or specjsc number Blank 1 Add your answer Blank 2 Add your answer Blank 3 Add your answer Blank 4 Add your answer Blanks Add your answer Rank AG