- Urgent Please Help 1 (346.58 KiB) Viewed 46 times
URGENT PLEASE HELP!
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
URGENT PLEASE HELP!
URGENT PLEASE HELP!
- Question (C3): (3 marks) Below is a database with 2 tables - Product, Vendor: Product table: primary key = Product_Num, foreign key = Vendor_Num Product_Num Product_decription Vendor_Num 1336 Claw Hammer 123 1337 Dawn Thunder 111 1338 Plastic Thistle 111 1339 Hasty Exiter 123 1340 Vanilla Splitter 134 1341 X-filer 123 Vendor table: primary key = Vendor_Num, no foreign key Vendor_Num Vendor_company Vendor_contact_phone Vendor_contact_person Country 111 X-Hardware 61-532-234156 Peter Fleming British 123 ABC_Machinery 62-333-123455 Joan Stenoma Italian The above database contains an error in the data. Identify and describe this error.
- Question (C3): (3 marks) Below is a database with 2 tables - Product, Vendor: Product table: primary key = Product_Num, foreign key = Vendor_Num Product_Num Product_decription Vendor_Num 1336 Claw Hammer 123 1337 Dawn Thunder 111 1338 Plastic Thistle 111 1339 Hasty Exiter 123 1340 Vanilla Splitter 134 1341 X-filer 123 Vendor table: primary key = Vendor_Num, no foreign key Vendor_Num Vendor_company Vendor_contact_phone Vendor_contact_person Country 111 X-Hardware 61-532-234156 Peter Fleming British 123 ABC_Machinery 62-333-123455 Joan Stenoma Italian The above database contains an error in the data. Identify and describe this error.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!