Transforming an E-R Model
General Rules Governing Relationships among Tables
1. All primary keys must be defined as NOT NULL.
2. Define all foreign keys to conform to the following requirements for binary relationships.
- 1:M Relationship
- M:N Relationship
- 1:1 Relationship
-
- Weak Entity