Unit: Databases- Spring 2024: Write your SQL scripts clearly showing the commands you have used with the keys, data types and field lengths: Organisational Summative Report Assignment, UCD, Ireland

Task 2 Implementation

a) Create all of the normalised tables from task 1b) in SQL. 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 organisation as identified in task 1a).
• Why the use of ER modelling 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).