Foreign Key used for database system.

1. Please describe the concept of (1) Schema, (2) Primary Key and Foreign Key used for database system.
2. Except the listed 6 algebra operations such as select, join/intersection, project, … is there any potential algebra operand may/can be used for database management processing.

Sample Solution