Visual Resource Database

Link: Database Design Report

Project Title: Visual Resource Database

Project Description: For my final project in INFO 639 Database Design and Development, I designed a complete database management system. This relational database was designed to address the specific needs of managing a private visual resource collection. It was developed and implemented using MySQL to address a variety of user-tasks such as tracking digitization and cataloging of resources.

Methods: This project was broken down into four components. 1) Identifying user-needs and input data in relation to how a database can solve those needs. 2) Develop business rules based on the hypothetical user-needs, which informed the conceptual design model and entity-relationship (ER) diagram. 3) Once the ER diagram was finalized, I used MySQL to design and implement the table structure for the database and input data through randomized imports and manual data entry. 4) Finally, I used MySQL to write queries on the database to solve the user-needs identified at the beginning of the project.

My Role: I am the single author of this work.

Learning Outcome Achieved: Technology

Rationale: Completing this project required learning how to use digital tools such as Lucidchart to create models during the design stage and apply various industry standards such as Chen’s and Crow’s Foot notation. It required an in-depth understanding of how to problem solve and use structured query language to query for data, implement, and input data in a relational database created with MySQL in the MySQL Workbench GUI. Successful completion of this project demonstrates my understanding of how to utilize a programming language, digital tools, and software to manage access, retrieval, and use for a relational database. It also informs my understanding of the vital role database technology plays in the organization of data in the information world.