[40] in iswork
Initial review of DB schema
daemon@ATHENA.MIT.EDU (Tim McGovern)
Tue Apr 11 10:31:01 2000
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Message-Id: <v04020a03b518e25ae71c@[18.152.1.21]>
Date: Tue, 11 Apr 2000 10:30:57 -0400
To: miki@MIT.EDU
From: Tim McGovern <tjm@MIT.EDU>
Cc: iswork@MIT.EDU
Miki,
Below are my preliminary thoughts on the db schema you gave me last
Thursday. I do not yet have final answers on all of your questions, which
I'll continue to work on today and tomorrow. After you apply the changes
below, can you send me a machine readable version that I can use in my
sponsor checkin conversation later this week.
Thanks,
Tim
-----
General comment on field names: we should be consistent with names -- use
either hyphens or underscores, but not both.
Tables PRACTICE, PROCESS, ITLT, IS and MAINTAINERS
I would suggest removing the character field, and replacing it
with either the kerberos id or the MIT ID and linking these to
an individual's details in the RESPONSIBLE-PERSON table.
Table IS
I would suggest renaming the table to INFOSYS for clarity's sake.
Table THEME
The field THEME-ID does not need to be restricted to values 1..4.
Right now, there are only four, but someday there may be others.
Table STRATEGY
The field PRIORITY (I believe) is an error in the ER diagram, and
can be removed.
Table INITIATIVE
The field PRIORITY contains a value clause of 1..10. Right now,
there is agreement that the ITLT will set the priority of initiatives
to one of four values
CD = Currently Doing
MD = Must Do
LA = Later
NL = Not Likely
Table PROJECT
The field PERF_ORG can be removed.
The field TEAM_MEMBERS is under discussion with project sponsors.
The field STATUS value list consists of Active, Pending, Completed,
On Hold, Terminated, See Comment.
Table ACTIVITY
The field PRIORITY can be removed.
The field STATUS should be an index into the acceptable values of
activity statuses, namely
1 = Leave as is
2 = Renew it
3 = Shut it down, let it become obsolete
4 = Do process/productivity improvement
5 = Argue for additional resources
The field PERF_ORG can be removed.
The field TEAM_MEMBERS can be removed.
