Database Design
Articles about the database design process
-
Database Design: Overview
Databases exist because of the need to change data into information -
Database Lifecycle
Like everything else, databases have a finite lifespan -
Database Design Phase 1: Analysis
Defining problems, possibilities, constraints, objectives and agreeing on the scope -
Database Design Phase 2: Conceptual Design
Requirements identified in the previous phase are used as the basis to develop the new system -
Database Design Phase 2: Logical and Physical Design
After conceptual design, it's time to convert to the logical and physical design -
Database Design Phase 3: Implementation
Install the DBMS and load the data -
Database Design Phase 4: Testing
Testing performance, security, and integrity of the data -
Database Design Phase 5: Operation
Rolling out for everyday use -
Database Design Phase 6: Maintenance
Maintaining indexes, optimizing tables, adding and removing users, changing passwords -
Database Design Example Phase 1: Analysis
Walking through the database design process with a step-by-step example -
Database Design Example Phase 2: Design
Poet Circle logical design and identifying the initial entities -
Database Design Example Phase 3: Implementation
Creating the Poet's Circle tables -
Database Design Example Phases 4-6: Testing, Operation and Maintenance
Testing, rolling out and maintenance of the Poet's Circle database.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.