Database Systems
Introduction to database systems, emphasis on database design and access. Database concepts, data modeling, normalization, data warehousing, query languages, formulation of complex queries.
This project reflects the development a robust server application, with a focus on the specific context of documenting car purchases and background verification checks. The chosen database and server application, exemplify a purposeful design aimed at capturing essential details related to individuals buying cars. The provided business/use cases illustrate practical applications, aligning with the real-world scenarios of car purchases, and are seamlessly integrated into the comprehensive database model. This model showcases a meticulous design with a minimum of three tables, including at least two join tables, each featuring three columns, a non-null column, and a primary key. Visual annotations of relationships, incorporation of a view, and inclusion of a routine group and stored procedure elevate the model's complexity and efficiency.
The image representation of the finalized database model further enhances the portfolio's visual appeal, providing a tangible glimpse into the structural intricacies of the database. The meticulous organization and readiness for deployment are evident in the database, encapsulating the entire structure, data, and stored procedures in a self-contained SQL file. Moreover, the NodeJS server application is implemented with Express and MySQL, featuring essential routes such as GET for data retrieval and POST, PUT, and DELETE for enhancing interactivity and functionality, all tailored to the context of car purchases and background checks.
This project serves as a testament to my proficiency in database modeling, implementation, and server-side development, highlighting a comprehensive skill set that seamlessly combines theoretical knowledge with practical application. The chosen context of car purchases and background verification checks adds a specific and practical dimension to the showcased capabilities, emphasizing their relevance in real-world scenarios.
Back to Top