DATABASE

Author: Chukwudi Derek Anyanwu

This repository contains code samples that demonstrate my skills and experience in the following:

• Development of database management systems
• Relational database model
• Construction queries that meet user requirements
• Use of Data modelling and database development tools effectively

Tools: Oracle; Oracle Data Model; lucidchart

Assignments:

1. Relational Algebra
2. Functional Dependencies and Normalization
3. Conceptual & Logical Modelling
4. Creating and Populating the Database
5. SQL Part 1
6. Update, Delete and Transaction Management
7. SQL Part II (SQL Intermediate)
8. SQL Part III (SQL Advanced)

Project:

1. Full Database Model and Implementation - Monash Art Union (MAU): Aim: Designed and Developed a comprehensive Database Management System for a an Art Gallery and , Implement and Operate a Database Application Development LifeCycle.

2. SQL - Traffic Demerit System (TDS): Aim: Populate tables with appropriate test data and write the SQL queries specified.