Reposting for a second opinion:

Would someone please assist in writing some SQL code for the attached entity relationship diagram? Below you will find what is needed for the code:

1.SQL Data Definition Language (DDL) and Base Tables with Data/Views.

Create a base table. 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.)

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

3.SQL Data Queries. For 3.1 through 3.7, 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.

Supplier Confirmation Number delivery date Customer Number Delivery Confirmation Number Delivery Date Customer Number Order Detail Delivery Confirmation Number PO Number Product Catalog Number Customer Number Order Detail Catalog Number PO Number Quantity Order PO Number Order Date Authorization Code Purchasing Authorization Code Department Code Department Department Code Supplier Confirmation Number delivery date Customer Number Delivery Confirmation Number Delivery Date Customer Number Order Detail Delivery Confirmation Number PO Number Product Catalog Number Customer Number Order Detail Catalog Number PO Number Quantity Order PO Number Order Date Authorization Code Purchasing Authorization Code Department Code Department Department Code