The Database Schema

The development team decides to use the Microsoft SQL 2000 database for the bulletin board application.

The database contains two tables, Users and Query. The Users table stores login information, such as username and password. The field names and datatypes are listed in Table 9.1.

Table 9.1: Field Names and Their Datatypes In the Users Table

Field Name	Datatype
UserName	char (10)
Password	char (10)

The BulletinBoard database contains another table called Query, which contains the information about the message posted by users. The field names and their datatypes are listed in Table 9.2.

Table 9.2: Field Names and Their Datatypes in the Query Table

Field Name	Datatype
UserID	char (10)
Email	char (10)
Subject	char (50)
Message	varchar (1000)
PostingDate	datetime (8)

Figure 9.6 shows the database schema for the BulletinBoard database.

Figure 9.6: The schema for the BulletinBoard database.