Database Design

The CML application requires a relational database for all information needed for the maintenance and operation of the library. The CML database is a Microsoft SQL Server 7.0 database.

The CML database has tables, stored procedures, and triggers. The following diagram shows the CML database structure.

This diagram was created using SQL Server 7.0 Enterprise Manager. The key icon in the left column of each table identifies that element as the primary key. All tables have a primary key (PK). The norm is for the primary key to be the first element in the table. The lines represent relationships among tables. You can locate the foreign key (FK), the primary key in the referring table, by finding the infinity sign. The referring table is identified with the key sign.

Columns of each table are described in individual table topics.