Your Task

This database has only been implemented partially.

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

PublisherID 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.

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

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

For example:

Test Result

SELECT type, name, tbl$\_$name, rootpage FROM sqlite$\_$master WHERE type$=$'table' AND name $=$ 'Publishers'; type name tbl$\_$name rootpage

$----------------------------------------$

table Publishers Publishers $4$