Last post Sep 12, 2013 08:25 AM by Mikesdotnetting
Sep 11, 2013 06:37 AM|Limited Compartment|LINK
Hey everyone, i am currently trying to develope a database for my PC support website. I am unsure of where exactly entities go in the four tables i believe are required to make.
The entities consist of
I believe the four tables should be of client, technician, problem and record. But i dont quite understand what to put in each table and the foreign keys required in each to work.
Sep 12, 2013 08:25 AM|Mikesdotnetting|LINK
I'm going to assume that Problem Type and Problem Status are going to be pre-determined and that users won't be able to just enter anything in there. You might give an admin rights to add new problem types and statuses, but essentially, they will be a fixed
list. They need to be, so you can report on types and statuses more effectively. That being the case, this is how I would do it:
ProblemTypeId int IDENTITY PK
ProblemStatusID int IDENTITY PK
ProblemId int IDENTITY PK
ProblemTypeId int FK
ProblemStatusId int FK
TechnicianId int FK
ClientId int FK
TechnicianId int IDENTITY PK
ClientId int IDENTITY PK
--other client details
You might want to store a series of comments against a problem, in whihc case you will need a Comments table:
CommentId int IDENTITY PK
This last table may be what you mean by "Record".
Here's an article on database normalisation that may help you understand this better: http://support.microsoft.com/kb/283878