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

 1) Find the errors in the insert statement2) Find the errors
in Constraint statement our table for starters 9 NSERT into author Kauth_jd
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 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!