COB logo COB honor code logo

 

BA371 Assignment 1: SQL 'Interpreter' for Access

 

This assignment assumes that you more or less master the various topics demonstrated and practiced in the following labs:

In this assignment, you will have to combine the techniques explored in the above labs into a single application.

Although Ms Access offers an interface for running SQL commands, it lacks an SQL script interpreter; i.e., a facility that can read a(n) SQL script and execute its statements, one after the other. In this assignment you write the C# code for such an interpreter. Later in the course you will use this interpreter to run the class project's SQL database schema creation scripts against a (blank) Access database.

  • Here is what your application's GUI should look like:
  • SQL Interpreter Interface

    Demo SQL script file.

    Requirements:

     

    Some hopefully helpful hints: