Question

Question 3 10 pts What errors are in the following create statement? CREATE AUTHORS (AUTHOR NUM CHAR(10) PRIMARY KEY, 1ST NAME CHAR(20), LAST NAME CHAR(20), ADDRESS CHAR(100) NOT EMPTY.CITY CHAR(20), STATE CHAR(10), ZIP CHAR(6) HTML Editora B I VA -A I ET 1 1 1 XX, SE - E o N V PRVO T 12pt

this for my class SQL language

Answer 1

question no 3:

main error

keyword TABLE is missing after CREATE

the first occurence '(' has not been balances i.e parenthesis have not been closed at the end

minor errors

column names appear to have spaces between them

4. Answer:

INSERT INTO contact (plot_no,lname,fname,address,state,pincode) VALUES (127,'Schultz' 'Leah','123 Main Street Stephenville','TX',76401)

note:

if u have to ignore data in a column just dont mention that colums in column names

underlying assumption is that you have a

table name contact

with column names plot_no, lname, fname, address, state, pincode

replace the data in above command to get your desired O/P:

skeleton code is

INSERT INTO contact (column_names ) VALUES (column_values)