in SQL

This project involved Data Engineering and Data Analysis where I designed the tables to hold data from 6 CSV files, imported the CSVs into a SQL database using PostgreSQL and wrote SQL queries to answer the given questions. A bonus analysis included creating some charts to analyze employee salary data.

7. SQL Engineering and Data Analysis

This repository is for me to practice SQL using PostGreSQL and connecting it with Pandas.

There are two related projects here. The first one, Garden Services, is an individual project I did for Database Foundations in which I created Business Rules, an ERD, normalized the database, and wrote it into SQL. The second project, Ding's, is a group project with the same components, and it is compiled into one document.

SQL was used to create database which determined the number of retiring employees per title, and identify employees who are eligible to participate in a mentorship program. Data modeling, Engineering, analysis, and application was established to forecast and prepare for the upcoming shifts in the company's employees.

Research project using data modeling, data engineering, and data analysis to create a database of employees hired at Pewlett Hackard in the 1980s and 1990s.

Practised building an ETL pipeline using Python and Pandas to extract and transform data. After which the data was loaded into a Postgres database.

ERD for an Inventory System

Data analytics projects at NTU/ Articares

This is a collaborative project that teams can build after learning ERDs and DOM manipulation

Our project is about a Medicine Barcode Scanner app that helps with different situations, including that there are some medicines have been dispensed incorrectly, some are similar to other medicines, some of which did not have a prescription, and even provide a prescription cannot be read by the elderly.

A simple software engineering project for university, the basics!

Database design using the SDDM tool. Simple examples/samples of primarily just the logical design which is expressed as Entity Relationship Diagrams (ERD). DSD can be automatically generated from these. In some cases, SDDM is simply used as a drawing tool (drawings directory). To find SDDM google: "download sddm database" Trademarks are owned by…

A Data Base Console Application for Super Market which has distributed branches in different governorates. The Project is a file-based system attached with ERD

A repository displaying the use of SQL to create and query a large employee data frame for a technology company

LightHouseBnB is a property rental service similar to AirBnB.

This is a database project for the Database 1 module at TU Dublin.

SQL - ERD for a fictional movie theater

This includes ERD, Relational Schema, Pokemon Script, Project Evolution, and Join and Query Output