Relational database management system

As explained in Building Web APIs with ASP.NET Core

A relational database management system is software that stores structured data in related tables and supports querying and transactional updates.

A relational database management system (RDBMS) stores data in tables with fixed schemas of rows and columns. Each table represents a record type, such as Users, Roles, BoardGames, or Comments. section 4.1.1

Relationships between records use primary keys that uniquely identify records and can be stored as references in other tables. This table-oriented design keeps related data structured and consistent. section 4.1.1 section 4.1.2

For the board-game API, the relational approach fits because:

• Record types are expected to keep consistent structures, so new author columns can apply to existing records. section 4.1.2
• ASP.NET Core supports SQL databases, while EF Core provides established support through database providers. section 4.1.2
• Common provider-supported products include SQL Server, SQLite, PostgreSQL, MySQL, and Oracle DB. section 4.1.2

Board-game data model

A table-oriented design can separate Users, Roles, BoardGames, and Comments into record types, connecting related records through primary-key references rather than embedding all related information in one document. section 4.1.1

Figure 4.1 MyBGList database schema diagram for a table-oriented SQL database

Use the schema diagram to inspect how the board-game API's entities fit into a table-oriented SQL design. section 4.1.1

How Building Web APIs with ASP.NET Core covers it

How deep it goes

Defines tables, fixed schemas, and primary-key relationships, then stops short of product-specific implementation.

Examples

Uses Users, Roles, BoardGames, Comments, and authors as concrete table and schema examples.

What you can do after

Evaluate a relational design and select an EF Core-supported database product for the board-game API.

How it connects

Connects relational databases with SQL, primary keys, NoSQL databases, ASP.NET Core, EF Core, and database providers.

liveBookmanning.com

Read Building Web APIs with ASP.NET Core on liveBook Get the book at manning.com

Also explained in

• 

  liveBookmanning.com
  Data Analysis with LLMsA relational database management system is software that stores, manages, and processes relational data organized in tables.
• 

  liveBookmanning.com
  Java Persistence with Spring Data and Hibernate epubA relational database management system (RDBMS) stores and manages structured data in related tables and provides relational query and transaction processing.
• 

  liveBookmanning.com
  The Well-Grounded Python Developer: How the pros use Python and FlaskA relational database management system is software that stores and manages data in related tables and provides operations for defining and querying that data.
• 

  liveBookmanning.com
  Learn SQL in a Month of LunchesA relational database management system is software that stores, organizes, and manages structured data represented in related tables.
• 

  liveBookmanning.com
  Rust Servers, Services, and AppsA relational database is a database that organizes data into related tables with defined schemas and relationships.

Compare how 6 books explain relational database management system →

Related concepts

• SQL Serverincludes · SQL Server is Microsoft's relational database management system for storing, querying, transforming, and managing structured data.
• object-oriented programmingcontrasts with · Object-oriented programming is a programming paradigm that organizes software around objects combining state and behavior, commonly using encapsulation, classes, inheritance, or polymorphism.
• Elasticsearchcontrasts with · Elasticsearch is a distributed search and analytics engine that indexes data for searching, retrieval, and analysis.
• databasekind of · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
• SQLuses · SQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
• NoSQL databasealternative to · A NoSQL database is a database system organized primarily around nonrelational data models or access patterns rather than relational tables.

This explainer was generated by Manning's knowledge graph from the text of Building Web APIs with ASP.NET Core. The section links point to the parts of the book it draws on.