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

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

Table of Contents
Part A- DML....................................................................................................................................3
Part B- DDL...................................................................................................................................12
List of Figures
Figure 1- Query1 Part A..................................................................................................................3
Figure 2- Query1 Part A Result.......................................................................................................3
Figure 3- Query 2 Part A.................................................................................................................4
Figure 4- Query2 Part A Result.......................................................................................................4
Figure 5- Query 3 Part A.................................................................................................................5
Figure 6- Query3 Part A Result.......................................................................................................5
Figure 7- Query 4 Part A.................................................................................................................6
Figure 8- Query 4 Part A Result......................................................................................................6
Figure 9- Query 5 Part A.................................................................................................................7
Figure 10- Query 5 Part A Result....................................................................................................7
Figure 11- Query 6 Part A...............................................................................................................8
Figure 12- Query 6 Part A Result....................................................................................................8
Figure 13- Query 7 Part A...............................................................................................................9
Figure 14- Query 7 Part A Result....................................................................................................9
Figure 15- Query 8 Part A.............................................................................................................10
Figure 16- Query 8 Part A Result..................................................................................................10
Figure 17- Query 9 Part A.............................................................................................................11
Figure 18- Query 9 Part A Result..................................................................................................11
Figure 19- Customer Table before Query......................................................................................12
Figure 20- Query 1 Part B.............................................................................................................12
Figure 21- Query 1 Part B Result..................................................................................................12
Figure 22- Query 2 Part B.............................................................................................................13
Figure 23- Query 2 Part B Result..................................................................................................13
Figure 24- Query 2 Part B Result..................................................................................................13
Figure 25- Query 3 Part B.............................................................................................................14
Figure 26- Query 3 Part B Result..................................................................................................14
2

Part A- DML
Q-1) Select * from assignment5.product where SUBSTRING(P_CODE,1,2)='22';
Figure 1- Query1 Part A
Figure 2- Query1 Part A Result
3

Q-2) Select * from assignment5.vendor where vendor.V_AREACODE= 615;
Figure 3- Query 2 Part A
Figure 4- Query2 Part A Result
4