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.

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:

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