Adding Attributes to Eval Tables

This section contains illustrations of the tables in the Eval database and describes the purpose of each table column and its attributes. Notice that the database designers use the new Unicode data types introduced with SQL Server 7.0, nchar, nvarchar, and ntext, to facilitate the globalization of the database. Because the Unicode data types use 2 bytes for every character, the database requires more disk storage space than an equivalent non-Unicode database; therefore, the Eval database designers have defined as few character columns as possible. Synthetic primary keys (identity columns with an int data type) are used instead of character data columns throughout the database; they save space and also improve performance. To accommodate data entries in any language, the character fields are longer. The Location and Person tables contain address fields with names that are meaningful in an international setting and include Region and Country columns.

The Eval database contains the following tables: