Team TRS’s goal for this project was to create a sturdy, scalable database foundation that, as TRS desires, can be expanded upon to increase functionality.
Sponsored by: TRS Technologies Inc.
Team Members
Greyson Murray Ian Bruce Adrian Nijenhuis John Joseph Tabuzo
Instructor: Robert Allen Kimel
Project Poster
Click on any image to enlarge.
Project Video
Project Summary
Overview
TRS is a State College based piezoelectric company specializing in the growth of PMN-PT family ceramics for use in medical applications. To facilitate the best possible growth and processing practices to create effective, inexpensive parts, proper data keeping is essential. Team TRS worked this semester to create a scalable relational database that can house all important information on the crystal – both before and after growth. Created using PostgreSQL, the database will allow TRS to more effectively input and analyze data, yielding a more streamlined process.
Objectives
Team TRS’s goal for this project was to create a sturdy, scalable database foundation that, as TRS desires, can be expanded upon to increase functionality.
Approach
Establishing a firm understanding of TRS’s growth and processing techniques was crucial in creating an effective relational database. We needed to understand how different variables were connected and how they transferred over through each of the steps of manufacturing.
Outcomes
What was accomplished is meant to be the foundation in which the database can scale depending on the company’s desired direction. This will aid them to determine areas of the manufacturing process that can be improved further to have greater yield and less waste.