database design and SQL query optimization

1. Overview

2. Database design Principles

1) familiar with the requirements

2) Develop a database that conforms to the specifications

3) Audit Database design

In addition to auditing the logical issues in database design, the audit team should also focus on whether the data dictionary is detailed and understandable, whether the data table structure is redundant, and suggests changes.

3. Database Design Code

1) Naming conventions

2) clarify the relationship between the entity and the data table

3) A data table cannot have neither a primary key nor a foreign key

4) Basic table features

5) must meet the first second paradigm, as far as possible to meet the third paradigm

database design and SQL query optimization