Java, JDBC and MySQL is the main point of this project.
We have used MVC and DAO design pattern in order to implement a visualization(gui) of a music database with 4 tables: Album, Artist, Track and Genre.
*use git/GitHub [ok]
*Design database and implement in MySQL [ok]
*Draw ER-diagram [ok]
*Atleast three tabels [ok]
*fulfill normalforms [ok]
*atleast two foreign keys [ok]
<-:(GUI):->
*fulfill CRUD [ok]
*have some sort of selection functionality [ok]
*have some sort of search functionality [ok] *Simplify columns in the GUI, take away confusing "id's" for the user (Though this application is just a visualization of the database, so it depends of the usage in the future)
*Develop the search function so it includes several of colummns in one search etc.
*Maybe use Composite pattern(modified a bit maybe) to reduce the amount of "repeated" code, though the DAO-pattern can be vvery nicely used with Hibernate in the future if one would like to manipulate the code for Hibernate usage.