8 46 assume that at pvf each product described by

This preview shows page 2 - 4 out of 4 pages.

8. 46 Assume that at PVF each product (described by Product No., Description, and Cost)is composed of at least three components (described by Component No., Description, andUnit of Measure), and components are used to make one or many products (i.e., must be used in at least one product). In addition, assume that components are used to make other components and that raw materials are also considered to be components. In both cases ofcomponents being used to make products and components being used to make other components, we need to keep track of how many components go into making something
else. Draw an E-R diagram for this situation and place minimum and maximum cardinalities on the diagram.8. 47 Much like PVF’s sale of products, stock brokerages sell stocks, and the prices are continually changing. Draw an E-R diagram that takes into account the changing nature of stock prices.8. 48 If you were going to develop a computer-based tool to help an analyst interview user and quickly and easily create and edit E-R diagrams, what type of tool would you build? What features would it have? How would it work?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture