A database is an organized collection of data. A database management system (DBMS) provides mechanisms for storing, organizing, retrieving and modifying data. Today’s most popular DBMSs manage relational databases, which organize data simply as tables with rows and columns.
Some popular proprietary DBMSs are Microsoft SQL Server, Oracle, Sybase and IBM DB2. PostgreSQL and MySQL are popular open-source DBMSs that can be downloaded and used freely by anyone. In this chapter, we use Microsoft’s free SQL Server Express, which is installed with Visual Studio. It can also be downloaded separately from Microsoft (
SQL Server Express provides many features of Microsoft’s full (fee-based) ...