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 […]
Order Entry Statements (SQL Part 2)
March 20, 2022 For the second part of the project, I again used the Customer, Order, and Employee tables found in Database design, application development and administration (pgs. 73-74). The tables were created in the Relational Data Model entry; therefore, this project focuses on writing SQL statements to insert the data and then view the […]
Relational Data Model for Order Entry Table (SQL Part 1)
Relational Data Model – Order Entry Table Creation February 27, 2022 For this SQL project, I used the Customer, Order, and Employee tables provided in Database design, application development and administration. The focus for this project was to create the database and tables and then demonstrate the appropriate connections between these tables in an entity-relationship […]
