A manufacturing company produces products. The following product information is stored: product name, identifier product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. For supplier the system kept supplier id unique, supplier name, contact and supplied items. A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components.
Added by Pablo G.
Close
Step 1
We have three main entities: Product, Component, and Supplier. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 93 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Draw an entity relationship diagram (ERD) for the following situation: Whenever new patients are seen for the first time, they complete a patient information form that asks for their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients can only be signed up with one carrier, but they must be signed up to be seen by the doctor. Each time a patient visits the doctor, an insurance claim is sent to the carrier for payment. The claim must contain information about the visit, such as the date, purpose, and cost. It would be possible for a patient to submit two claims on the same day.
Aarya B.
Draw an ERD, EERD, and RS for the following database system. This is a parts color order tracker. We have a list of parts. Parts are tracked by Part ID number and Part name. We have a list of color options. Colors are tracked by Color ID number and Color name. Parts come in multiple color options. Colors can be applied to more than one part. Include PK, FK, CPK.
Akash M.
Draw an ERD, using Chen notation, that models the requirements for a University database. You may add details to your ERD if they seem necessary and don't conflict with the given requirements. State your additional assumptions. Students have a unique ID. Students may take several courses. Students remain in the system even if they are not currently enrolled. Courses have sections. Sections have an ID, but it is only unique if concatenated with the Course ID. Students attend one section of a course. Students earn a grade for each course they attend. Instructors must teach one or more courses.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD