Utilize SQL to create a database and pull information on retiring employees at a company.
-
Updated
Aug 31, 2022
Utilize SQL to create a database and pull information on retiring employees at a company.
Exercise to create databases, tables, entities, relationships, diagrams and a database project on the Mexico City subway
My first major task is a research project on employees of the corporation from the 1980s and 1990s. All that remain of the database of employees from that period are six CSV files.
Using PostgreSQL to query an employee database. Creating an ERD to showcase relationships between database tables. Using primary keys and foreign keys.
A challenge that uses PostgreSQL to perform data engineering for the employee database.
This project was created to make a sub-system for a freelancing business. This database was used as a final project for my Database Systems course and there are more details on my design and implementation in the ReadMe.
Example showcasing one-to-many relationship
Data cleaning normalization using SQL
A app where use of foriegn key is illustrated along with the validation of forms
Example showcasing one-to-one relationship based on composite foreign key
Example showcasing many-to-many relationship based on composite foreign key
University Database made in SQL
Check all foreign keys in a PostgreSQL database for logical integrity
Define FOREIGN KEY Constraints in a CREATE TABLE Statement
SQL Server 建立 Foreign Key 限制條件時使用 WITH NOCHECK 的差異範例
This project involved converting an Excel spreadsheet system for a hotel to a relational database. The database was designed to satisfy 3NF using the data provided. An ERD diagram was created to represent the database as well as the script to create and populate the tables and SQL queries.
Full SQL Data Manipulation on csv files. Optional Referential Integrity FK using Schema. crystal all the way!
Add a description, image, and links to the foreign-keys topic page so that developers can more easily learn about it.
To associate your repository with the foreign-keys topic, visit your repo's landing page and select "manage topics."