This repository contains sample code and project templates for the DBMS course at Luther College.
- Write data from csv, json, txt files into an SQLite database
- Read data from the database and populate the fields in the provided GUI
- Implementation language: Java
- Testing: jUnit (provided)
- Overview (Java Platform SE 8 )
- The Java Tutorials
- Designing a Swing GUI in NetBeans IDE - Tutorial
- DB Browser for SQLite
- SQLite Tutorial - javatpoint
- SQlite Java - How To Use JDBC To Interact with SQLite
- FasterXML/jackson-docs: Documentation for the Jackson JSON processor.
- opencsv - General
- JUnit - About
- NBA Basketball Teams - National Basketball Association - ESPN
- MLB Baseball Teams - Major League Baseball - ESPN
- Extend the Relational project to process relational algebra operations as described in the textbook.
- Each team will implement one single-table operation and one 2-table operation.
- select, project, rename, sort, extend, groupby
- product, join, semijoin, antijoin, union, outer join
- Implementation language: Python