![]() Base your design on the following business rules: The dealership sells both new and used cars, and it operates a service facility (see Figure B.2). Product( ProdID, ProdName, QtyOnHand) PK=ProdIDĬompSupp( CompID, SuppID) PK = CompID, SuppIDīuild( CompID, ProdID, QtyOfComp) PK= CompID, ProdID Figure B.1 by A. A product cannot exist without components.Ĭomponent( CompID, CompName, Description) PK=CompID. ![]() A component does not have to be associated with a product.A component does not have to be associated with a supplier.A supplier can exist without providing components.Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Use Figure B.1 for this exercise.Ĭreate an ERD to show how you would track this information. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Each component can be supplied by one or more suppliers. These products are made up of many components. The following product information is stored: product name, product ID and quantity on hand. Appendix B Sample ERD Exercises Exercise 1 ManufacturerĪ manufacturing company produces products.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |