Build Your Own ASP.NET 2.0 Web Site Using C# & VB, Second Edition

Creating the Remaining Tables

Let’s create the rest of the database tables. Apply the process you used to build

the Employee table to create the new data tables, using the data presented in

Table 7.2 to Table 7.6. Later in this chapter, we’ll discuss how these tables work.

For starters, though, you need to insert them into your database.

Table 7.2. The Departments table

Primary KeyAllow NullIdentitySQL Data TypeColumn Name

YesNoYesintDepartmentID

NoNoNonvarchar(50)Department

Table 7.3. The HelpDesk table

Primary KeyAllow NullIdentitySQL Data

Type

Column Name

YesNoYesintRequestID

NoNoNointEmployeeID

NoYesNointStationNumber

NoNoNointCategoryID

NoNoNointSubjectID

NoYesNonvarchar(50)Description

NoNoNointStatusID

Table 7.4. The HelpDeskCategories table

Primary KeyAllow NullIdentitySQL Data TypeColumn Name

YesNoYesintCategoryID

NoNoNonvarchar(50)Category

Table 7.5. The HelpDeskSubjects table

Primary KeyAllow NullIdentitySQL Data TypeColumn Name

YesNoYesintSubjectID

NoNoNonvarchar(50)Subject

271

Creating the Remaining Tables