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 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
**