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
234567899
2017-11-16
10012
ccc
zxxcvv
234
345678900
2017-11-13
502
10013
eee
ytuytu
454577777
2017-10-13
503
10014
jjj
werewr
231
436436885
2017-10-23
10015
sdg
rtyrtyry
275
676446322
2017-10-30
504
10016
ewt
erterter
789
232317879
2017-12-30
“Supplier” table: Primary key = Supp -code, No Foreign key
Supp -code
Supp -lname
Supp -fname
Supp -Initial
Supp -areacode
Supp -phone
xxx
F
123445678
yyy
B
234567890
zzz
X
345678901
The above database contains an error in the data. Identify and describe this error.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here