Question: 1) Find the errors in the insert statement 2) Find the errors in Constraint statement our table for starters 9 NSERT into author Kauth_jd auth
our table for starters 9 NSERT into author Kauth_jd auth name, auth_name Spot the errors in this insert statement. 1 > VALUES 1, Rice', 'Ann (2.King, Stephen 'Grafton Sue (4. Child Lee (s.Baldacci David (6'Spanis"Nicholas CREATE TABLE CHEATE TAHLE book withen. dNTENITY VARCH What problems can you spot in this create book titles statement? Look for both lovic AND syntax. Consider previous tables, consider constraints and fields you've already set up Is there anything that will cause problem? TOEFAULIN MONEYDENAULT 19 be MECHAL ARVEY Spot the error ( han in this Spet the errors in this insert atenent Let's get 6 authors in our table for starters INSERT Into author (authid auth_Iname, authafname VALUES 11, Rice l'Anna (2. King, Stephen 3. Grafton Sue) 4 Child Lee (s Baldacci David (6 Sparks Nicholas) CREATE TABLE What problems can you spot in this create book Eles statement? Look for both logic AND Syntax. Consider previous tables consider constraints and fields you've already set up. Is there anything that will cause problems CREATE TABLEDites buurtuld INI DENTITY VARCHART beth Com BRITIOUNCE otice MONEYDEFAURU pod DATE DEFLATE FEKER NE Spot the errors (Both Syntax and logic) in this constrain statement TERITABLE bockie ADE CONSTANTA FAMI LOCS Id: our table for starters 9 NSERT into author Kauth_jd auth name, auth_name Spot the errors in this insert statement. 1 > VALUES 1, Rice', 'Ann (2.King, Stephen 'Grafton Sue (4. Child Lee (s.Baldacci David (6'Spanis"Nicholas CREATE TABLE CHEATE TAHLE book withen. dNTENITY VARCH What problems can you spot in this create book titles statement? Look for both lovic AND syntax. Consider previous tables, consider constraints and fields you've already set up Is there anything that will cause problem? TOEFAULIN MONEYDENAULT 19 be MECHAL ARVEY Spot the error ( han in this Spet the errors in this insert atenent Let's get 6 authors in our table for starters INSERT Into author (authid auth_Iname, authafname VALUES 11, Rice l'Anna (2. King, Stephen 3. Grafton Sue) 4 Child Lee (s Baldacci David (6 Sparks Nicholas) CREATE TABLE What problems can you spot in this create book Eles statement? Look for both logic AND Syntax. Consider previous tables consider constraints and fields you've already set up. Is there anything that will cause problems CREATE TABLEDites buurtuld INI DENTITY VARCHART beth Com BRITIOUNCE otice MONEYDEFAURU pod DATE DEFLATE FEKER NE Spot the errors (Both Syntax and logic) in this constrain statement TERITABLE bockie ADE CONSTANTA FAMI LOCS Id
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
