Announcements

COMP-3150 (60-315-01) WINTER  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 (60-315-01): T, R (11:30am - 12:50pm) UWindsor as announced in Brightspace.

In the event of an emergency online class, to attend any possible online class if needed on brightspace lms, Log on to Brightspace https://brightspace.uwindsor.ca/d2l/login. Then, click on Virtual classroom, and join Comp 3150 Class session for the day.
 
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/winterindex.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 Saturday, March 8, 2025


Midterm 2 results posted through the web marks link:
http://cezeife.myweb.cs.uwindsor.ca/courses/60-315/marks/index.html.

Great performance in midterm 2 by the class (Well done!!). However, could have been better for some students if they kept up with classes and the work (low consistent class attendance affects level of understanding and performance in course).  The marks are now posted on the web and will be posted later through brightspace forms by GAs.

You can come to my office hour to review your midterm exam if you wish on Mondays (12:00pm to 1:00pm) or Tuesdays (2:00 to 3:00pm) during my office hours.  You can also visit any of the GA/TAs during their office hours posted through the GA/TA office hour link (https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/officehrs/index.html).

Solution to the midterm test is or will also be posted on brightspace through test folder, and going through it may also answer your questions. Do not miss classes as things change quickly.

 

Note that the voluntary withdrawal date is Sunday., Mar. 16, 2025 in case you think you cannot do well in this class.

 

 

Section Comp-3150-1 Midterm 2 result summary:

Average Mark:       74.19%

Highest Mark:        100%   (obtained by 3 students)

Lowest Marks:       15%

Number of students who wrote the test:    149

Number who got 100%:                     3     ( Excellent !!!!!)

Number with 90 <= mark < 100:    38   (Excellent !!!!!)
Number with 80 <= mark < 90:         30   (Excellent !!!!!)

Number with 50 <= mark < 80:         64

Number with mark < 50%:                17    (talk to me in my office hour)

            

 

 

UPCOMING CLASS EVENTS
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE

 

Handed Out (Thurs)

Due Date (Thurs)

Assn 3 (Chs 6, 7, 8)

Feb. 27, 2025

Mar. 20, 2025

Final Exam (all materials covered in class)

Time and Venue : Mon., Apr. 7, 2025, 8.30am; ER 1120

Time and Venue : Mon., Apr. 7, 2025, 8.30am; ER 1120

 


Posted Monday, February 24, 2025 and Final Exam Schedule Updated March 5, 2025

 

1.        Note that Assignment 2 is due Thursday, Feb. 27, 2025 at 11:59pm through only electronic brightspace submission.  Do not submit zipped or tarred or packaged file or html file from chatbots. Assignments are supposed to be done by you and not by chatgpt.  Just submit the .docx or its .pdf assignment file which you had completed with any other adjoining individual files such as Unix script file (.txt) showing your interaction through Sqlplus for your creating, inserting data into your question 2 database as requested by the assignment question. I will post the assn 2 solution by Sunday to assist with test preparation.  Also, note that late assignments are deducted -5 for each day late.

I will provide more help with this question 2 and sqlplus in the next class in the last 10 minutes of class if you have not been able to log in, come then and do it with me as I go along.

 

2.        Note Again on Oracle Sqlplus Login Issues, as announced several times before, you need to synchronize your UWindsor email password with the Oracle Sqlplus password every time you change your UWindsor email password.  To synchronize, go to https://auth.cs.uwindsor.ca/password.

Also, use only your UWindsor userid (without the @uwindsor.ca part).

 

3.     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 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 simply change your Uwindsor password by replacing the strange character like @ with $ at the Uwindsor password page www.uwindsor.ca/userid.   After changing your password each time, you need to go back to the CS server password synchronization page: https://auth.cs.uwindsor.ca/password to re-synchronize before running sqlplus again.

 


If you are having login issues with sqlplus, please check https://help.cs.uwindsor.ca/mediawiki/index.php/SQL*Plus#Troubleshooting 

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 technical crew, Sanjay Chitte, at sanjay.chitte@uwindsor.ca.

 

4.     Note that midterm 2 (with scope Chs 14, 6, 7) is written Thursday, Mar. 6. 2025. (at 11:30am) in person in Toldo 202.  Chapters 6 and 7 discuss SQL DDL commands, SQL DML commands (SPJ, aggregation, group by, nested, etc.). 

 

Prepare for it by going through the practice midterm 2, course notes (chs 14, 6 and 7), book chapters, assignment 2 solutions, working on your assignment 3.  No solutions are posted on brightspace for practice tests but they may be reviewed in class if time permits.  Good Luck in your test.

 

On that test, I will also review your solution to midterm test 2 practice with you in class on Tuesday, Mar. 4, during my class that day in the last 10 to 15 minutes of class.

 

5.     Check all upcoming class events below. Tentative Final exam date has been announced and is updated in the upcoming class events below.

 

Updated class marks can be found through the marks link and report any discrepancies early to me. I have just posted the updated marks on that link.  Admin GA, Gilvari Atefeh, will update later on your brightspace.  I do use the marks spreadsheet for final grade submission and so, it is more important that they are correct and updated on my posted marks link that I manage.

 

Assignment 3 has been posted and can be found in the assignment folder in the course brightspace site.

Also, Midterm 2 practice had been posted on brightspace resource folder.

 

Find GA/TA as well as CS tutor hours of help also through the GA/TA hour link.  

 

UPCOMING CLASS EVENTS
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE

 

Handed Out (Thurs)

Due Date (Thurs)

Assn 2  (Chs 5, 14)

Jan. 30, 2025

Feb. 27, 2025

Midterm 2 (Chs 14, 6, 7)

 

Mar. 6, 2025  (In class)

Assn 3 (Chs 6, 7, 8)

Feb. 27, 2025

Mar. 20, 2025

Final Exam (all materials covered in class)

Time and Venue : Mon., Apr. 7, 2025, 8.30am; ER 1120

Time and Venue : Mon., Apr. 7, 2025, 8.30am; ER 1120

 

Posted Friday, February 7, 2025

Great performance in midterm I by some students in the class (Well done!!).  The marks are now posted on the web Mark link (http://cezeife.myweb.cs.uwindsor.ca/courses/60-315/marks/index.html).           
You can come to my office hour to review your midterm exam if you wish on Mondays (12:00pm to 1:00pm) or Tuesdays (2:00 to 3:00pm) during my office hours starting the week of Feb. 10.  You can also visit any of the GA/TAs during their office hours posted through the GA/TA office hour link: (https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/officehrs/index.html).

Solution to the midterm test is or will also be posted on brightspace through test line. This is an easy test.  Do not miss classes as things change quickly.

Section Comp-3150 (60-315-1) Midterm I result summary:

Average Mark:      77.6%
Highest Mark:       100%   (by 2 students)
Lowest Marks:      32%  
Number of students who wrote the test:        147
Number who got 100%:                                    2
                         (Excellent !!!!!)
Number with 90 <= mark <= 100:                   36
                        (Excellent !!!!!)
Number with 80 <= mark <  90:                      31
                        (Excellent !!!!!)
Number with 50 <= mark < 80:                       74
Number with mark < 50%:                              6    (attend classes and
                                                                                  office hours)

 

UPCOMING CLASS EVENTS
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE

 

Handed Out (Thurs)

Due Date (Thurs)

Assn 2  (Chs 5, 14)

Jan. 30, 2025

Feb. 27, 2025

Midterm 2 (Chs 14, 6, 7)

 

Mar. 6, 2025  (In class)

Assn 3 (Chs 6, 7, 8)

Feb. 27, 2025

Mar. 20, 2025

Final Exam (all materials covered in class)

Time and Venue (TBA)

Time and Venue (Venue: TBA)

 

 

  

 


Posted Sunday, January 26, 2025


Note that assignment 1 is due on Thursday, Jan. 30, 2025 at night (11:59pm) and should be submitted only electronically through brightspace (as a word file or .pdf, and not in a zipped file).  Type your answers in the .docx file I kept for you in the assignment 1 (one) link through brightspace and submit that file electronically. If ER diagram is needed to be drawn, it can be drawn with hand, scanned clearly and submitted as well as a .pdf file with the rest of your assignment 1.

 

Note that Test 1 is written on Thursday, Feb. 6, 2025.
Midterm 1  covers materials from Chs 1, 2, 3, 5 of course book and course notes as summarized also in the upcoming class events in the chart below and also found in the couurse outline. 

I kept a midterm 1 practice test for your use on brightspace through the Test materials folder. Please, note that I do not post solutions to any posted practice test.  It is for you to work on and bring up any discussions to me or GA/TA.  I do go through them with you in the class in a class before the test though to discuss your solutions.  Thus, go to classes.  Classes are already beginning to thin down in attendance and it obviously affects your understanding of course materials when you drop in and out of classes.

  

Assignments already handed out in class can be found in the assignment folder in the course brightspace site. Assignment 2 is already handed out.

 

All posted test materials can be found in the test materials folder in the course brightspace site.  Please, note that all test practice materials are intended to help students work on the materials and be prepared for class. I do not post solutions to test/exam practices but will post solutions to tests, and assignments.  I normally would still review the test practices with students in the class or during my office hours before the test/exam if they bring their answers for discussion.

 

Find GA/TA as well as CS tutor hours of help also through the GA/TA hour link in brightspace or directly through
https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/officehrs/index.html.

 

UPCOMING CLASS EVENTS
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE

 

Handed Out (Thurs)

Due Date (Thurs)

Assn   1 (Chs 1, 2, 3)

Jan. 16, 2025

Jan. 30, 2025

Assn 2  (Chs 5, 14)

Jan. 30, 2025

Feb. 27, 2025

Midterm 1 (Chs 1, 2, 3, 5)

 

Feb. 6, 2025 (In class)

Midterm 2 (Chs 14, 6, 7)

 

Mar. 6, 2025  (In class)

Assn 3 (Chs 6, 7, 8)

Feb. 27, 2025

Mar. 20, 2025

Final Exam (all materials covered in class)

Time and Venue (TBA)

Time and Venue (Venue: TBA)

 

 

Posted Sunday, January 5, 2025
 

Dear Winter 2025 Comp 3150 Students,
Welcome to my Winter 2025 class and see you in class on Tuesday, Jan. 7, 2025.

Course Instructor: Dr. C. I. Ezeife

 

E-mail:                    cezeife@uwindsor.ca

Office Location:    CS   room; office phone: 519-253-3000 ext. 3012

Office Hours:         Mon: 12:00pm – 1:00pm; Tues: 2:00-3:00pm;

                               

Classes: Tues, Thurs : 11:30am – 12:50pm;  Room : As announced in brightspace.

If it becomes necessary to move any class online, to attend any possible online class, Log on to Brightspace LMS (learning management system). https://brightspace.uwindsor.ca/d2l/login.

Then, click on Virtual classroom, and join Comp 3150 Class session for the day.

 

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/winterindex.html.

 

Course Required Materials:

C.I Ezeife, Course Notes for Comp-3150 (60-315), Database Management Systems, University of Windsor, Fall 2024/Winter 2025.

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.
prices: US$50.94 from Pearson;on;  $235.00 from Amazon; 

 

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   

 

2.     You need to synchronize your UWindsor email password with the Oracle Sqlplus password (i) every time you change your UWindsor email password, (ii) first time you are logging onto Sqlplus on cs servers, and (iii) any time you are working on Sqlplus on our cs server and got locked out. 
To synchronize, go to https://auth.cs.uwindsor.ca/password.  Then, follow the appropriate buttons to synchronize.

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 

Make sure that your computer user accounts are activated by going to : www.uwindsor.ca/userid

And to access your email, go to url: https://outlook.office.com/mail/

 

1.      Note on Oracle Sqlplus Login Issues, you need to synchronize your UWindsor email password with the Oracle Sqlplus password (i) every time you change your UWindsor email password, (ii) first time you are logging onto Sqlplus on cs servers, and (iii) any time you are working on Sqlplus on our cs server and got locked out. 
To synchronize, go to https://auth.cs.uwindsor.ca/password.  Then, follow the appropriate buttons to synchronize. Use only your UWindsor userid without the @uwindsor.ca part.

 

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.


If you are having login issues with sqlplus, please check https://help.cs.uwindsor.ca/mediawiki/index.php/SQL*Plus#Troubleshooting 

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.

 

How to Connect to CS Servers (cs.uwindsor.ca)

On how to connect to our Computer Science servers called alpha.cs.uwindsor.ca, bravo.cs.uwindsor.ca, charlie.cs.uwindsor.ca, delta.cs.uwindsor.ca to do your work, since we are no longer able to connect to the cs servers with the secure shell client (ssh/sftp) program, you can use either NoMachine or Bitvise SSH. 

 

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 videos 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 at:

1.     NoMachine to find the download link: https://www.nomachine.com/download.  Then, download the NoMachine suitable for your own device. 

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/.

3.     Ensure that you set the protocol to ssh(not nx) and that you connect to nx.cs.uwindsor.ca (not cs.uwindsor.ca) during set up of Bitvise SSH client .

4.     You can also download the Fillezilla secure file transfer protocol through the link: https://filezilla-project.org/ (download the Fillezilla client).

 

How to Use NoMachine  to  connect to CS Servers (cs.uwindsor.ca) and Open up an X terminal to run SqlPlus

1.     Follow the instructions and connect to cs.uwindsor.ca servers 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 West 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

 

**

 

weblinks