Discuss how you would maintain this as a materialized view and under what circumstances you would be able to maintain the view without having to access the underlying base tables Part and Supplier.

Question

Assume that we also have a table for suppliers:
Supplier (supplierNo, partNo, price)
and a view SupplierParts, which contains the distinct part numbers that are supplied by at least one supplier:

Answer 1

CREATE VIEW SupplierParts (partNo)
AS SELECT DISTINCT partNo
FROM Supplier s, Part p
WHERE s.partNo = p.partNo;