Go Up to Designing Databases
The following steps provide a framework for designing a database:
- Determine the information requirements for the database by interviewing prospective users.
- Analyze the real-world objects that you want to model in your database. Organize the objects into entities and attributes and make a list.
- Map the entities and attributes to InterBase tables and columns.
- Determine an attribute that will uniquely identify each object.
- Develop a set of rules that govern how each table is accessed, populated, and modified.
- Establish relationships between the objects (tables and columns).
- Plan database security.
The following sections describe each of these steps in more detail.