Sunday, February 19, 2012

Database Design

I am creating a knowledge base. I want the user to be able to choose a category such as Hardware, Software, Etc. then I want them to be able to choose what type of software such as word, excel, ets.

It will then display in a gridview problems, solutions, submitted by, last updated, and review date.

The gridview will allow users to update solutions and I would also like the ability for technicians to be able to add new Problems/solutions.

What would be the best way to handle this?

Any tips are appreciated.

Rick

As far as the database design goes, I would make it relational using the structure similar to the one below.

Table: Categories
Columns: CatID, Category

Table: CatTypes
Columns: CatTypeID, CatID, CatType

Table: KB_FAQ
Columns: KB_ID, Problem, Solution, UserID, LastUpdated, LastReviewed

Table: KB_CatTypes
Columns: KB_ID, CatTypeID

Table: Users
Columns: UserID, UserName, FirstName, LastName, Password

|||In Visual Studion Web Developer express, where do I setup relationships?|||I figured it out. Thanks for all your help.

No comments:

Post a Comment