Design Framework

From InterBase
Jump to: navigation, search

Go Up to Designing Databases


The following steps provide a framework for designing a database:

  1. Determine the information requirements for the database by interviewing prospective users.
  2. Analyze the real-world objects that you want to model in your database. Organize the objects into entities and attributes and make a list.
  3. Map the entities and attributes to InterBase tables and columns.
  4. Determine an attribute that will uniquely identify each object.
  5. Develop a set of rules that govern how each table is accessed, populated, and modified.
  6. Establish relationships between the objects (tables and columns).
  7. Plan database security.

The following sections describe each of these steps in more detail.

Advance To: