Winter 2021
January 21st/22nd, 2021
CSC 343: Week 2 Worksheet
Define the following important terms:
1. Key
2. Candidate Key
3. Primary Key
4. Superkey (or Super Key)
5. Referential Integrity
Using an illustration, draw the relationships between the different types of keys above (1-4):
Winter 2021 January 21st/22nd, 2021
Given the following relations:
Suppliers (sid: integer, sname: string, address: string)
Parts (pid: integer, pname: string, colour: string) Catalog (sid: integer, pid: integer, cost: real)
do the following:
1. identify (by underlining) the primary key in each relation.
2. identify any foreign keys in the relations (you may state them under this line).
3. identify at least two possible domain-type constraints among the relations (you may state them under this line).