Project Description

The print designers at the University of Northern needed a way to keep track of all the projects that were currently working on as well as keeping track of which jobs were at the printer. The previous system used a single database table and had duplicate columns including the client’s information and printer’s info.

I created a relational database structure that allowed the clients, designers and printers to use one table and jobs use a separate table. This keeps the data clean and allows for quick sorting on clients.