Using the ERD diagram above, explain what would happen if the minimal cardinality was changed to “1” for Raw Materials. (i.e., the relationship becomes "raw materials are used in 1 to many items.”). Please note that the current ER diagram shows the following relationship, “raw materials are used in 0 to many items.” ItemProduction_Units Sainteger(10)Ninteger( 10) NNo_of_Items_Needed integer(10) NItem_Numberitem_Numberinteger(10)Create_Date_ddateSerialinteger(10)I exact_Weight_un integer(10)ProductType_pProductDesc_dQuality_TestCost_of_Materialsvarchar(255) Nvarchar(255) Ndouble(10)Raw Materialsitem_Numberinteger(10)Material_IDinteger(10)O TypeD UnitCost_per_item numeric(19, 0)varchar(255)zzzz

Item and Raw Material have a one-to-many relationship. That means one item can have any number of…

Answered: Using the ERD diagram above, explain…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Using the ERD diagram above, explain what would happen if the minimal cardinality was changed to “1” for Raw Materials. (i.e., the relationship becomes "raw materials are used in 1 to many items.”). Please note that the current ER diagram shows the following relationship, “raw materials are used in 0 to many items.”