10
Insertion: an Example
prodName is foreign key in Product.name
Suppose
database got corrupted and we need to fix it:
gadgets
100
gizmo
category
listPrice
name
225
Smith
camera
80
Smith
gizmo
200
John
camera
price
buyerName
prodName
Task:
insert in Product all prodNames from Purchase
Product
Product(name, listPrice, category)
Purchase(prodName, buyerName, price)
Purchase