Tugas Basis Data I ( Praktikum 6 )

Gambar 1

Support Operators

 Gambar 2

Error generated by undened function or type combination

 Gambar 3

Error generated by undened operator or type combination

 Gambar 4

Large Objects (BLOBs)

 Gambar 5

 Subqueries can replace some joins

Gambar 6

Correlated subquery

Gambar 7

NOT IN and Subqueries with NULL Values

Gambar 8

Customers who have no orders

Gambar 9

IN query rewritten using ANY and EXISTS

Gambar 10

NOT IN query rewritten using ALL and EXISTS

Gambar 11

Simulating outer joins

Gambar 12

Subqueries with UPDATE and DELETE

Gambar 13

Table creation with SELECT

TUGAS BASIS DATA I

         Praktikum 6

Nama   :  Eka Agusti Ningsih

Kelas    :  1 B / Teknik Informatika

NPM     :  1103058