IT2002 Database Technology and Management
2007/2008 Semester II

1. Connection to SyBase Database (sundbl)

• Run Interactive SQL (ISQL)
  Go to Start-> All Programs -> Sybase SQL Anywhere ->Adaptive Server Anywhere ->Interactive SQL
   
• You will see 3 tabs (Identification, Database,Advanced). Choose the Advanced tab.
  Copy/Paste the following settings:
      commlinks=tcpip(host=sundbl.comp.nus.edu.sg);
      eng=course
   
• Go to the Identification tab
  In the User ID box, put your login. In the Password box, put your password.
      The login name is your NUSNET ID
      The password is sybase77
  Click OK.

2. Change Password

You will have to change your password since this is the first time you're logging into the Sybase server. Please change your password by using this command in the SQL window:

        GRANT CONNECT TO your_login IDENTIFIED BY new_password

Note1: replace your_login and new_password accordingly with your own login and your new password.
Note2: Enclose new_password in single quotes: Eg. if your new password is hello, you must write 'hello'

3. You can start writing your SQL code!

The exercises for the SQL labs are already published in the IVLE workbin.

4. How to check your tables

After running the CREATE TABLE commands, you can see which tables you have  with the following command:
        SELECT name
        FROM sysobjects
        WHERE type = 'U' AND uid = user_id('put_your_login_here');

We will use a demo database which models a bank application.

• Here is the SQL script to create the database (it has some errors; you must correct them).
• Here is the SQL script to insert the data (you also need to correct the errors).
• Finally, you can use this script to clean-up your database.

You can access Sybase from outside the lab, in order to prepare the exercises. There are two methods:

1. Install the Sybase server on your own PC (recommended).
2. Access the lab's server from outside the lab (not recommended and not guaranteed to work).

Post your questions to the IVLE Forum.

Have fun with SQL!