Data Modelling SQL Languages Tasks 2022

Running head: DATA MODELLING & SQL LANGUAGE
Data Modelling & SQL Language
Name of the Student
Name of the University
Author’s Note

1
DATA MODELLING & SQL LANGUAGE
Table of Contents
Task 1: Structure Query Language (SQL)......................................................................................2
Answer to Question 1:.................................................................................................................2
Answer to Question 2:.................................................................................................................3
Task 2: Data Manipulation..............................................................................................................5
SQL Statement 1:.........................................................................................................................5
SQL Statement 2:.........................................................................................................................6
SQL Statement 3:.........................................................................................................................6
SQL Statement 4:.........................................................................................................................7
SQL Statement 5:.........................................................................................................................8
SQL Statement 6:.........................................................................................................................8
SQL Statement 7:.........................................................................................................................9
SQL Statement 8:.........................................................................................................................9
SQL Statement 9:.......................................................................................................................10
SQL Statement 10:.....................................................................................................................10
Task 3: Database Testing...............................................................................................................11
Answer to Question 1:...............................................................................................................11
Answer to Question 2:...............................................................................................................12
Bibliography..................................................................................................................................14

2
DATA MODELLING & SQL LANGUAGE
Task 1: Structure Query Language (SQL)
Answer to Question 1:
The UPDATE statement is basically utilized for updating either the data or rather row within a
particular table.
The syntax of the command of UPDATE is written below:
Update table-name set column-name = value where any condition;
Example
Let us imagine that there is a table which has been named as employee
Department_No Department_Name Employee_No Employee_Name
5 IT E1 Harry
10 IT E2 Tom
15 Finance E6 Kate
20 Management E8 David
25 Finance E10 Alice
For updating this table the query which can be utilized:
Update employee set Employee_No = E4 where Department_No = 15
This query will be producing the result:
Department_No Department_Name Employee_No Employee_Name
5 IT E1 Harry
10 IT E2 Tom