Online Games Shopping

A relational database project made in "pgAdmin 4" using PostgreSQL.

Table of Contents

• General information
• Used technologies
• Features
• Model
• Credits

General information

• This is a PostgreSQL project of the relational database for online games shopping.
• The project presents my skills of relational database modelling and writing queries affecting the database.

Used technologies

• draw.io software for designing a model of the database
• PostgreSQL system for writing & executing queries (version 7.8)
• Notepad++ text editor for merging queries into single script

Features

• 11 tables with exemplary data
  • 2 tables serve as junction tables for "many-to-many" relations ("OrdersGames" and "GamesGenres")
• autoincrementation of primary keys values; you don't need to add ID columns in order to insert new rows

Model

Credits

This project was made by Jason.