COMP-4150 (60-415-01) FALL 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-4150-1 (60-415-01): Mon (2:30pm - 5:20pm) IN ER classroom
as announced in Brightspace..
Office
hours:
Comp-4150-1 (60-415-1): Tue, 3:00pm-4:00pm in my LT office
Course Web Page can be
accessed through: http://brightspace.uwindsor.ca Or https://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 Sunday, November 17,
2024
Dear Comp-4150 students,
As you already know, Midterm Test for Comp 4150 is this Monday, Nov. 18, 2024 during class time in ER 1118 at 2:30pm to 5:00pm. There is no make-up test for any missed test unless for absolutely documented emergency. Please, try and write this only test in the course. Please, read the instructions below carefully. There will be no use of the cell phone or internet during test. Test scope covers all materials so far discussed in class and in the labs and project phases as shown in the sample test in brightspace including Part A (60%) (Advanced Databases: Chapters 14, 10, 11, 13, 20, 21, 22, 24; Part B (30%). Oracle PL/SQL and Part C (10%): General PHP front-end). Test is fair if you have been keeping up with course work and going to classes. Note that I posted sample test with solutions and also discussed the sample test as my revision for course on Monday, Nov. 11 class. Good Luck in your midterm test. Check other upcoming class events below.
Next Monday, Nov. 25, 2024 is project phase 3 submission and
presentation. For phase 3 project presentation, please, allow 5 to 10 minutes
for each group and every group member needs to be present to receive the mark
for project presentation and also need to make part of the presentation.
Please, upload your project .pdf presenation as a single file on your phase 3
assignment submission link on brightspace.
You need to make your presentation in class from that link. There is no time to ask to switch to your
laptop. We shall start presenting in the group order. We hope to finish on Nov. 25 but will
continue with groups that could not present on Monday, Dec. 2, 2024.
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.
7, 2024 |
Nov.
25, 2024 |
|
Project
Presentation/Report |
----- |
Nov.
25, 2024 |
|
Midterm Test ( ) |
----- |
Nov. 18, 2024 (In class) |
Posted
Saturday, November 9, 2024.
I. More Clarification on Lab 3 and Project Phase 3 Requirements; Class Test on Mon. Nov. 18 and Project Phase 3 presentation on Nov. 25, 2024.
To assist with Lab
3 and Project phase 3, the TA, Arunesh Chowdhary will come with me to class
this coming Monday, Nov. 11, 2024 to go through the process of creating a
database on mysql dbms on myweb.cs.uwindsor.ca, which you can use a php program
on the same server to query as done in the sample application programs I left
for you through database tool link of the course web site.
Also, remember
that I will also be discussing the last chapter on advanced topics (Chapter 24
on NoSql Databases) as well as sample class test posted on brightspace as the
class test is on Monday, Nov. 18, 2024.
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 10 features for each student (and a minimum
of 20 features for a group). 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 brightspace resource/project materials folder for the
simple database application you can run through the web links: https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/phpfiles/simple/index.php
Or
through
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/databases/Sample_DB_applications.html
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.
I posted
a user guide on the database tool link you can follow. It is in the link:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/databases/Webapplication_userguide.pdf
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, similar to 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. 18, 2024 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 brightspace.
Upcoming Class Events
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE
|
|
Handed Out (Mondays) |
Due Date (Mondays) |
|
Lab
Exercise 3 ( ) |
Oct.
7, 2024 |
Nov.
11, 2024 |
|
Project
Phase 3 ( ) |
Oct.
7, 2024 |
Nov.
25, 2024 |
|
Project
Presentation/Report |
----- |
Nov.
25, 2024 |
|
Midterm Test ( ) |
----- |
Nov. 18, 2024 (In class) |
Posted Saturday, October 26, 2024.
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 brightspace. The GAs will release your marks on
brightspace soon too.
Note that I had delayed
posting the project phase 1 marks to allow the GA Ali send me the updated Lab1
marks. I have still not received those
and decided to post the marks as they were.
I am calling on all students whose Lab 1 marks had changed to send an
email to me (cezeife@uwindsor.ca) so
that the Lab 1 marks can be updated. I
am also asking the GA Safiia to go ahead and update the Lab 1 marks on
brightspace once I have the updated Lab 1 marks from students whose labs were
re-marked.
Let the admin GA, Safiia Mohammed (mohamm7d@uwindsor.ca) or myself know of any discrepancies in marking that we can look
into. If you have any course questions,
go to the GA/TA 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
brighspace and on the course web page.
Upcoming Class
Events
ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE
|
|
Handed Out (Mondays) |
Due Date (Mondays) |
|
Lab
Exercise 2 ( ) |
Sept.
30, 2024 |
Oct.
28, 2024 |
|
Lab
Exercise 3 ( ) |
Oct.
7, 2024 |
Nov.
11, 2024 |
|
Project
Phase 2 ( ) |
Sept.
30, 2024 |
Nov.
4, 2024 |
|
Project
Phase 3 ( ) |
Oct.
7, 2024 |
Nov.
25, 2024 |
|
Project
Presentation/Report |
----- |
Nov.
25, 2024 |
|
Midterm
Test ( ) |
----- |
Nov.
18, 2024 (In class) |
Posted
Wednesday, Oct. 9, 2024
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
You can find
updated Lab 1 marks posted through the marks web link accessed also through
your brightspace.
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/marks/index.html .
The GA will also
publish your brightspace grade for Lab 1.
Go to all
classes. We have discussed about one third of Oracle PL/SQL language as a
third approach for database programming. Keep up with course materials to
do well in the course. I have posted the final project groups on
brightspace.
There is no class this coming Monday, Oct. 14, 2024, as that is Canadian
thanksgiving day. Happy Thanksgiving.
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.
16, 2024 |
Sept.
30, 2024 |
|
Lab
Exercise 2 ( ) |
Sept.
30, 2024 |
Oct.
28, 2024 |
|
Lab
Exercise 3 ( ) |
Oct.
7, 2024 |
Nov.
11, 2024 |
|
Project
Phase 1 ( ) |
Sept.
16, 2024 |
Oct.
7, 2024 |
|
Project
Phase 2 ( ) |
Sept.
30, 2024 |
Nov.
4, 2024 |
|
Project
Phase 3 ( ) |
Oct.
7, 2024 |
Nov.
25, 2024 |
|
Project
Presentation/Report |
----- |
Nov.
25, 2024 |
|
Midterm
Test ( ) |
----- |
Nov.
18, 2024 (In class) |
Posted
Friday, August 16, 2024
Dear Fall 2024 Comp 4150
Students,
Welcome to my Fall 2024 class and see you in class on Monday, Sept. 9, 2024 in
ER 1118.
Course Web Page is open and can
be accessed through brightspace (http://brightspace.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 a former TA.
Talk to a TA or myself during our office hours if you are still
encountering any issues. This is a link
that you may have to download first before viewing.
https://cezeife.myweb.cs.uwindsor.ca/courses/60-415/announce/SQLplustutorial_f20.mkv
**
Activating your Computer User Accounts and Accessing your Webmail
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.
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
3. Connect to any of the CS machines
through either Bitvise SSH (http://www.putty.org/) or Nomachine (https://www.nomachine.com/download).
These two software programs can be downloaded from their websites. More
details on how to obtain them are provided below.
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@delta.cs.uwindsor.ca)
(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.)
**