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

sid

The ID of a supplier supplying a part. sid together with pid form the primary key.

pid

The ID of the supplied part. sid together with pid form the primary key.

cost

The cost (as a number) charged by the supplier