Task 2 Implementation

a) Create all of the normalized tables from task 1b) in SQL. Unit: Databases - Spring 2024: Write Your SQL Scripts Clearly Showing The Commands You Have Used With The Keys, Data Types And Field Lengths. Show the finished tables and ensure they are consistent with the tables you created earlier in the design phase.

b) Enter a range of sample data in all tables (minimum THREE (3) rows per table) to show that your tables are capable of holding appropriate data.

c) Write FIVE (5) queries that demonstrate your knowledge and understanding of SQL. SQL statements to be used should include all of the following commands:

Select, Update, Delete, From, Where, And, Count, Ascending, and Order By. Ensure TWO (2) of your queries use multiple commands. TWO (2) of the queries should join TWO (2) or more tables together.

Task 3 – Evaluation

Provide a written assessment and evaluation of the work you have undertaken. Your discussion should include:

• How the database you have created meets the data and information requirements of your chosen organization as identified in task 1a).
• Why the use of ER modeling is an essential part of the design of a database solution, and how you used it to identify and rectify any design and implementation issues you encountered.
• Any assumptions that you have made.
• How the database supports the transactions that you identified in task 1a).