Project: Relational DBMS 2

Learn more about this resource and browse through a variety of related open source projects.

Relational DBMS 2

Involved in this project: Panos Ioannidis, Dionisis Nikas
A SQL based project that was developed as an assignment for the subject of Databases. This project uses the "UK Road Safety: Traffic Accidents and Vehicles" dataset that is available on Kaggle. We designed optimized SQL queries for looking up accident information in the dataset. We created indexes to speed up queries. We broke up tables into partitions based on specific ranges and database relations. Finally, we have written a program in Java using Spark that executes the designed SQL queries and calculates related statistics.

Similar to this project

Relational DBMS 1

Involved in this project: Panos Ioannidis, Dionisis Nikas
A SQL based project that was developed as an assignment for the subject of Databases. The goal of this project is to design a relational database for storing the data of a car dealership company. We generated hypothetical database entries using Mockaroo for random data generation. We designed SQL queries for creating tables, managing records, filtering and defining relationships. We perform database normalization based on Third-Normal-Form (3NF) and Boyce-Codd Normal Form (BCNF). We setup triggers and cursors to ensure data integrity and perform maintenance. Finally, we have written a program in Java using the JDBC client to simulate real world consumption of the database.

Android Emergency Application

Involved in this project: Panos Ioannidis, Dionisis Nikas
An advanced Android application that was developed as a university assignment for the subject of Software Engineering. The app is based on Google's Firebase platform. Users are able to easily authenticate with their Google accounts. Real time chat with a hypothetical licensed doctor, in-app and system wide alerts on major catastrophic events, a panic button for emergency calls, a driving mode that notifies of speeding violations and a disability mode for fall detection. This software was developed in phases based on RUP with detailed UML diagrams.

Android Speedometer

A simple Android application that was developed for the subject of Software Engineering. The app uses Google's services to determine the phone's location and creates a local database to keep track of speeding violations. The user is able to set the upper speed limit (km/h) and start or pause speed monitoring on demand. When a speeding violation is detected, the app notifies the user with characteristic sounds and text-to-speech messages. The longitude, latitude, speed and timestamp of the violations are stored locally and overlaid on a Google Map.

Student University Information System

Involved in this project: Panos Ioannidis, Dionisis Nikas
A Tier 3 Java web application that was developed as a university assignment for the subject of Object Oriented Application Development. The app features a custom authentication system with roles including students, instructors and secretaries. Students are able to view details about their courses and assigned grades. Instructors are able to grade students per course. Secretaries are able to create, edit or delete courses and assign instructors to courses.

Compilers

Involved in this project: Panos Ioannidis
A programming project that was developed as a university assignment for the subject of Compilers. This project features three languages: C, Java and Python and the Flex lexical analyzer. We include: a Python solution for the balanced parentheses problem using a pushdown automaton, a Python program that generates random character sequences based on specific grammar, a Java program that implements a top-down syntax analyzer and two lexical analyzers in Flex for sample variable and geometric shape declaration.
View all projects