The relational database below contains two related tables - “Supplier” and “Product”: “Product” table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod...


The relational database below contains two related tables - “Supplier” and “Product”:



“Product” table:  Primary key = Prod-code,  Foreign key = Supp-code















































































Prod-code




Prod -name




Prod -desript




Prod -stocktype




Prod -stocklevel




Prod -expireDate




Supp-code



10010



aaa



qwert



615



123445677



2017-11-14



501



10011



bbb



asdfgg



615



234567899



2017-11-16



501



10012



ccc



zxxcvv



234



345678900



2017-11-13



502



10013



eee



ytuytu



234



454577777



2017-10-13



503



10014



jjj



werewr



231



436436885



2017-10-23



503



10015



sdg



rtyrtyry



275



676446322



2017-10-30



504



10016



ewt



erterter



789



232317879



2017-12-30



501




“Supplier” table: Primary key = Supp -code,  No Foreign key







































Supp -code




Supp -lname




Supp -fname




Supp -Initial




Supp -areacode




Supp -phone



501



xxx



qwert



F



615



123445678



502



yyy



asdfgg



B



615



234567890



503



zzz



zxxcvv



X



234



345678901



The above database contains an error in the data. Identify and describe this error.



Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here