Conceptual Design Methodology

1. Define the problem and define database objectives

2. Analyze current database, assess user requirements, and create data model

3. Design data structures (tables, fields, field specifications, establish keys)

4. Establish table relationships

5. Clarify business rules critical to database design (e.g., required fields, validation rules)

6. Determine and establish user views of data

7. Review data integrity and reiterate design methodology

Previous slide

Next slide

Back to first slide

View graphic version