Database Schema

The development team will use the existing Microsoft SQL 2000 database for the Worldwide Search application. Figure 21.9 shows the database schema for the InfoTools database.

Figure 21.9: The schema for the InfoTools database.

The database schema includes the following tables:

• SalesInteractions. This table contains the details of the sales interaction between the clients and the sales executives, such as the name of the client, the minutes of the meeting, client requirements, and interaction date.

• SearchCollections. This table contains collection details, such as the name, type, and description of the collection, and other parameters, such as the title, body, extensions, URLPath, and type parameters.

Database Structure

The structure of the SalesInteractions table is shown in Figure 21.10.

Figure 21.10: The design of the SalesInteractions table.

The SalesInteractions table contains InteractionID as the primary key column, with an AutoNumber datatype. Other fields in this table are InteractionDate, ClientName, SalesPerson, MinutesOfMeeting, and Requirements.

The structure of the second table, named SearchCollections, is shown in Figure 21.11. The administrator will use this table. The fields in this table are CollectionName, CollectionType, CollectionDesc, TypeOfCol, Title, Body, URLPath, Extensions, and Recursing. The CollectionName field is the primary key.

Figure 21.11: The design of the SearchCollections table.