Skip to content

Latest commit

 

History

History
8 lines (8 loc) · 1.08 KB

README.md

File metadata and controls

8 lines (8 loc) · 1.08 KB
Raw

This assignment was conducted as part of the module ‘Database Management Systems’ for the BSc ‘Management Science and Technology’. In this project a relational database was created using a Microsoft sql server provided by the Athens University of Economics and Business. The files are the following:

  • Tables.sql: All the tables of the database including for instance Payment, Store, Customer, Region etc keeping all the constraints
  • Inserts.sql: Insertion of data to all the tables of the database
  • SQL Queries.sql: 17 queries that answer the questions of the assignment and retrieve the requested data
  • StoredProcedure.sql and Trigger.sql: A store procedure and a trigger for certain actions
  • Question3 & Question4 (.java): Java classes that interact with the SQL server for certain actions (Q3: delete a certain credit card, Q4: update the balance of the card based on the transactions for a specific month)
  • Question3 & Question4 (.class): The compiled files
  • ER-RelationalModel-DatabaseDiagram.pdf: Entity-Relationship Diagram, Relational Model and the Database Diagram of the database.