Database Design
The Database Schema
- Transforming the logical data model into a physical relational database schema rules and guidelines:
- Each fundamental, associative, and weak entity is implemented as a separate table.
- The primary key is identified as such and implemented as an index into the table.
- Each secondary key is implemented as its own index into the table.
- Each foreign key will be implemented as such.
- Attributes will be implemented with fields.
- These fields correspond to columns in the table.