DATABASE SYSTEM PRINCIPLES

Description

This class introduces Basic concepts of databases, including data modeling, relational databases, query languages, optimization, dependencies, schema design, and concurrency control. Exposure to one or several commercial database systems. Advanced topics such as deductive and object-oriented databases, time allowing.

DISCLAIMER:

This private repository was made after completing the course and is use for personal usage only. This was not intended to supply students with answers. Again, this is a private repository and access to this repository is only for people visiting my Portfolio website.

PA 1 is a programming assignment that involves multiple queries to a database developed in the class. This assignment was to get use to the usage of SQL and the many keywords and statements that we have access to in order to manipulate and manage data.

• Skills/Tools: SQL, Complex Queries

PA 2 is a programming assignment that uses JDBC in order to run SQL queries in Java. This assignment focuses heavily on recursion and creating temporary tables within complex queries in order to get the desired result.

• Skills/Tools: Java, SQL, Recursion, Complex Queries