Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2007-11-30 : 08:16:54
|
| We are trying to track the projects we do and of course there are tasks associated with those projects. Then, as project manager, you would want to know the status of a project and/or task. We would also like to prioritize projects/tasks. FInally, if for some reason a task or project is not completed on time, we would want to know why. In other words, are there any issues. So, in light of these, I came up with the following tables: Projects, Tasks, Status Priority Issues or Notes (The notes tabel can replace issues table) and if you feel neither notes or issues table is needed, I would welcome your expert feedback on that so I can remove them. Then of course we want to know the dept that the projects / tasks belong to, the employee assigned to the project/task. More info: Status, Priority and Dept tables are prepopulated. I can also prepopulate Employee tables but at this time it isn't. So, Status would be Status - table StatusID PK StatusName Values would be: StatusID StatusName 1 Unassigned 2 In Progress 3 Pending 4 Closed 5 Completed 6 Past Due Priority - table PriorityID PK PriorityDesc Values : PriorityID PriorityDesc 1 Normal 2 Low 3 High Then Dept - table DeptID PK DeptName Values DeptID DeptName 1 IT 2 HR 3 Administration 4 Marketing etc Rest of tables are: Employee - table EmployeeID PK DeptID fk (dept table) EmpFirstName EmpMiddleName EmpLastName EmpFullName Username Password SecurityLevel Projects - table ProjectID - PK ProjectName StatusID FK (Status table) PriorityID FK (Priority table) ProjectManager StartDate RequestedCompletionDate ExpectedCompletionDate ActualCompletionDate Task - table TaskID PK TaskName StartDate EndDate PojectTasks ProjectTaskID PK ProjectID FK (Project table) TaskID FK (Task table) EmpID FK (emp table Given what information I have provided so far, I just wanted to ensure proper and fully normalized tables before coding because it becomes easier if this is modeled correctly. Can someone please help me fill missing puzzles or rea-arrange if necessary? Thanks in advance |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2007-11-30 : 13:09:07
|
| In the status, you can also add "ready for QA" value once dev is completed.Try to look at test director application if you can which is used for projects, this app is similar to what you are trying to do. |
 |
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2007-11-30 : 13:27:35
|
| First, thanks for your responsesecond, I was hoping to see if what I presented is fully normalizedthird, where do I find test director application and is it freeware? |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2007-11-30 : 14:12:02
|
quote:
Originally posted by simflex
First, thanks for your responsesecond, I was hoping to see if what I presented is fully normalizedthird, where do I find test director application and is it freeware?
No I do'nt think |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2007-11-30 : 18:06:56
|
| You have been the most helpful individual I have ever met.Thank you soooo very much |
|
|
|
|
|
|
|
|
E-R Design