Write the SQL to create a table based on one of your entities. Be sure to identify the primary key as part of your SQL syntax

Create a view. Write the SQL to create a view on the base table

Show the base tables with data. Show a base table along with six rows containing data for three entities in your entity-relationship diagram. (Display each table in the form of an MS Word table.)

SQL Insert/Update/Delete Manipulation.

Insert a row. Write a SQL query to insert a row into one of your base tables

Update a row. Write a SQL query to change a data value in the inserted row.

Delete a row. Write a SQL query to delete the row from your base table

SQL Data Queries. write the SQL query AND show the output using the data in your base tables.

Write a SQL query using a comparison operator (e.g., =, >, <)

Write a SQL query using the “AND” or “OR” operator

Write a SQL query using the “BETWEEN” or “LIKE” operator

Write a SQL query using a built-in function

Write a SQL query using the “GROUP BY” clause

Write a SQL join query using two or more base tables

Write a SQL subquery using two or more base tables