1. SQL Data Definition Language.
1.1. Create a base table. Write the SQL to create a table based on one ofyour entities. Be sure to identify the primary key as part
of your SQL syntax.
1.2. Create a view. Write the SQL to create a view on the base table.
2. SQL Data Manipulation Language (insert, update, and delete).
2.3. Delete a row. Write a SQL query to delete the row from your base table.
3.1. Write a SQL query using a comparison operator (e.g.,
3.2. Write a SQL query using the “AND” or “OR” operator.
3.3. Write a SQL query using the “BETWEEN” or “LIKE” operator.
3.5. Write a SQL query using the “GROUP BY” clause.
3.7. Write a SQL subquery using two or more base tables.
1. For the database concept you have chosen for Parts1 and 2, provide the following:
Display your entities/tables in first normal form
Display your entities/tables in second normalform
Display your entities/tables in third normalform
You may need to rework your relationships to achieve this. For each form, provide the tables and the defining associations.
2. Next, define three (3) business processes that will access a particular table and attribute. For example, “A customer login
process will require accessing the CUSTOMER table and retrieving the CustomerID and CustomerPassword attributes”. Provide
detail on what the business process is and who is involved. For each business process, provide the SQL that would need to run
to access it in the firstl secondI and third normal forms you provided in the previous section.
3. Finally, choose a database optimization strategy, whether physical or logical, and describe how it could potentially benefit
any or all ofyour normalform examples. Provide a comparison between a use case with and without this strategy