COMP-4150 (60-415-01) FALL 2021 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-4150-1 (60-415-01): Mon (2:30pm - 5:20pm) ONLINE in
BLACKBOARD VIRTUAL CLASSROOM
To attend class, Log on to Black
Board http://blackboard.uwindsor.ca.
Then, click on Virtual classroom, and join Comp 4150 Class session for the day.
For example, to join the class session for our first class on Sep. 13, 2021,
click on “Comp 4150 Fall 2021: 13/09/21, 2:30pm to 5:20pm” and join this
session from around 15 minutes to beginning of class time of 2:30pm for Comp
4150.
Office
hours:
Comp-4150-1 (60-415-1): M, 11:00am-12:00pm in ONLINE THROUGH MSTEAMS
Note: Office hours will be held through MSTeams.
The following link is for joining the MSTeams group
for class during my office hours:
https://teams.microsoft.com/l/team/19%3a72493f7a43c14bc19db3babd60a38030%40thread.tacv2/conversations?groupId=e0eff085-f631-4f24-bab1-943a08727a68&tenantId=12f933b3-3d61-4b19-9a4d-689021de8cc9
Course Web Page can be
accessed through: http://blackboard.uwindsor.ca Or http://cezeife.myweb.cs.uwindsor.ca/courses/60-415/415index.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 Wednesday, December 1, 2021
Note the remaining scheduled class
events below. Marks for Project Phase 3 is updated on the Marks web site and
the project presentation mark is yet to be included. Check that all
your updated marks are correct on this marks spreadsheet or send a mail to me
asap. Last class is on Dec. 6.
Steps for completing online SETs in
the next few days and class are shown below.
As Fall semester courses are primarily online,
Fall SETs will be completed online.
To access and complete an online SET, follow the steps below:
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
Evaluation of Teaching in the left navigation menu.
7. Select the
appropriate term and click the Continue button.
8. In
the STUDENT EVALUATION OF TEACHING box, click the Details button.
9. Complete
the online SET and then
1. Click
the Submit button to submit your evaluation.
2. Click
the Save button to save your responses if you need to come
back and complete the evaluation later.
If you encounter a technical issue completing
a SET through UWinsite Student,
please submit a ticket here.
Upcoming Class
Events
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE
|
|
Handed Out (Mondays) |
Due Date (Mondays) |
|
Project
Presentation/Report |
----- |
Nov.
29, 2021/ Dec. 6 |
|
Remaining
classes are on Dec. 6 |
|
|
Posted Friday, November 19, 2021
Dear Comp-4150 students,
We have only three classes left on Monday, Nov. 22, 2021 (Sergio
will drop in at 3:00pm to help with any questions on the php
front-end, project also due that day in the night. May be late in a day if needed), Monday, Nov.
29 (all project demonstrations/presentation and report due that day), Monday,
Dec. 6, 2021 (SET and any presentations not completed). Note that attendance at
presentations on Nov. 29 is mandatory as part of course work.
Note the remaining scheduled class
events below. Marks for Lab 3 and Test have been updated on the Marks web site:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/marks/index.html.
Check
that all your updated marks are correct on this marks spreadsheet or send a
mail to me asap.
Congratulations
on Test performance. Summary is provided
below.
|
Section Comp-4150-1 Midterm Test result summary: |
|
Average Mark:
83.3% Highest
Mark: 99%
(obtained by 1 student) Lowest
Marks: 63% Number of students who wrote the test: 57 Number who got
100%:
0 ( !!!!!) Number with 90 <= mark < 100: 10
(Excellent
!!!!!) Number with 50 <= mark < 80: 20 Number with mark < 50%: 0
|
Find GA/TA as well as CS tutor hours of help also through the
GA/TA hour link in blackboard or directly through
https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/officehrs/index.html.
Upcoming Class
Events
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE
|
|
Handed Out (Mondays) |
Due Date (Mondays) |
|
Project
Phase 3 ( ) |
Oct.
4, 2021 |
Nov.
22, 2021 |
|
Project
Presentation/Report |
----- |
Nov.
29, 2021 |
|
Remaining
classes are on Nov. 22, Nov. 29 and Dec. 6 |
|
|
Posted Saturday, November 13, 2021
Dear Comp-4150 students,
As you already know, Midterm Test for Comp 4150 is this coming Monday, Nov. 15, 2021 during class time online in blackboard. There is no make-up test for any missed test. Please, read the instructions below carefully. There will be no chat messages during tests. Test scope covers all materials so far discussed in class and in the labs and project phases as shown in the sample test in black board including (Advanced Databases: Chapters 14, 10, 11, 13, 20, 21, 22, 24; Part B. Oracle PL/SQL and Part C: General PHP front-end). Students will be able to contact me or the proctoring GA/TAs through email. Read more details below. Go to classes as things turn around very quickly. Good Luck in your midterm test. Check other upcoming class events below.
INSTRUCTIONS (Please Read Carefully)
Examination Period is 2 hours 30 minutes (For online version time extended to 4
hours)
Answer all questions. Write your answers in the spaces provided in
the question paper. This is closed book and closed notes test. You
can type in your answers into the word file and submit, or print, write with
hand, scan clearly into only a .pdf or .jpeg file and submit.
Total Marks =100.
Total number of sections = 3
Please
read questions carefully! Misinterpreting a question intentionally or
unintentionally results in getting a “ZERO” for that question. Good Luck!!!
CONFIDENTIALITY
AGREEMENT & STATEMENT OF HONESTY
I confirm that I will keep the content of this
assignment/examination confidential.
I confirm that I have not received any unauthorized assistance in
preparing for or doing examination. I confirm knowing that a
mark of 0 may be assigned for copied work.
For Online Test/Examination in Comp 4150 Fall 2021: (additional
rules to be observed):
1. I confirm that I agree to write this final examination as a closed book
examination.
2. I confirm that I am the student with the name and student id signed
below.
3. I confirm that I agree to not send email, chat, text or talk in
any way to people other than the instructor or proctoring GA of this course
during this examination.
4. I confirm that I agree to not engage in copying or cheating
during this online examination.
________________________________________ ________________________________________
Student
Signature Student
Name (please print)
________________________________________ ________________________________________
Student I.D.
Number Date
_________________________________________________________________________________________________________
To write the Online Midterm Test, log on to Black
board (BB) virtual class room at class time, and go to Resource page of the Black
Board for Course, go to the Test Materials link to download the Course Comp
4150 Midterm Test. You can do the test
in one of these three ways:
1. Print it, write it with hand, scan clearly with camera
saved only in a .pdf or .jpeg file and submit back through the assignment link
before the end of test period. Submitting wrong file or wrong format will attract a penalty of -5 if you
have to be contacted.
2. Type in all your answers in the word file and submit.
3. Use a combination of methods 1 and 2 above.
4. Check your email for any typographical corrections in
test paper before final submission.
Use of chat in BB is disallowed to reduce chances of cheating. Please, send mail to Professor Ezeife (cezeife@uwindsor.ca) if you have any questions.
For proctoring on
Thursday, Nov. 15, 2021 at 2:30pm, arrive in the BB virtual class room at least
15 minutes before 2:30pm. I will disable
chat option for students to cut down on incidents of cheating. Students can raise hands when they have a
question so that the proctoring GA in charge of the student can communicate
with them through email only. GA/TA will be responsible for students during
proctoring as follows:
|
GA/TA Name |
GA/TA email |
Student to Proctor |
|
Saadhika Bandreddy |
bandred@uwindsor.ca |
all |
Find GA/TA as well as CS tutor hours of help also through the
GA/TA hour link in blackboard or directly through
https://cezeife.myweb.cs.uwindsor.ca/courses/60-315/officehrs/index.html.
Upcoming Class
Events
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE
|
|
Handed Out (Mondays) |
Due Date (Mondays) |
|
Project
Phase 3 ( ) |
Oct.
4, 2021 |
Nov.
22, 2021 |
|
Project
Presentation/Report |
----- |
Nov.
29, 2021 |
|
Midterm
Test (all materials so far covered in class and not including Ch. 30 ) |
----- |
Nov.
15, 2021 (In class) |
Posted
Sunday, November 7, 2021.
I. More Clarification on Lab 3 and Project Phase 3 Requirements.
Lab 3 is to move you forward towards
completing your web application as presented in project phase 3. Thus, I
have no strict number of features for Lab 3 as long as there is an application
with a web link for the company database built to be run by a user. I believe
project phase 3 wants a minimum of 15 features for each student. A feature is
like a query or type of query or functionality provided by the application
(such as login control, etc.). You designed the features in you phase
1. Re-use them so you do not need to re-do the work.
Lab
3 encourages you to start to build your web application by first giving you
some directions on how to create a database on our cs
mysql database on php admin,
uploading a .php file with other needed files in your
domain and executing through a web site link from your domain. I have
gone through this in class several times for students who attend.
I
also left sample .php files in blackboard
resource/project materials folder for the simple database application you can
run through the web links: http://oliveirs.myweb.cs.uwindsor.ca/simple/
Or
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/phpfiles/simple/index.php
You
can download these .php templates and modify them to
begin to build you own simple web database application. A good php tutorial
web site for assisting you with the syntax of the php
front-ent scripting language is: https://www.w3schools.com/php/.
Our
Comp-4150 Chapter 11: Web Database Programming Using PHP slide
and lecture notes also provided an introduction and summary of PhP language.
Then,
Lab 3 provides you with a sample set of queries and form interface you can
first begin to implement in section B. It is up to you to keep adding as
many queries as possible as this is now the project you continue with and bring
along to phase 3. Some sample queries are:
Part B. Some sample queries you can pose and present on your
application are:
(A sample simple PhP file for a similar
exercise developed by Sergio is in the database tool folder and you can revise
to create yours)
… 50 marks
Part of what the project phase
3 requirement wants is given below.
B. Project Phase 3 (Database Application
to be delivered) …(worth 50%)
Hand in:
i. a zipped file containing the
application and all files needed to create the database and run it.
…. Main Components Graded:
Guide on what constitutes a
minimal set of functionalities for each individual is given in lab 3, part B as
shown below [For reminder and information only]:
Part B: Design the Company Information System
or other Database Application based on the System Interface, database schema,
constraints and query design, sample PL/SQL codes already designed in phases 1
and 2 of this project.
Thus,
it is not for me to place strict numbers on lab 3. The more features you
implement in lab 3, the less work you have left for phase 3. A feature is
like those types of queries you constructed in project phase 1, e.g., querying
one table, more than one table, posing aggregate queries, adding entities
(e.g., project, employee), updating entities, etc.
II.
More Clarification on Comp 4150 Test Coming up
Monday Nov. 15, 2021 Requirements.
Note that as announced in my last class, I have posted a sample test practice
with solutions on blackboard through resource test materials. Good Luck in preparing for your test coming
up next Monday.
On Marks:
I have posted the Lab Exercise 2 marks on the course mark web link
at:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/marks/index.html
Project Phase 2 marks will be posted once the GAs finish marking
them.
The marks are also accessed through your blackboard.
Upcoming Class Events
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE
|
|
Handed Out (Mondays) |
Due Date (Mondays) |
|
Lab
Exercise 3 ( ) |
Oct.
4, 2021 |
Nov.
8, 2021 |
|
Project
Phase 3 ( ) |
Oct.
4, 2021 |
Nov.
22, 2021 |
|
Project
Presentation/Report |
----- |
Nov.
29, 2021 |
|
Midterm
Test ( ) |
----- |
Nov.
15, 2021 (In class) |
Posted Monday, October 18, 2021.
Students are reminded that it is important to attend classes. Provision of materials on the web should not
be seen as a substitute for classes.
I have posted the Lab Exercise 1 and Project Phase 1 marks on the
course mark web link at:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/marks/index.html
It is also accessed through your blackboard. The GAs will release your marks on blackboard
soon too.
Let the admin GA, Li Zhou (zhou18j@uwindsor.ca) or myself know of
any discrepancies in marking that we can look into. If you have any course questions, the
electronic GA is Saadhika Bandreddy
(bandred@uwindsor.ca). Send email
questions on course materials you have to the electronic GA holding also
electronic office hours.
Come to my office hour to discuss any difficulties you may be
having starting and progressing with your course project and material so we can
figure a way out early.
Note that GA office hours are updated and available on the GA/TA
link through blackboard or directly through:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/hours/index.html
Check the course outline and other course contents through
blackboard and on the course web page.
Upcoming Class
Events
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE
|
|
Handed Out (Mondays) |
Due Date (Mondays) |
|
Lab
Exercise 2 ( ) |
Sept.
27, 2021 |
Oct.
25, 2021 |
|
Lab
Exercise 3 ( ) |
Oct.
4, 2021 |
Nov.
8, 2021 |
|
Project
Phase 2 ( ) |
Sept.
27, 2021 |
Nov.
1, 2021 |
|
Project
Phase 3 ( ) |
Oct.
4, 2021 |
Nov.
22, 2021 |
|
Project
Presentation/Report |
----- |
Nov.
29, 2021 |
|
Midterm
Test ( ) |
----- |
Nov.
15, 2021 (In class) |
Posted Thursday,
September 23, 2021.
Students are reminded that it is important to attend classes. Provision of materials on the web should not
be seen as a substitute for classes.
Note that GA office hours are updated and available on the GA/TA
link through blackboard or directly through:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/hours/index.html
Check the course outline and other course contents through blackboard
and on the course web page.
Upcoming Class
Events
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE
|
|
Handed Out (Mondays) |
Due Date (Mondays) |
|
Lab
Exercise 1 ( ) |
Sept.
13, 2021 |
Oct. 4 |
|
Lab
Exercise 2 ( ) |
Sept.
27, 2021 |
Oct.
25, 2021 |
|
Lab
Exercise 3 ( ) |
Oct.
4, 2021 |
Nov.
8, 2021 |
|
Project
Phase 1 ( ) |
Sept.
13, 2021 |
Oct.
4, 2021 |
|
Project
Phase 2 ( ) |
Sept.
27, 2021 |
Nov.
1, 2021 |
|
Project
Phase 3 ( ) |
Oct.
4, 2021 |
Nov.
22, 2021 |
|
Project
Presentation/Report |
----- |
Nov.
29, 2021 |
|
Midterm
Test ( ) |
----- |
Nov.
15, 2021 (In class) |
Posted
Wednesday, September 8, 2021
Dear Fall 2021 Comp 4150
Students,
Welcome to my Fall 2021 class and see you in class on Monday, Sept. 13, 2021
through online blackboard virtual classroom. To
attend class, Log on to Black Board http://blackboard.uwindsor.ca.
Then, click on Virtual classroom, and join Comp 4150 Class session for the day.
Course Web Page is open and can
be accessed through blackboard (http://blackboard.uwindsor.ca) site, course note site or directly through:
http://cezeife.myweb.cs.uwindsor.ca/courses/60-415/415index.html
Course Text:
Required Materials:
C.I Ezeife, Course Notes for Comp-4150 (60-415), Advanced and Practical Database Systems, University of Windsor, Fall 2021.
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.
Benjamin Resenzweig and Elena Rakhimov,
“Oracle PL/SLQ by Example”, publisher: Pearson PTG, 2015 edition 5, Print ISBN: 9780133796780, 0133796787;
ISBN(e-text): 9780133798531, 0133798534.
Reference
Materials:
Ben Forta, SQL in 10 Minutes a Day, Sams Teach Yourself, 2020, 5th edition, Pearson, Print ISBN: 9780135182796, 0135182794, eText ISBN: 9780135182864, 0135182867.
Catherine M. Ricardo, Susan D. Urban, Databases Illuminated, 2017, 3rd edition, Jones & Bartlett Learning, ISBN: 978-1-284-05694-5.
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:
http://cezeife.myweb.cs.uwindsor.ca/courses/60-415/415index.html.
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 of how to login to Oracle
Sqlplus through the steps described clearly below, please,
view a video created by the TA, Mustafa Al_windawi. Talk to a TA or myself during our office
hours if you are still encountering any issues.
This is a google drive link that you may have to download first
before viewing.
(https://drive.google.com/file/d/1oOZmASQcJ_nC-FL0FoGlOL1K02ub2jG5/view?usp=sharing)
Or this one drive link for the same tutorial if that works
better for you in case you have no google login account.
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
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 http://cs.uwindsor.ca/password. Then, follow the appropriate buttons to
synchronize.
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, Rob Mavrinac, at mavrinac@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 under the “SERVERS” section.
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, 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 or NoMachine
to transfer the files.
**