Database Project

For my personal project, I've divided it into two parts. The first part focuses on the development of my database using DML, DDL, and DCL statements. The second part is connecting to my Oracle database using Pandas through Python.

Database Construction

First of all, my database represents an automobile warehouse that sells car parts to customers. This means keeping track of their customers, order ids, suppliers, and products. I've provided a pdf file that explains the construction of my database in more details.

Database Architect Explanation

I have design a diagram where a lot of tables share a trait like Employees with Departments, Orders with Product information, and Parts with their Supplier information.

The image is only a sample as I have so many tables to show

Diagram Link

Database Application

For my second part of my project, I coded a couple of implementations that would handle an order. This means handling the process of moving parts from their location to the internet shipping department.

Click link below to read in more details.

Implementation Explanation

I used Pandas through Python to connect to my Oracle Database. This allowed me the ability to make DML and DDL operations through an application. In this application, I programmed three features that a warehouse worker would use in real life.

These are short summaries, clicking the link on each page will explain further with details.

Home