This repository holds the implementation of a Database System, which was completed during my third year of studies in the Computer Engineering and Informatics Department at the University of Patras. The aim of the project was to get acquainted with the design, implementation and input of data in a relational Database, which was connected with interfaces (GUIs, Graphical User Interfaces) that were implemented in Java using JDBC technology. The Database concerns an electronic support system for the operations of a Daily Press Publishing House. This system connects journalists who write articles, editors-in-chief, administrative employees and the publisher of each newspaper.
- PART A:
- codes: Inside this folder, exist the code for the creation of the Database, in the SQL programming Language. The operations are, the creation of the tables, the insertion of data inside the tables, the stored procedures and the triggers that were necessary for the smooth deployment of the database.
- ER: This pdf represents the Entity Relational Diagramm of the Database.
- Relational Model: This pdf represents the Relational Model of the Database.
- PART B:
- project_db: Inside this folder, exist the code for the creation of the GUIs of the Database, and the necessary connections, in the Java programming Language and using JDBC technology.
- Report: A written report explaining everything that concerns our system, in Greek.