GuitarCollectionDatabase

Source

Crafted a dynamic database app for ABC Company's guitar collections, empowering users to seamlessly track and query internal data. Multiple tables capture detailed guitar info, complemented by user-friendly views ('EMPLOYEE_VIEW,"'GTYPE_VIEW,"'MANUFACTURER_VIEW'). Implemented timestamped log tables and triggers for effortless view modifications. Innovated further with an UI-linked log table, recording STARTIME and END-TIME for transparent data entries. A seamless model ensuring efficient data management and a user-friendly experience.

PLSQL 1Updated 5/8/2024

Tech Stack

sql

Gallery

README

Crafted a dynamic database app for ABC Company's guitar collections, empowering users to seamlessly track and query internal data. Multiple tables capture detailed guitar info, complemented by user-friendly views ('EMPLOYEE_VIEW,"'GTYPE_VIEW,"'MANUFACTURER_VIEW'). Implemented timestamped log tables and triggers for effortless view modifications. Innovated further with an UI-linked log table, recording STARTIME and END-TIME for transparent data entries. A seamless model ensuring efficient data management and a user-friendly experience.