bds-db-design

The project was created for uses of the subject Bezpečnost databázových systémů. The topic was optional, so we have chosen the airport maintainance. Database is created in PostgreSQL and MySQL. The ERD diagram was created in MySQL workbench. All further information are included in the documantation of the project, that can be found in the repository under the name database_documentation.docx. The project was created in contribution with Ariela Šťastná, both of us contributed on the project task. Link to Ariela´s repository is here: https://github.com/ArielaStastna/BPC-BDS-DB-project.

Database documentation

Full database documentation is in file "database_documentation.docx"

Database design

Picture representing the database design and original file database_design.mwb database_design.png

Database files

Full database exports

mySQL_database.sql pgSQL_database

Code to import data in database

mySQL_database_data.txt pgSQL_database_data.txt

Only database structure exports

mySQL_database_structure.sql pgSQL_database_structure

Code to create database structure

mySQL_database_structure_raw.txt pgSQL_database_structure_raw.txt

Proof that the database was created in PostgreSQL

pgAdmin4.png pgAdmin4_data.png