For ASP development I would recommend to use Visual Studio, that you can get for free from Microsoft website .

Back to your project...
You been given task that is nearly extensive as final year project. I would recommend you have look on few SQL Browser interfaces such as phpMyadmin, MySQL Query Browser, SQL Server Management Studio Express or any other so you get idea what you need to provide for user.
Do not go extensive on it, given them just basic options so they do not mess up anything. You should just offer option to select in which database new table should be created, text field for table name, then text fields for column names (make sure that table and variables names appropriate not special characters such as comas, dots, slash etc), drop down options for variable types (just work out what are most common variable types they use, you do not need all of them) and possible initial values (for this I would recommend you have good look at phpMyadmin).
Adding new collumn approach is somewhat similar to creating new table, but this time you have to select database and table.