|Team Name||Team VERITAS|
|Duration||Fall 2017 - Spring 2018|
|Faculty Advisers||Bruce Bolden|
Our client has requested that we create a web interface that communicates with a dynamic database securely. To do this, we have broken the project up into three main parts:
- the web interface's design and implementation
- the database's design (including how to simply edit the contents given the proper permissions)
- the communication protocols between the two.
PNNL is looking for a means of displaying particular information about various products and their specifications in a dynamic, secure, and reasonable way. This project, thus, will require a background in databasing, querying languages, webpage languages, servers, and general client-server security.
- An accessibility-standards-compliant webpage, that will act as an interface for the client wanting information.
- An SQL database/server, able to be changed dynamically and easily, that can be queried by the webpage.
- Documentation detailing the use of each.
- Potentially a duplicate database/server that will be air-gapped, but this is a stretch goal.
NOTE: SUBJECT TO CHANGE
Currently still detailing specifications with client. Current hosting will be done on an Amazon web server. All code must be accessibility-specification compliant.
Relevant Links/Document Archive
- Access to PNNL servers denied. Hosting being moved to Amazon web server for now.
- First commits of code to repository in the works. More design direction to follow.
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. Therefore, our design includes data scrubbing before the website is able to query the database. This will enhance the security of our database and provide protection for our data.
|The main website allows for the user to search the database or select from a preselected group of popular choices from a dropdown menu.|
|The postcard view will be displayed after the user has used the search button or selected an option from the dropdown menu. This will display the most relevant choices with a small bit of information on all matching products. This will allow the user to see select the most relevant product given their needs. They can click on the postcard view to lead them to the full product page. The postcard view will show up on the main webpage under the search bar and populate many postcard views.|
|The full product page is a separate website from the main webpage and is accessed from the postcard view. All product information that the database has on that product will be displayed on this page.|
|The database holds all of the information we have on all products. It needs to encrypt all communications, so no data is ever compromised. Each page will query the database and have its' fields dynamically updated. The only way to make changes to the database will be from a non-web based entry method that will require authentication.|
- Off the Shelf Technology
Why will this design work? We will be using established technologies to achieve a task within established boundaries.
Team Member Information
|Alex Wezensky||Alex Wezensky is a senior dual majoring in computer science and mathematics. Within computer science, Alex is interested in artificial intelligence and big data. In his free time, Alex enjoys playing basketball and ping-pong, and playing Rock Band with his roommates.||Computer Science/Mathematics|
|Animesh Pattanayak||Animesh Pattanayak is a senior majoring in computer science with a minor in mathematics. Animesh's interests include cybersecurity and research. Outside of academics, Animesh enjoys playing piano, guitar, and singing. Additionally, Animesh enjoys going for long walks, skateboarding, and playing soccer.||Computer Science|
|Jocelyn Stadler||Jocelyn Stadler is a senior in computer science with a minor in mathematics. Jocelyn is interested in cybersecurity and computer architecture. Outside of school, she enjoys reading, swimming, playing video games, and baking.||Computer Science|
|Joel Doumit||Joel Doumit is a senior majoring in computer science. Joel's interests include embedded systems and microcontrollers. Apart from academia, Joel enjoys watch collecting, swimming, and sport shooting. In addition to hobbies, Joel enjoys working on pet projects, including a Discord soundbot and a Raspberry Pi radio transmitter.||Computer Science|