DatabaseTechProject

Description

For my Databases module i was tasked with creating a database, adding data, creating selections and performing a transaction.

Files

Create Database Tables:

Used to create the tables which i use for my project.

CreateFunctions:

Was used for an earlier version of the product where i created a function to perform input validation.

Populate Tables:

Used to add data to the tables which will be used by the selections.

Select Tables:

Select data from the tables using different types of joins, subqueries and set methods.

Transaction:

Mimic a transaction to modify an entry in the table and add a new value.

Thank you for viewing !