Database Design

Database Design

1. I. Conceptual Design

   • 1.Database Analysis and Requirements
   • 2.Entity Relationship modeling and normalization
   • 3.Datamodel Verification
   • 4.Distributed Database Design

2. II. DBMS software Selection

   • Cost
   • DBMS features and tools
   • Underlying model
   • Portability
   • DBMS hardware Requirements

3. III. Logical Design

   • Create the logical Data Model
   • Validating the logical data model using normalization
   • Assigning and validating integrity constraints
   • Merging local models constructed for differing parts of the database
   • Reviewing the logical data model with the user

4. IV. Physical Design