[13] in Project_DB
Few clarifications needed
daemon@ATHENA.MIT.EDU (miki@MIT.EDU)
Fri Feb 14 15:27:17 1997
From: miki@MIT.EDU
Date: Fri, 14 Feb 1997 15:27:09 -0500
To: project-db@MIT.EDU
Looking at the schema, erd and the Data that I have as initial data to
the Project DB we have the following issues :
a. The Practice is not allways filled in. I decided to relax the requirement
for a Not NULL Practice in the DB's schema.
b. We have many values for practice, which are not among the 3 (or 4)
practices of MIT. I will list the practices as they appear in the data
and ask for a resolution of what are the final values to be put in the DB.
I would prefer to know what are the values for practice now, as the Web
interface does not allow for the update of the practice table. (The values
for practice could be changed only by somebody who is logged into the
server machine and knows sqlplus).
The values in the data I received are :
ACADEMIC
OFFICE
MIT External
I/T INTERNAL
SAP / OFFICE
INFRASTRUCTURE
I/T INTEGRATION
I/S INTERNAL
d. The status of a project should be a value people may like to search on.
I will put in few status values at the initial load of the DB and latter
new values may be added. Looking at the data I have, the status has too many
values. They are :
requirements
completed discovery
implementation
alpha test
service handoff
on hold
in-progress
completed
potential
DESIGN
RESEARCH PHASE
ANALYSIS: PROTOTYPE BEING BUILT
UNDER REVIEW
Close to implementation
NEARING PRODUCTION
DETAILED DESIGN
CODING
FINAL TEST
SOME PORTS COMPLETE
DESIGN: PROTOTYPE BUILT
AWAITING IMPLEMENTATION
COMPLETE
PRODUCTION
TEST
COMPLETE as of January, 1997
NEARING IMPLEMENTATION
IN PROCESS
COMPLETED DISCOVERY
