Question: Question 2 The relational database below contains two related tables - Supplier and Product: Product table: Primary key = Prod-code, Foreign key = Supp-code Prod-cod

Question 2 The relational database below contains two related tables - "Supplier" and "Product": "Product" table: Primary key = Prod-code, Foreign key = Supp-code Prod-cod Prod Prod -d Prod -sto Prod -sto Prod -expi Supp-cod -nam esript cktype cklevel reDate e 10010 aaa qwert 615 10011 bbb asdfgg 615 10012 CCC ZXXCVV 234 12344567 2017-11-1 501 7 4 23456789 2017-11-1 501 9 6 34567890 2017-11-1502 0 3 45457777 2017-10-1503 7 3 43643688 2017-10-2503 5 3 67644632 2017-10-3504 2 0 10013 eee ytuytu 234 10014 jjj werewr 231 10015 sdg rtyrtyry 275 10016 ewt erterter 789 23231787 2017-12-3501 9 0 "Supplier" table: Primary key = Supp-code, No Foreign key Supp-code Supp-Inam Supp-fnam Supp-Initial Supp-areacod Supp-phon e e e e XXX F 501 502 503 qwert asdfgg yyy B 615 615 234 123445678 234567890 345678901 ZZZ ZXXCVV X a. From the above data, what type of relationships: one-to-one, one-to- many, or many-to-many, do t he above two tables have? Explain your answer. (3 marks) b. The above database contains an error in the data. Identify and describe this error
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
