Entity keys:
Primary key:
A candidate key to uniquely identify the entity set
Foreign key:
Identifies the relationship between entities.
1.4 Candidate key:
A minimal super key, meaning it has the least possible number of attributes to still be a super key. An entity set may have more than one candidate key.
1.5 Super key: A set of attributes (one or more) that together define an entity in an entity set.
2.Relationships:
A relationship between two entities signifies that the two entities are associated with each other somehow. It explains how entities act upon each other or are associated with each other.
For Example, the named student might register for a course. The two entities would be the student and the course, and the relationship depicted is the act of enrolling, connecting the two entities in that way. Relationships are typically shown as diamonds or labels directly on the connecting lines.
Recursive relationship: The same entity participates more than once in the relationship.