From the above ER Diagram:

Create a

SQL section containing:

a. A basic SQL statement to create your database (5 pts);

b. A basic SQL statement to create one of your tables, including the columns, primary and foreign keys, data type, length, nullot null and, if applicable, default values. [Note: Select a table from your design that consists of three or more columns.] (5 pts);

c. A basic SQL statement to display all data in the table you created in step 3.b (above) and sorted by one of the columns (5 pts);

d. A basic SQL statement to display all data meeting a certain condition in the table you created in step 3.b (above) (5 pts);

e. A single SQL statement that displays data from/across two of your tables.

[Note: Refer to your database design documentation.] (5 pts); Present the information for this step in a two-column format. The first column should be used to describe the action. The second column should contain the complete SQL statement using the correct syntax.

E-R diagram for the above given table: Chore Actus Minutes iption ChoreAssoco dClient ChoreEstmated Min CategoryD oryCos Chore Status ChoreCategorylD Chore Chore Categories ChoreDesc ripton ChorelD has Prot: ProfiMonth ProftAmount Cient CienContact No have Person Person D PersonSalary Person Email