Your Task

This database has only been implemented partially.

Write the SQL statement to Create the Authors table. The following information is important:

AuthorID should be an autoincrement field of type INTEGER and must be set to be the primary key for this table.

Name should be of type TEXT and we should not allow null values.

Surname should be of type TEXT and we should not allow null values.

Note: It is deemed very important to capitalise table and field names exactly as shown in the design.

For example:

Test	Result
SELECT type, name, tbl_name, rootpage FROM sqlite_master WHERE type='table' AND name = 'Authors';	type name tbl_name rootpage ---------- ---------- ---------- ---------- table Authors Authors 4