The Database Schema

As mentioned earlier, the development team has decided to use a Microsoft SQL 2000 database for the Knowledge Bank application. Figure 12.9 shows the database schema for the KnowledgeBank database.

Figure 12.9: The schema for the KnowledgeBank database.

The database schema includes the following two tables:

• Articles. This table contains the details of uploaded articles, such as article ID, title, author name, and category.

• Logins. This table contains login details, such as user ID and password. It also contains the directory name and the permission to delete files for a particular user.

Database Structure

The design of the Articles table is shown in Figure 12.10.

Figure 12.10: The design of the Articles table.

The Articles table contains ArticleID as the primary key column, and its data type is AutoNumber. The other fields in this table are ArticleTitle, DateOfUpload, Author, Category, Description, Keywords, Verified, VersionOfArticle, FileName, ResearchCenter, and UploadedBy.

The database contains another table called Logins, which is used by the administrator. The Logins table contains UserID as the primary key column. The other fields in this table are Password, DirectoryName, Status, and DeletePermission. The design of the Logins table is shown in Figure 12.11.

Figure 12.11: The design of the Logins table.