COMP-3150
(60-315-01) WINTER 2024 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.
The
following link is for joining any MSTeams group for
class or during my office hours if meeting moves online on MSTeams:
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 Thursday, April 18, 2024
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,
mostly the one with section A, question 8.
All other adjustments about some GA marking or lack of understanding of
what a natural join is, were not accepted as the marking scheme is very lenient
and the marking done by the GA/TAs were correct. I rounded up marks where necessary. The unofficial
final exam grades that I am going over to submit now can 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 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
Summer and Good Bye.
Dr.
Ezeife, C.
Posted Tuesday, April 16,
2024
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
It
took a long time to mark the final exams. Thanks to all the efforts of the GAs
and TAs who worked tirelessly for a day and half with my detailed marking
scheme and solution (not posted this time for the final exam, but you can view
in the viewing sessions if needed). You do not need to attend the viewing
session if there is nothing you are doubtful of, from your marks.
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 Tuesday,
April 23, 2024 (1:00 to 3:30 pm) in ER 1118 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
tomorrow, Wednesday, Apr. 17, 2024
(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 |
|
Gurpartap Singh Ahluwalia |
|
Sudipta Dhar |
|
Avinash
Karhana |
|
Harnoor
Singh Reen |
|
Muhammad
Umar Khan |
|
Peter
Zoura |
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.
Upcoming Class Events
|
Due Date |
|
|
Tentative Final Exam Viewing |
Wed., Apr. 17, 2024 (10:00am to 4:00pm) in Room LT 3105, meeting with supervising GA/TA in a classroom. |
|
|
Tues,
Apr. 23, 2024 (1:00 to 3.30pm) in ER 1118 managed by Ms
Tina. |
Dr. Ezeife, C.
Posted Wednesday,
March 27, 2024
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 |
|
|
Complete |
|
|
Final
Exam (all materials covered in class) |
Date: Sat., April 13, 2024 |
|
Tentative Final Exam Viewing |
Wed., Apr. 17, 2024 (10:00am to 4:00pm) in Room LT 3105, meeting with supervising GA/TA in a classroom. |
|
Tentative Final Exam Make-up (usually harder
slightly) and for only students |
Friday, May 10, 2024 (1:00 to 3:30 pm) in LT 8118 |
Dr. Ezeife, C.
Posted Monday, March 18, 2024
Dear Comp 3150 Students,
Yee Haa, we
have five more classes left for Comp-3150 on Tuesday, Mar. 19, 2024, Thursday, Mar. 21, 2024; Tuesday Mar. 26, 2024, Thursday, Mar. 28, 2024; and our last class is on Tuesday, April 2,
2024. Thus, there is no Comp-3150 class
on Thursday, Apr. 4, 2024.
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 the 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 grades from that mark). If you notice any discrepancy on your
individual brightspace grade, send email to admin GA
(Sudipta Dhar through dhar2@uwindsor.ca and he 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 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) is usually administered during one of those
remaining classes.
On Final Examination method for this
class this term, it is in-person exam taken only in assigned final exam rooms
of HK 140, 145 (for all Comp 3150 students) on Saturdday,
April 13, 2024, 7:00pm to 9:30pm, which is
during our exact final exam time slot. The final exam for Comp 3150 is
usually a 2 hour 30 minutes 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 you 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. 26, 2024 |
|
|
Complete Chapters 8 and 17 materials Relational
Algebra & Calculus, B and B+-trees, SPT, reviews |
Tuesday, Mar. 19, 2024, Thursday, Mar. 21, 2024, Tuesday Mar. 26, 2024, Thursday, Mar. 28, 2024; and our last class is on Tuesday, Apr. 2, 2024 . |
|
Final
Exam (all materials covered in class) |
Date: Sat., April 13, 2024 |
|
Tentative Final Exam Viewing |
Wed., Apr. 17, 2024 (10:00am to 4:00pm) in Room LT 3105, meeting with supervising GA/TA in a classroom. |
|
Tentative Final Exam Make-up (usually harder
slightly) and for only students |
Friday, May 10, 2024 (1:00 to 3:30 pm) in LT 8118 |
Dr. Ezeife, C.
Posted Saturday, March 9, 2024
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, March 17, 2024 in case you think
you cannot do well in this class.
Section Comp-3150-1 Midterm 2 result summary: |
Average Mark:
75.3% Highest Mark:
100% (obtained by 3 students) Lowest Mark:
6% Number of students
who wrote the test: 149 Number who
got 100%:
3 ( Excellent !!!!!) Number with 90 <= mark < 100: 43
(Excellent !!!!!) Number with
50 <= mark < 80: 56 Number with
mark < 50%:
18 (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. 29, 2024 |
Mar. 21, 2024 |
Final Exam (all materials covered in class) |
Sat. Apr. 13, 2024 |
Sat. Apr. 13, 2024 |
Posted Thursday, February 22, 2024
1.
Note
that Assignment 2 is
due Thursday, Feb. 29, 2024 at 11:30pm 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 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 have gone through through how to log on to sqlplus
and complete assignment 2, que 2 in my last class but will provide more help
with this question 2 and sqlplus in my 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://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.
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, Nov. 2, 2023 (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 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 5, 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
announced.
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) |
Feb. 1, 2024 |
Feb. 29, 2024 |
Midterm 2 (Chs 14, 6, 7) |
|
Mar. 7, 2024 (In class) |
Assn 3 (Chs 6, 7, 8) |
Feb. 29, 2024 |
Mar. 21, 2024 |
Final Exam (all materials covered in class) |
Sat. Apr. 13, 2024 |
Sat. Apr. 13, 2024 |
Posted Friday, February 9, 2024
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. 12. 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 materials
link. 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: 83.5% |
UPCOMING CLASS EVENTS
ASSIGNMENT
& EXAMINATION TENTATIVE SCHEDULE
|
Handed Out (Thurs) |
Due Date (Thurs) |
Assn 2 (Chs 5, 14) |
Feb. 1, 2024 |
Feb. 29, 2024 |
Midterm 2 (Chs 14, 6, 7) |
|
Mar. 7, 2024 (In class) |
Assn 3 (Chs 6, 7, 8) |
Feb. 29, 2024 |
Mar. 21, 2024 |
Final Exam (all materials covered in class) |
Time and Venue (TBA) |
Time and Venue (Venue: TBA) |
Posted Sunday, January 28, 2024
Note
that assignment 1 is due on Thursday, Feb. 1, 2024 at night (11:30pm) 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, Feb. 8, 2024.
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 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 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. 18, 2024 |
Feb. 1, 2024 |
Assn 2 (Chs 5, 14) |
Feb. 1, 2024 |
Feb. 29, 2024 |
Midterm 1 (Chs 1, 2, 3, 5) |
|
Feb. 8, 2024 (In class) |
Midterm 2 (Chs 14, 6, 7) |
|
Mar. 7, 2024 (In class) |
Assn 3 (Chs 6, 7, 8) |
Feb. 29, 2024 |
Mar. 21, 2024 |
Final Exam (all materials covered in class) |
Time and Venue (TBA) |
Time and Venue (Venue: TBA) |
Posted
Monday, January 8, 2024
Dear Winter 2024 Comp 3150
Students,
Welcome to my Winter 2024 class and see you in class on Tuesday, Jan. 9, 2024.
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. Note: Office hours will be held in-person in my office in CS. The following link is for joining any MSTeams group for class or during my office hours if it becomes necessary to move meeting online to MSTeams: 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
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: 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 one drive link for the
tutorial.
One drive link for CS server account synchronization and
Oracle Sqlplus login.
https://uwin365-my.sharepoint.com/:v:/g/personal/cezeife_uwindsor_ca/EYIfq-7a2wFDlD0d9exnuZABEphMzjr8BaFZwgSXrjwNDg?e=HcrodW
**
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
**