DBMS To-Do List

Lab 1

• Create Database
• Drop Database
• Create Table
• Drop Table
• Store Database in XML
• Create Index
• Pseudo-Primary Key and Foreign Key

Lab 2

• ~~Implement Insert Command
• ~~Implement Delete Command

Lab 3

• ~~Implement Primary Key (Single attribute)
• ~~Implement Foreign Key (Single attribute, multiple occurences)
• ~~Implement Index files

Lab 4-5

• Implement Select Command
• Implement Inner Join Command (multiple algorithms)
• Implement AND Logical Operator

Lab 6

• Group By Function
• Sum Function
• Count Function
• Min, Max Function
• Having Function

If we have too much free time

• Optimize the file pathing for TreeView (getter for databases/indexes)
• CSS magic for TreeView
• Polish the user interface
• GUI for server
• Error messages for Create Table / Force filling of fields