General Computer Accessory Company: In General Computer Accessory Company (GCAC), each product (described by product number (primary key (PK)), description, and cost) comprises at least one component and can comprise many components (described by component number (PK), description, and unit of measure), and each component is used to make zero to many products. GCAC keeps track of the quantities of products and components in the manufacturing process. In addition, a component can be used to make zero to many other components and a component can consist of zero to many other components. GCAC also keeps track of how many components go into making some other components. Draw an ER diagram using Draw.io Links to an external site.and insert the diagram (as an image file exported from the drawing tool; ensure that the image is a clean ER diagram that does not contain non-relevant details such as tool background and buttons) in a file (enter your full name and assignment number on the first line of the file) and then save the file as a PDF file named "a1_GCAC-ERD_[Firstname-Lastname].pdf". Then upload the PDF file to this question. Ensure that your file format is PDF and that your name and assignment number appear on the top of the front page.

Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter8: Network Models
Section8.5: Minimum-cost Network Flow Problems
Problem 8P
icon
Related questions
Question

General Computer Accessory Company: In General Computer Accessory Company (GCAC), each product (described by product number (primary key (PK)), description, and cost) comprises at least one component and can comprise many components (described by component number (PK), description, and unit of measure), and each component is used to make zero to many products. GCAC keeps track of the quantities of products and components in the manufacturing process. In addition, a component can be used to make zero to many other components and a component can consist of zero to many other components. GCAC also keeps track of how many components go into making some other components.

Draw an ER diagram using Draw.io Links to an external site.and insert the diagram (as an image file exported from the drawing tool; ensure that the image is a clean ER diagram that does not contain non-relevant details such as tool background and buttons) in a file (enter your full name and assignment number on the first line of the file) and then save the file as a PDF file named "a1_GCAC-ERD_[Firstname-Lastname].pdf". Then upload the PDF file to this question. Ensure that your file format is PDF and that your name and assignment number appear on the top of the front page.

NOTE : The ER model is already in chegg. Can you give me different ER [CHOW'S FOOT NOTATION]

Please give proper explanation and typed answer only.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Structure chart
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning