Bringing a Database to Code – Improving Nylene’s Database
Posted on Tuesday, March 30th, 2021
| Client | Nylene (Kim Young) |
| Professor(s) | Todd Kelley, |
| Program | Computer Engineering Technology – Computing Science |
| Students | Phillip Clarke Emmett Janssens Daniel Rooke Danial Tauhidi Somron Touch Joshua Whiting Brent Zhang |
Project Description:
Our client Nylene Canada, based in Arnprior, manufactures polymer based products for a variety of applications and markets. The company’s current database is poorly designed and doesn’t conform to database normalization and data integrity principles. Our client has been facing many issues managing product information as their product base grows .
Our project involves redesigning the entire database for the client in MySQL and migrating the existing data to a new schema. There is also a web application in place that allows the client to perform CRUD operations on their database. We are updating the application with additional features giving more control to the client admin users to manage the DB, as well as syncing up the application with the new database design.
The project also involves redesigning and updating the product display page, for Nylene’s customers, to improve search and filtering options if they wish to narrow down the product list based on specific requirements. Another feature being added is a name builder that allows admin users to build a Nylene product name based on the associated brand components. This feature will assist users creating unique names built under a consistent naming schema.
There is a mix of backend and frontend development in this project, however, the major development happens on the database redesign and data migration part making our project database heavy.
Short Description:
Rebuild Nylene’s database to modern database design standards and add functionality to the Nylene website giving users a consistent experience.