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 Friday, April 11, 2025
Dear Comp 3150 Students,
I have just posted the adjusted updated unofficial
final marks which includes all of the final exam viewing log reviews. I personally went through all the scripts to
make the necessary and legitimate adjustments. I looked through all final exam
viewing session comments and emails final exam review requests and made
necessary adjustments. If you sent me a private email, I may still respond but
had been working on these with other deadlines since the exam was written. Any other adjustments about some GA marking or
lack of understanding of Section B question 3 (queries in SQL, relational algebra
and relational calculus) and question 4 (B-tree and B+-tree) were not accepted
as the marking scheme is very lenient and the marking done by the GA/TAs were mostly
correct. I rounded up marks where
necessary and as I promised in the first class to reward hard work for all who
did all course work and are on the edge of a grade level up. The unofficial final exam grades that I have
just submitted to the registrar’s office can now be found through the marks
link below. Refresh your browser to always get the updated post:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/marks/index.html
Note that when I submit grades to the registrar’s office
through UWinsite, it may still take some time for you to view it through your
UWinsite as they have to be first approved by the head of the department and
then the Dean of Science before it is released.
Scroll down on the marks page to see the summary statistics of
performance.
Happy Upcoming Easter and have a Happy Summer. Good Bye.
Dr. Ezeife, C.
Posted Wednesday, April 9, 2025
Dear Comp 3150 Students,
I have just posted the updated unofficial final
marks which includes the final exam marks through the marks link below. Refresh
your browser to always get the updated post:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/marks/index.html
Scroll down on the marks page to see the summary statistics of
performance.
As
announced in my course outline, if you completed all course work and need less
than 1% to get to the next grade level, I will round you up using the unrounded
total.
Also, as announced before, there is only one
make-up final exam for only approved students who did not write the final exam
due to illness (approved Computer Science medical certificate submitted to me
through email or my mailbox through the secretaries) soon or within a day of
the final exam. The final exam make-up date of Friday, May 9,
2025 (1:00 to 3:30 pm) in LT 3105 will be used for those pre-approved.
NO OTHER FINAL EXAM MAKE-UP DATE WILL BE FIXED FOR THIS COURSE THIS TERM.
In compliance with Senate Bylaw,
Final exam viewing for the marked exams is holding as scheduled for Thursday,
April 10, 2025 (10.00am to 4:00pm) in room
LT 3105 with the supervising GA/TAs:
GA/TA emails are: (Note that only some GAs are scheduled for some hours
during the period). Students are not allowed to remove the exam papers from the
room.
GA/TA
Information
|
GA/TA Names |
|
|
Gilvari Atefeh |
|
|
Damian Attia-Barillas |
|
|
Nguyen Hai |
|
|
Prabhakar Asmita |
|
|
Rashid Arfaa |
|
|
Nasrin Tavakoli |
This is supervised by the GA/TA
and log in any requests, comments, concerns and I will look into all before
submitting the final marks soon. This is the only opportunity to go and review
your final exam paper. Please, do not wait and try to request individual
appointments with the Professor for final exam reviews without using this
opportunity. All other comments after review you can send to me through final
exam viewing log.
Note the remaining scheduled class events below.
|
|
Due Date |
|
|
Tentative Final Exam Viewing |
Thurs., Apr. 10, 2025 (10:00am to 4:00pm) in LT 8118 meeting with supervising GA/TA in a classroom. |
|
Tentative Final Exam Make-up
(usually harder slightly) and for only students |
Friday, May 9, 2025 (1:00 to 3:30 pm) in LT 3105 |
Dr. Ezeife, C.
Posted Saturday, March 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.
Note the remaining scheduled class events below.
Upcoming
Class Events
|
|
Due Date |
|
|
Assn 3 (Chs 6, 7, 8) |
Tues. Mar. 25, 2025 (this
is an extension) |
|
|
Complete Chapters 8 and 17
materials Relational Algebra & Calculus, B and B+-trees, SPT,
reviews |
Thursday, Mar. 20, 2025, Tuesday, Mar. 25, 2025; Thursday, Mar. 27, 2025, and our last class
is on Tuesday, Apr. 1, 2025. |
|
Final
Exam (all materials covered in class) |
Date: Mon. Apr. 7, 2025. |
|
Tentative Final Exam Viewing |
Thurs., Apr. 10, 2025 (10:00am to 4:00pm) in LT 8118 meeting with supervising GA/TA in a classroom. |
|
Tentative Final Exam Make-up
(usually harder slightly) and for only students |
Friday, May 9, 2025 (1:00 to 3:30 pm) in LT 3105 |
Dr. Ezeife, C.
Posted Wednesday, March 19, 2025
Dear Comp 3150 Students,
Assignment 3 due date has been extended
to Tuesday, Mar. 25, 2025. This is the
only extension that will be granted for this assignment.
Yee Haa, we have four more classes left
for Comp-3150 on
Thursday,
Mar. 20, 2025, Tuesday, Mar. 25,
2025; Thursday, Mar. 27, 2025, and our
last class is on Tuesday, Apr. 1, 2025. Thus, there is no Comp-3150 class on Thursday, Apr. 3,
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 (Asmita Prabhakar through prabha31@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 rooms ER 1120 (for all Comp 3150 students) on Monday, Apr.
7, 2025, 8:30am to 11:00am, 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. Mar. 25, 2025 (this
is an extension) |
|
|
Complete Chapters 8 and 17
materials Relational Algebra & Calculus, B and B+-trees, SPT,
reviews |
Thursday, Mar. 20, 2025, Tuesday, Mar. 25, 2025; Thursday, Mar. 27, 2025, and our last class
is on Tuesday, Apr. 1, 2025. |
|
Final
Exam (all materials covered in class) |
Date: Mon. Apr. 7, 2025. |
|
Tentative Final Exam Viewing |
Thurs., Apr. 10, 2025 (10:00am to 4:00pm) in LT 8118 meeting with supervising GA/TA in a classroom. |
|
Tentative Final Exam Make-up
(usually harder slightly) and for only students |
Friday, May 9, 2025 (1:00 to 3:30 pm) in LT 3105 |
Dr. Ezeife, C.
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.
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 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
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.
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% |
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: Office Hours: |
|
Classes: Tues,
Thurs : 11:30am – 12:50pm; Room :
As announced in brightspace. 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. 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: 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.
|
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.
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 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:
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 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
**