A database is an organized repository for structured data. A database management system (DBMS) creates and manages that data, supporting efficient access, categorization, normalization, transactions, and security. section 4.1
In the board-game API, the database stores names, publication years, player ranges, play times, minimum ages, complexity, mechanics, ratings, and related information. The web API mediates access so websites, mobile apps, management tools, and analysis services do not connect directly to the database server. section 1.1.2
A practical database setup includes:
- Create the MyBGList database in SQL Server Management Studio using the default core settings. section 4.2.4
- Add an instance-level login and a database-level user, then assign appropriate role membership for API access. section 4.2.4
- Repeat the setup for production, keeping production credentials separate from development credentials. section 12.3.6
Figure 1.3 Several board-game-related web applications and services fed by a single MyBGList web API
Use the architecture diagram to trace how one database serves multiple applications through a web API. section 1.1.2
