Video Store Database in PostgreSQL
Project Description Johnson Video Store owners are implementing their first relational database to replace paper files and scattered digital records. There are three files in this repository. Meta data was created and stored in a separate excel file. Database tables outlined in the metadata document were created using PostgreSQL to develop and execute a SQL […]
The Curiosity Shop Data Model
March 5, 2022 The Curiosity Shop is expanding its database applications to include a simplified inventory system and employee and customer data storage. Management would like to see an entity-relationship diagram that establishes a blueprint for the new design. The shop has provided sample tables for Sales and Purchased Items with some overlapping columns and […]
