Design Framework
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:
- Analyzing Requirements
- Collecting and Analyzing Data
- Identifying Entities and Attributes
- Designing Tables
- Determining Unique Attributes (Designing Databases)
- Developing a Set of Rules (Designing Databases)
- Establishing Relationships between Objects
- Planning Security (Designing Databases)
- Naming Objects