COMP-3150-1 FALL 2025 Announcements.
PLEASE, CHECK THIS PAGE FOR COURSE EVENTS. Just scroll down to read from recent to old
announcements.
NOTE:
DO NOT FORGET, IT IS IMPORTANT TO ATTEND ALL CLASSES.
Class Times:
COMP-3150-1: T, R (11:30am - 12:50pm) UWindsor as announced in
Brightspace.
Office
hours:
Comp-3150-1 (60-315-1): M, 12:00pm-1:00pm and Tuesdays,
2:00 – 3:00pm in my office at CS.
Course Web Page can be
accessed through: https://brightspace.uwindsor.ca/d2l/login Or https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/fallindex.html.
Important and urgent class
announcements are also sent to students through their Uwindsor email account.
Please, check your UWindsor email account regularly.
Schedule for Extra Tutorials or office
hours provided by Computer Science for Students at various levels can be found
through a link found through the GA consulting hour link.
Posted Friday, August 4, 2025
Dear
Fall 2025 Comp 3150 Students,
Welcome to my Fall 2025 class and see you in class on Thursday, Sept. 4, 2025.
Course Instructor: Dr. C. I.
Ezeife
E-mail: cezeife@uwindsor.ca
Office Location:
Office Hours:
Classes: Tues, Thurs : 11:30am – 12:50pm;
Room : (Toldo 102) As announced in brightspace.
Course Web Page is open and can
be accessed through Brightspace https://brightspace.uwindsor.ca/d2l/login or directly through: https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/fallindex.html.
Course Text:
Elmasri, Ramez and Navathe, Shamkant (2016).
Fundamentals of Database Systems, 7th edition, Pearson. Isb-13:
978-0-13-397077-7; isbn-10: 0-13-397077-9.
Please, print or download the course notes from the web site and
write notes from class lectures inside your notes and/or in a scribbler for
easier revision in the future.
Where to Find and download Course Notes
I have placed a .pdf copy of the chapters of the course notes on
the course web site through the course notes link at this course web site:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/notes/index.html.
Note : What you need to do to
be able to run SQL through Sqplplus.
1. You need to install the
GlobalProtect VPN on your computer (PC, laptop, mac) to be able to connect to
any of the CS machines called alpha.cs.uwindsor.ca, bravo.cs.uwindsor.ca,
charlie.cs.uwindsor.ca or delta.cs.uwindsor.ca in order to use the programs
like the Oracle database management system (DBMS) for creating, querying and
managing your databases.
Information on How to Install or Update GlobalProtect VPN
·
New
University VPN Users: View the KBAs with instructions on how
to install the Global Protect VPN.
·
Existing
University VPN Users: Find Update the VPN per the KBA to see how to remove the old portal networklogin.uwindsor.ca to
the new securelogin.uwindsor.ca.
·
Should
you require help with the VPN, please
contact the IT Service Desk by opening a ticket, calling 519-253-3000 ext. 4440 or selecting the chat icon in the bottom right corner of uwindsor.ca/its or uwindsor.ca/itshelp.
3.
Connect
to any of the CS machines through either Bitvise SSH (http://www.putty.org/) or Nomachine (https://www.nomachine.com/download).
These two software programs can be downloaded from their websites. More
details on how to obtain them are provided below.
4.
The following is
the new cs help that all the students should try first. https://help.cs.uwindsor.ca/search?term=oracle
5.
If connecting to
Oracle Sqlplus through SSH client, the following instruction can be used. A
quick summary of Sqlplus instructions can also be found on the course web page
and on course brightspace resource folder.
sqlplus “username”
password: (type
your Uwindsor password where username is your Uwindsor username without double
quotes. Eg. cezeife@delta.cs.uwindsor.ca)
(To
exit Sqlpus, just type exit at the prompt, and to exit SSH terminal, type
another exit at the prompt.)
6.
For
Macintosh laptop users. You can simply run ssh commands from your Mac operating
systems shell terminal with commands like the following:
ssh “username@hostaddress”
password: (type
your Uwindsor password where username is your Uwindsor username without double
quotes. Eg. cezeife@delta.cs.uwindsor.ca)
The
above connects you only to one of the cs servers like delta specified above the
way a Windows laptop user has connected with SSH client. If you now want to run Sqlplus, you need to
type the sqlplus command like:
sqlplus “username”
password: (type
your Uwindsor password where username is your Uwindsor username without double
quotes. Eg. cezeife)
(To exit Sqlpus, just type exit at the prompt, and to exit SSH terminal,
type another exit at the prompt.)
Video on How to Synchronize your UWindsor
Account With CS server Oracle Sqlplus Account
and Login to Oracle DBMS and Sqlplus
For students,
who want to view the video on how to login to Oracle Sqlplus through
the steps described clearly below, please, view a video created by a former
TA. Talk to a TA or myself during our office hours if you are still
encountering any issues. This is
a link for the tutorial below.
https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/announce/SQLplustutorial_f20.mkv
**
Activating your Computer User Accounts and Accessing your
Webmail
2. More on Accepted SQLPLUS password
Due to
recent changes in campus password complexity, Oracle passwords may pose a
problem for sqlplus logins. The characters that can be used for an Oracle
password without enclosing it in double quotes are the same as any normal
Oracle identifier: only letters, numbers, and the symbols #, _ and $ are
acceptable, and the first character must be a letter. If
the password includes any other characters, the entire password MUST be
enclosed in double quotes for the Oracle login or it might not be
accepted. It is recommended that you
keep your campus password compatible with Oracle password requirements to avoid
Oracle login issues.
first. If you are unable
to resolve the login issue yourself, or are having database rights privileges
in creating or querying tables, send an email to the CS Systems Analyst, Sanjay Chitte, at sanjay.chitte@uwindsor.ca.
To connect to cs.uwindsor.ca servers remotely and be able to
transfer files, you need to download NoMachine or Bitvise SSH. The NoMachine Player
(client) is available for free on many platforms including Windows, Mac OS X,
Linux, Android and iOS (iPad tablets). It can be downloaded from nomachine.com
and we have some instructional documents for users at help.cs.uwindsor.ca.
Read below for specific details.
To download NoMachine and Bitvise SSH, access, go to
the cs download help link or go to:
2. The working alternative most similar to the old
SSH client is the Bitvise SSH Client. Please to
download Bitvise SSH client (not putty), visit: http://www.putty.org/.
1. Follow the instructions and connect
to delta.cs.uwindsor.ca server with NoMachine if not yet
familiar.
2. You now have a virtual machine interface similar to
what you see in the machines on campus in the Java lab or the Leddy Library
lab. Then, left click on Applications on the top menu and select System Tools,
then, Mate Terminal. This creates a terminal for Unix/Linux commands
on a white background.
3. You are now ready to type your Unix/Linux commands for
editing with a text editor (e.g., gedit), connecting to an SQL query
language processor (e.g., sqlplus). You can also use the text
editor pico with any either Bitvise or NoMachine terminal.
4. If you want a copy of any file in the
remote cs server brought to your local home PC, you can then
use Bitvise SSH client file transfer protocol (SFTP), FileZilla
or NoMachine to transfer the files to your local computer (or laptop)
so you can submit the file for assignment solution.
Dr.
C. Ezeife
**