Create an relational data model to show how you would track

Assignment Help Database Management System

Reference no: EM131614857

Assignment

A manufacturing company produces products. The following product information is stored: product name, 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.

Create an Relational Data Model to show how you would track this information.

Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality.

ASSUMPTIONS

· 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.

Reference no: EM131614857

Questions Cloud

What type of architecture new payroll application should use : Explain what type of architecture the new payroll application should use and why. Identify what types of technology will be involved in the architecture?

Discuss one distinct approach to criminal justice : Discuss one distinct approach to criminal justice that each of the model nations exemplifies - that is an approach that is distinct from the other five nations

Discuss racial discrimination in the criminal justice system : explains how Barack Obama talks about there's more injustice in the South Africans Americans tend to live there). According to Peruzzi

Problem related to the traffic on highway : Due to roadwork ahead, the traffic on a highway slows linearly from 55 miles/hour to 15 miles/hour over a 2000-foot stretch of road, then crawls along.

Create an relational data model to show how you would track : Create an Relational Data Model to show how you would track this information. A component does not have to be associated with a supplier.

Have you felt fear of being a victim of terrorist attack : What types of terrorist attacks do you think are the most effective. Why. Be specific.

Have you ever been accused of not listening : Have you ever felt ignored by someone who claimed or even appeared to be listening but really was not? Have you ever been accused of not listening

Explain what principle you believe is the most essential : Discussion: Input Design- Explain what principle you believe is the MOST essential in developing an input design, and justify your choice.

What were some of your first jobs : What were some of your first jobs? How much did you make? What did you like to do in your free time? What do you do now

User Account

All Pages