Skip to content

FrostyLabs/Oracle-SQL-BankApplication

Repository files navigation

Oracle SQL Coursework

SET09107: Advanced Database Systems - Coursework

This coursework had us redesign a banking entity relational database into an object relational database.


How this repository works:

  1. Setup database: run reset_tables.sql

⋅⋅⋅A diagram of the database structure can be found under report.pdf section 2

  1. Add member functions to types: run alter_types.sql
  2. Populate tables with data: run insert_data.sql

⋅⋅⋅Each table is populated with a minimum of 20 rows.

  1. Queries for coursework found in Coursework.sql
Notes:
  • report.pdf is the writeup for this coursework.
  • cw-ads_18.pdf is the coursework specification.
  • I used SQL Developer version: 17.4.0

About

Advanced Database Systems (SET09107) Coursework

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages