ITC556 - Database Systems: Assessment 5 - Query and Update Databases using SQL

ITC556 - Database Systems
Assessment 5-Query and update databases using SQL
1

Table of Contents
Part A- DML....................................................................................................................................4
Q-1)..............................................................................................................................................4
Q-2)..............................................................................................................................................4
Q-3)..............................................................................................................................................5
Q-4)..............................................................................................................................................5
Q-5)..............................................................................................................................................5
Q-6)..............................................................................................................................................6
Q-7)..............................................................................................................................................7
Q-8)..............................................................................................................................................7
Q 9)..............................................................................................................................................8
Part B- DDL.....................................................................................................................................9
Q-1)..............................................................................................................................................9
Q-2)............................................................................................................................................10
Q-3)............................................................................................................................................10
List of Figures
Figure 1- Query1............................................................................................................................4
Figure 2- Query1 Result Generated.............................................................................................4
Figure 3- Query 2...........................................................................................................................4
Figure 4- Query2 Result Generated.............................................................................................4
Figure 5- Query 3...........................................................................................................................5
Figure 6- Query3 Result Generated.............................................................................................5
Figure 7- Query 4...........................................................................................................................5
Figure 8- Query 4 Result...............................................................................................................5
Figure 9- Query 5...........................................................................................................................6
Figure 10- Query 5 Result Generated..........................................................................................6
Figure 11- Query 6.........................................................................................................................6
Figure 12- Query 6 Result Generated..........................................................................................6
Figure 13- Query 7.........................................................................................................................7
Figure 14- Query 7 Result Generated..........................................................................................7
Figure 15- Query 8.........................................................................................................................7
Figure 16- Query 8 Result Generated..........................................................................................8
Figure 17- Query 9.........................................................................................................................8
Figure 18- Query 9 Result Generated..........................................................................................8
2

Figure 20- Part B Query 1.............................................................................................................9
Figure 21- Part B Query 1 Result.................................................................................................9
Figure 22- Part B Query 2...........................................................................................................10
Figure 23- Part B Query 2 Result...............................................................................................10
Figure 24- Part B Query 3...........................................................................................................10
Figure 25- Part B Query 3 Result...............................................................................................11
3

Part A- DML
Q-1)
Select * FROM product AS pro where pro.P_CODE LIKE "22%";
Figure 1- Query1
Figure 2- Query1 Result Generated
Q-2)
Select * FROM vendor AS ven where ven.V_AREACODE= 615
Figure 3- Query 2
Figure 4- Query2 Result Generated
4