Skip to content

Latest commit

 

History

History
18 lines (14 loc) · 669 Bytes

README.md

File metadata and controls

18 lines (14 loc) · 669 Bytes

SQL_info21

Data analysis and statistics for sc21

SQL2

Introduction

In this project, the creation of a database with knowledge about Sc21 was implemented and procedures and functions were written for obtaining information, as well as procedures and triggers for changing it. Also, add procedures to the script that allow you to import and export data for each table from/to a file with a .csv extension.
The csv file separator is specified as a parameter of each procedure.

Stack used:

  • postgres data types;
  • primary/foreign keys;
  • row constraints;
  • row value generation;
  • DDL/DML;
  • working with metadata, metadatabase.