Advanced Assignments

The series of advanced assignments will ask you to write programs or edit a simple database to turn the concepts discussed in class into actual code. Some of these will be self-contained assignments, and some will add new features or improvements into a simple Python-based query engine called DataBass.

• Translating ER diagrams to SQL statements
• Graph analysis using common table expressions
• DataBass Assignments
  1. Add to the Parser
  2. Add an operator and get it to run
  3. Join ordering optimization
  4. Query compilation