Client Contract: Oral Microbiology Lab Database
General Description:
Oral Microbiology Laboratories (OML) is a multi-discipline facility that process clinical oral microbiology samples from all over the United States. In order to meet their need, a multi-layered database capable of managing research requests, tracking clinical and research data, and performing independent demographics of stored data for future academic papers will be necessary. The system will be accessible from multiple locations throughout the lab. Views for patient data will be password protected in order to meet federal CLIA regulations. The system entails different modules/views designed for the given user cases, a view to login and track specimens and a view to allow entry of clinical and research data. The ability to perform queries on demographics and other stored information is essential.
Participants:
Client: Eric Simmons
Developers: Ben Johnson David Michaelson David Williams
Requirements:
Primary Requirements:
• Database is to track kits, samples, results, and create billing information.
• Each login should have a profile specifying user type, accompanied with a password protection. Each user type should have access only to the functions permitted by their classification.
• Data entry forms must be tailored to facilitate data entry from the standard laboratory forms with proper error checking included.
• Database must be backed up daily. One week’s history of the data must be maintained.
• Sample ID must use the current year (e.g. 07) as the first digits.
• Database must allow for custom queries to be executed.
• Database should have proper documentation for usage, maintenance, and expansion.
Secondary Requirements:
• Database system should have a bar code system in place to quickly manage kit numbers.
• Clinician data should be ported to the new database if possible. (All other data will NOT be ported).
Tertiary Requirements:
• Database could be expanded to integrate billing process.
• Additional queries could be created and integrated into the system in case client desires new query screens
Constraints:
System must be accessible from multiple places in the lab.
Budget for resource acquisition is limited to no more than $500.
Deliverables:
Database System
PHP Server Code
Database Schema (Technical Document)
PHP Server Description (Technical Document)
Database User Manual
Oral Microbiology Lab Process Description
Resources Required:
Database server and software
PHP server and software
Bar code reader and software
Contractor and Client Obligations:
Client requirements:
Determine a server spot for the system.
Be available for information/feedback as we need it.
Carefully review presented prototypes, documents, and deliverables.
Provide early feedback concerning oversights or misunderstandings.
Acquire resources necessary for project completion in a timely manner.
Contractor requirements:
Maintain up-to-date website for client’s reference.
Provide notices of completed prototypes, documents, and deliverables.
Provide a fully functional database system with the proper documentation.
Risks: Success of the project depends upon access to a database management system and a PHP server.
Milestones:
• February 7th. Prototypes for data entry forms available for review.
• February 13th. Initial database schema available for review.
• March 2nd. First Deliverable. This will be a package containing the database schema, the database forms, and allow for navigation between the forms. It will not have any specific functionality. Also included are the Oral Microbiology Lab Process and Database Schema documents.
• April 5th. Second Deliverable. This deliverable will be a functional database enabling all use cases detailed in the functional specification. It will contain minimal error checking and auto-completion. Also included are the Database System and PHP Server Code documents.
• April 27th. User testing complete.
• May 3rd. Final Deliverable. This deliverable will be the fully functional system and all documentation. Included will be a final user manual.
Signatures: (Participants plus professor)
_
David Michaelson
_
David Williams
_
Ben Johnson
_
Eric Simmons
_
Diane Pozefsky