ASSESSMENT 5: QUERY AND UPDATE DATABASES USING SQL - ITC556 Database Systems

ITC556
Database Systems
ASSESSMENT 5
QUERY AND UPDATE DATABASES USING SQL
Student Name: Karunakar Burugula
Student ID: 11613503

Karunakar Burugula 11613503
Table of Contents
Part A-DML............................................................................................................................................2
Query1...............................................................................................................................................2
Query2...............................................................................................................................................3
Query3...............................................................................................................................................4
Query4...............................................................................................................................................5
Query5...............................................................................................................................................6
Query6...............................................................................................................................................7
Query 7..............................................................................................................................................8
Query 8............................................................................................................................................10
Query 9............................................................................................................................................11
Part B-DDL...........................................................................................................................................12
Query1.............................................................................................................................................12
Query2.............................................................................................................................................13
Query3.............................................................................................................................................14
1

Karunakar Burugula 11613503
List of figure
Figure 1:Screenshot 1............................................................................................................................3
Figure 2: Query 1...................................................................................................................................3
Figure 3: screenshot 2...........................................................................................................................4
Figure 4: Query 2...................................................................................................................................4
Figure 5: Screenshot 3...........................................................................................................................5
Figure 6: Query 3...................................................................................................................................5
Figure 7: Screenshot 4...........................................................................................................................6
Figure 8: Query 4...................................................................................................................................6
Figure 9: Screenshot 5...........................................................................................................................7
Figure 10: Query 5.................................................................................................................................7
Figure 11: Screenshot 6.........................................................................................................................8
Figure 12: Query 6.................................................................................................................................8
Figure 13: Screenshot 7.........................................................................................................................9
Figure 14: Query 7...............................................................................................................................10
Figure 15: Screenshot 8.......................................................................................................................11
Figure 16: Query 8...............................................................................................................................11
Figure 17: Screenshot 9.......................................................................................................................12
Figure 18: Query 9...............................................................................................................................12
Figure 19: Screenshot 10.....................................................................................................................13
Figure 20: DDL-Query 1.......................................................................................................................13
Figure 21: Screenshot 11.....................................................................................................................14
Figure 22: DDL-Query 2.......................................................................................................................14
Figure 23: Screenshot 12.....................................................................................................................15
Figure 24: DDL-Query 3.......................................................................................................................15
2

Karunakar Burugula 11613503
Part A-DML
Query1
Select * FROM assignment5.product where assignment5.product.P_CODE LIKE '22%'
Figure 1:Screenshot 1
Figure 2: Query 1
3