Building an entity model for use in the rest of the book

Websites and web services usually need to work with data in a relational database or another data store. In this section, we will define an entity data model for the Northwind database stored in SQL Server or SQLite. It will be used in most of the apps that we create in subsequent chapters.

Creating the Northwind database

The script files to create the Northwind database for SQLite and SQL Server are different. The script for SQL Server creates 13 tables as well as related views and stored procedures. The script for SQLite is a simplified version that only creates 10 tables because SQLite does not support as many features. The main projects in this book only need those 10 tables, so you can complete every task in this book with either database.

The SQL scripts are found at the following link: https://github.com/markjprice/cs13net9/tree/main/scripts/sql-scripts.

There are multiple SQL scripts to choose from, as...