Downloads

Back to Menu

To do your assignments you can use the following FREE of charge database engines: SqlLearn developed by Prof. Devi or MySQL the most used free database management system. SqlLearn is much simpler to use so you may start with that and then switch to MySQL.

Download MySQL: http://www.mysql.com/

Download sql13.zip SqlLearn uses a Microsoft Access database engine so the files have mdb extension.

Create a folder sqllearn and download sql13.zip and unzip.exe into the sqllearn folder. Also download spj.mdb database.

In a DOS window, switch to SqlLearn folder and type the following: unzip sql13

After sql13.zip is unzipped, run setup by typing setup at the DOS prompt.

The setup program will take over and will install SqlLearn1.3

To run SqlLearn1.3 click Start in Microsoft Windows then click Programs and it should be in the Programs submenu.

To use it for homework, once installed, click Database then Open a dialog box will open so that you can locate spj.mdb that you downloaded. The table names will appear and if you click on a table name the column names for that table will appear. Click the upper left window and type an SQL statement then press control & x together to execute it. Try all the menu items, it should take just a few minutes to learn how to use SqlLearn1.3.

Click spj.mdb to download the database, if haven't yet, to be used with Assignment 1

To view the tables in spj.mdb database, click Spj.html

carRental.mdb database to be used with Assignment 2