Domain of Sample Exercise 2:
The Supplier-Parts-Catalogue Domain
Tables and fields:
The Suppliers table
sid
The supplier's ID as a number. It is the primary key.
sname
The supplier's name as a string
address
The supplier's address as a string
The Parts table
pid
The part's ID as a number. It is the primary key.
pname
The part's name as a string
color
The part's color as a string
The Catalog table
The ID of a supplier supplying a part. sid together with pid form the primary key.
The ID of the supplied part. sid together with pid form the primary key.
cost
The cost (as a number) charged by the supplier