Project VERITAS

Problem Definition
Design and implement a secure database that communicates securely and dynamically with a web interface. The database has read only access from the web interface. The interface follows accessibility standards and will work on a range of hardware. Communications are encrypted in both directions.

Background
Pacific Northwest National Laboratory needed a simple way to access their research data on different components. They also needed a secure database to hold the data.

Project VERITAS was created because:
 * it offers a simple way to search through all the data
 * makes it easy to find a specific product
 * it provides secure access to data
 * makes it easy to add new product data

Deliverables

 * Accessibility standards compliant web interface that accesses product data
 * MySQL database to store product data
 * Secure communication between web interface and database
 * Documentation detailing the use of all code and supporting resources

Overview
We have designed a web interface to securely connect to a database. This consists of a secure database and three main sections for the webpage (main webpage, the postcard view, and the full product view). The website should never be able to access the database in a malicious way or tamper with the data at all. The communications to and from the database are encrypted.

Project Learning
Various program languages - HTML5 : Visible interface - PHP7 : Gives standard programming capabilities to HTML - CSS : Presents HTML elements in the desired fashion - JavaScript : Allows user to interact with web interface Database Languages - MySQL : Main Database Server - NginX
 * Off the Shelf Technology

Verification
To show that the communications between the database and web interface are secure/encrypted below is a screenshot of a Wireshark packet capture.

Future Work

 * Air Gapped Database
 * Comparison Option
 * Search Bar Option
 * Popularity Postcard Sort

Document Archive

 * [[Media:TeamVERITASdesignslides.pdf|Team VERITAS Design Review Slides]]


 * [[Media:TeamVERITAScontract.pdf|Team VERITAS Contract]]


 * [[Media:VERITASMeetingMinutes3.pdf|VERITAS Meeting Minutes and Client Meeting Overview]]


 * [[Media:VERITAS_Schedule.png|VERITAS Schedule]]