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 Saturday,
November 22, 2025
Note the remaining scheduled class events below. Marks for Assignment 3
will be updated on the Marks web site once marking is
completed. Check that all your updated marks are correct on this
marks spreadsheet or send a mail to me asap.
Steps for completing online SPTs
(student perception of teaching (formerly called SET)) in the next few days and
class are shown below.
SPTs provide students with an opportunity for
feedback regarding their course and instructor in order to
enhance the teaching/learning culture on campus.
To access and complete an online SPT:
1. In your web browser, preferably Google Chrome,
go to www.uwindsor.ca/uwinsitestudent.
2. Click the blue SIGN
IN TO UWINSITE STUDENT button.
3. On the Sign
in screen, enter (or select) your UWinID@uwindsor.ca.
Click the Next button.
4. On the Enter
password screen, enter your UWin Account password.
Click the Sign in button.
5. On your Student
Homepage in UWinsite Student, click
the My Academics tile.
6. Click Student
Perception of Teaching in the left
navigation menu.
7. Select the appropriate term and click the Continue button.
8. In the STUDENT
PERCEPTION OF TEACHING box, click the Start button. Please note that the Start button is active
during the last 2 weeks of classes only. You will not be able to complete
your course SPT prior to this time or once your term has completed. SPTs
will show UNAVAILABLE if they are not active.
o
For courses that have
both an instructor and an academic coordinator, PLEASE
SELECT YOUR INSTRUCTOR'S NAME WHEN COMPLETING THE SPT.
Follow the instructions within the SPT in order to complete and submit.
If you encounter a technical issue completing a SPT
through UWinsite Student, please submit a ticket here.
Upcoming Class Events
|
|
Due Date |
|
|
Complete Chapters 8 and 17 materials Relational
Algebra & Calculus, B and B+-trees, SPT,
reviews |
|
|
Final
Exam (all materials covered in class) |
Date: Tues. Dec. 16, 2025. |
|
Tentative Final Exam Viewing |
Fri., Dec. 19, 2025 (10:00am to 4:00pm) in |
|
Tentative Final Exam Make-up (usually harder
slightly) and for only students |
Friday, Jan. 9, 2026 (1:00 to 3:30 pm) in LT 8118 |
Dr. Ezeife, C.
Posted Saturday, November 8, 2025
Dear Comp 3150 Students,
Assignment 3 due date has been extended to
Thursday, Nov. 20, 2025. This is
absolutely the only extension that will be granted for this assignment.
Yee Haa, we
have six more classes left for Comp-3150 on
Tuesday,
Nov. 11, 2025; Thursday, Nov. 13, 2025, Tuesday, Nov. 18, 2025; Thursday, Nov. 20, 2025, Tuesday, Nov.
25, 2025 and our last class is on Thursday, Nov. 27,
2025. Thus, there is no Comp-3150 class on
Tuesday, Dec. 2, 2025.
Marks going into the final exam is updated always
and posted through the marks link:
http://cezeife.myweb.cs.uwindsor.ca/courses/60-315/marks/index.html. Note that having an A range grade (that is
>= 80%) going into the exam does not guarantee strong marks for final grade
if you have been missing last segments of course materials. Let me (cezeife@uwindsor.ca) know of any
discrepancies in the posted web marks soon (I mean on the spreadsheet mark
posted through my web site as I will submit final grade from that mark). If you notice any discrepancy on your
individual brightspace grade, send email to admin GA
(Ganiyat
Afolabi-Yusuf through afolabig@uwindsor.ca and she will take care of that).
As with other tests, I have put together final exam
practice questions which I posted/or will post through brightspace,
resource and test materials folder, as part of my review classes. Note that no solutions posted on test folder
except for those discussed in my classes just like I did with other tests. We
shall be discussing parts of question 4 (construction of the B-tree and
B+-tree) of the final practice. I will
continue to review questions from there and any other you may have in
preparation for your final exam in my next few classes as needed. SPT (student
perception of teaching, formerly called SET) will usually be administered
during one of those remaining classes.
On Final Examination method for this
class this term, it is in-person exam taken in room CAW centre GYM (for all Comp
3150 students) on Tuesday, Dec. 16, 2025, 12:00pm to 2:30pm, which is during
our exact final exam time slot. The final exam for Comp 3150 is usually a 2 hour 30minute exam.
It is a closed book exam like the other two tests. No use of browsers, email or texting, no
copying or discussing the test with other course mates or people are allowed
during this final exam period (except for communicating with the Professor or
the GA/TA proctor in the exam room).
Exam should be written by only the student. It should just be the same
type of exam that others wrote on taught course materials.
GOOD LUCK in your final exams !!!
Note the remaining scheduled class events below.
Upcoming Class Events
|
|
Due Date |
|
|
Assn 3 (Chs 6, 7, 8) |
Tues. Nov. 20, 2025 (this is an extension) |
|
|
Complete Chapters 8 and 17 materials Relational
Algebra & Calculus, B and B+-trees, SPT,
reviews |
Tuesday, Nov. 11, 2025; Thursday, Nov. 13, 2025, Tuesday, Nov. 18, 2025; Thursday, Nov. 20, 2025; Tuesday, Nov. 25, 2025 and our last class is on Thursday, Nov. 27, 2025 . |
|
Final
Exam (all materials covered in class) |
Date: Tues. Dec. 16, 2025. |
|
Tentative Final Exam Viewing |
Fri., Dec. 19, 2025 (10:00am to 4:00pm) in TBA meeting with supervising GA/TA in a classroom. |
|
Tentative Final Exam Make-up (usually harder
slightly) and for only students |
Friday, Jan. 9, 2026 (1:00 to 3:30 pm) in TBA |
Dr. Ezeife, C.
Posted Friday, October 31, 2025
Midterm 2 results posted through the web
marks link:
http://cezeife.myweb.cs.uwindsor.ca/courses/60-315/marks/index.html.
Always, refresh your browser to ensure you are viewing the newly updated marks.
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 Wed., Nov. 12, 2025 in case
you think you cannot do well in this class.
|
Section Comp-3150-1 Midterm
2 result summary: |
|
Average
Mark: 75.8% Highest
Mark: 100%
(obtained by 1 student) Lowest
Marks: 25% Number of
students who wrote the test: 126 Number
who got
100%:
1 ( Excellent !!!!!) Number with 90 <= mark < 100: 27 (Excellent
!!!!!) Number
with 50 <= mark < 80: 60 Number
with mark < 50%:
7 (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) |
Oct. 23, 2025 |
Nov. 13, 2025 |
|
Final Exam (all materials covered in class) |
Time and Venue : Tue., Dec.
16, 2025, 12.00-2:30pm; CAW centre; GYM |
Time and Venue : Tue., Dec.
16, 2025, 12.00-2:30pm; CAW centre; GYM |
Posted Sunday, October 19, 2025
1.
Note
that Assignment 2 is
due Thursday, Oct. 23, 2025 at 11:59pm through only
electronic brightspace submission. Do not submit zipped or tarred or packaged
file. 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 2 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 next Tuesday 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
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, Oct. 30. 2025. (at 11:30am) in person
in Toldo 102. Chapters 6 and 7 discuss SQL
DDL commands, SQL DML commands (SPJ, aggregation, group by, nested, etc.).
Prepare for the test 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 just before the test. 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, Oct. 28, 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 to be
announced as soon as published by the registrar and hopefully soon.
Updated class marks can be
found through the marks link and report any discrepancies early to me.
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) |
Sep. 25, 2025 |
Oct. 23, 2025 |
|
Midterm 2 (Chs 14, 6, 7) |
|
Oct. 30, 2025 (In class) |
|
Assn 3 (Chs 6, 7, 8) |
Oct. 23, 2025 |
Nov. 13, 2025 |
|
Final Exam (all materials covered in class) |
Time and Venue : Tue., Dec.
16, 2025, 12.00-2:30pm; CAW centre; GYM |
Time and Venue : Tue., Dec.
16, 2025, 12.00-2:30pm; CAW centre; GYM |
Posted Friday, October 3, 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 Oct. 8. 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: 79.74% |
UPCOMING CLASS EVENTS
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE
|
|
Handed Out (Thurs) |
Due Date (Thurs) |
|
Assn 2 (Chs 5, 14) |
Sep. 25, 2025 |
Oct. 23, 2025 |
|
Midterm 2 (Chs 14, 6, 7) |
|
Oct. 30, 2025 (In class) |
|
Assn 3 (Chs 6, 7, 8) |
Oct. 23, 2025 |
Nov. 13, 2025 |
|
Final Exam (all materials covered in class) |
Time and Venue (TBA) |
Time and Venue (Venue: TBA) |
Posted Friday, September 19, 2025
Note that assignment 1 is due on Thursday, Sept. 25, 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 your ER diagram is drawn with hand, scan
clearly and submit that as well as a .pdf file with the rest of your assignment
1.
Note that Test 1 is written on
Thursday, Oct. 2, 2025.
Midterm 1 covers
materials from Chs 1, 2, 3, 5 of course book and
course notes as summarized also in the upcomint class
events in the chart below and also found in the course
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 updated 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) |
Sep. 11, 2025 |
Sep. 25, 2025 |
|
Assn 2 (Chs 5, 14) |
Sep. 25, 2025 |
Oct. 23, 2025 |
|
Midterm 1 (Chs 1, 2, 3, 5) |
|
Oct. 2, 2025 (In class) |
|
Midterm 2 (Chs 14, 6, 7) |
|
Oct. 30, 2025 (In class) |
|
Assn 3 (Chs 6, 7, 8) |
Oct. 23, 2025 |
Nov. 13, 2025 |
|
Final Exam (all materials covered in class) |
Time and Venue (TBA) |
Time and Venue (Venue: TBA) |
Posted
Monday, August 11, 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.
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)
(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:
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
**