This is a list of items left to be finished for the project database: 1. Check that all requirements are satisfied. Note that it has been agreed that the data warehouse integration can be omitted from the initial release if it will delay release of the software. 2. Integrate the system with the data warehouse. Mary Weisse (mca) has created a view for us called project_view. You will need to ask her to create you a username and password and grant you access to this view. Data warehouse integration involves: retireiving a nightly or weekly extraction of the project_view data and dumping it into the pdb database. Changing the tables which use user names (email or full name) to use mitid. Convert mit id to user full name when displaying data (such as who the project leaders are) Authorization checking needs to map the user's kerberos principal to his mitid. the data from the project_view will contain this mapping. 3. Database Backup policy needs to be decided. How often? Archiving is enabled, so backups must occurr frequently enough to prevent the disk which contains the archived logs from filling up and causing the database to suspend activities.