Database design
Database design is the process of defining a database’s structures, relationships, constraints, and organization to meet data requirements.
Grokking Relational Database Design
Database design is the process of defining a database's structures, relationships, constraints, and organization to meet data requirements.
- How it is used
- Guides the transformation of data requirements into a structured relational database for an application.
- How deep it goes
- Walks through requirement gathering, structural planning, implementation, testing, normalization, and constraints rather than stopping at definitions.
- Examples
- Uses an online-store inventory spreadsheet and a mixed customer-product table to expose missing requirements and data anomalies.
- What you can do after
- Build it from scratch by gathering requirements, planning structure, implementing the database, and validating it against a design blueprint.
Read how Grokking Relational Database Design explains database design →
Build Financial Software with Generative AI (From Scratch)
Database design is the process of structuring data, schemas, relationships, and access requirements for a database system.
- How it is used
- Structures ACH data for reliable storage, querying, API integration, and MVP delivery.
- How deep it goes
- Walks through tables, foreign keys, parser updates, tests, and iterative refinement, while deferring detailed database implementation choices.
- Examples
- Uses ACH files, the ach_files table, PostgreSQL, parser routines, foreign keys, unit tests, and an integrated MVP.
- What you can do after
- Build an iterative PostgreSQL data layer that supports ACH parsing, APIs, integrity checks, tests, and MVP integration.
Read how Build Financial Software with Generative AI (From Scratch) explains database design →
Related concepts
- minimal productpart of · A minimum viable product is an early product version with the minimum functionality needed to satisfy essential requirements or test its value with intended users.
- requirements analysishas part · Requirements analysis is the systematic process of eliciting, clarifying, assessing, and documenting the needs and constraints a system or product must satisfy.
- ChatGPTused by · ChatGPT is OpenAI’s conversational AI service, which lets users interact with generative AI models and related tools through natural-language prompts.
- MySQL Workbenchimplemented by · MySQL Workbench is a graphical environment for designing, developing, modeling, querying, and administering MySQL databases.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.