A bespoke database and associated web based interface to streamline a company’s core business process.
The company stored product information in a variety of formats and locations on their internal network, making it inefficient and inaccurate gathering information when it was needed for sales, or customers. I was contracted to provide a bespoke database to bring all the information into one central location, and to provide a straightforward way for staff to search and use it.
The project delivered a database schema unique to the company’s exact needs, alongside a web based front-end which allowed staff to add, edit, and search for information. Since the data is now structured, previously unavailable ways of getting linked data could be taken advantage of - for example finding all the products provided by one given supplier in a single page of images.