UW_Logo_2L_horz

 

Database Management Systems

Comp-3150 (03-60-315) Winter 2021                                               

 

Classes: Tues, Thurs: 11:30am – 12:50pm (Online Through Black Board Collaborate Virtual ClassRoom)
Log on to Black Board http://blackboard.uwindsor.ca. Then, click on Virtual classroom, and join Comp 3150 Class session for the day.                                                                                 

Instructor: Dr. C. I. Ezeife

Office: LT  5103                    

Phone: (519) 253-3000 ext. 3012                   Office hours: Tues: 2:00pm - 3:00pm,

e-mail: cezeife@uwindsor.ca                        M:11:00am – 12:00pm

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%3a37de2455c0f54893bbc0967517165f29%40thread.tacv2/conversations?groupId=24c0f847-3f75-4340-a5b9-788ae7d574c8&tenantId=12f933b3-3d61-4b19-9a4d-689021de8cc9

 

Course web page:    http://blackboard.uwindsor.ca, or directly through: http://cezeife.myweb.cs.uwindsor.ca/courses/60-315/winterindex.html.

 

Course Prerequisites: Comp-2540 (60-254), one of Comp-2560 (60-256) or Comp-2650 (60-265)

Required Materials:

C.I Ezeife, Course Notes for Comp-3150 (60-315), Database Management Systems, University of Windsor, Fall 2021/Winter 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.

 

Reference Materials:

Raghu Ramakrishnan/ Johannes Gehrke, Database Management Systems, third edition, WCB/McGraw-Hill, 2003. 

Ullman & Widdom  (2008). First Course in Database Systems, third edition, Pearson, isbn-10:013600637X; isbn-13: 9780136006374.

Online self study guide for homeworks and labs: The Gradience web link (for Elmasri and Navathe Database book class): http://infolab.stanford.edu/~ullman/pub/stud-guide.html

 

COURSE OBJECTIVE   

This course covers basic concepts of database systems. Topics covered will include 3-level architecture, introduction to file structures, B-trees, B+ Trees and hashed files, relational model, relational algebra and calculus, SQL and database design with normalization theory. The goal is to learn components of a database management system (DBMS), be able to design, create and query databases for problem domains using the SQL language.

 

COURSE CONTENT

- Introductory concepts including 3-level DBMS architecture and the Relational model

-  Database design, Functional Dependencies and normal forms

-  SQL DDL and DML

- Relational algebra and calculus

-  File Organizations and Indexing

           

 

LEARNING OUTCOMES

Students who successfully complete this course will be able to:

§ Design normalized databases for real life applications.

§ Create database schemas, instances, indexes, views with Oracle SQL DDL & DML and SQLplus.

§ Understand file organization

NOTE: By successfully completing this course, students would have progressed through much of the training needed to take advanced database courses, specialize in database area for graduate studies, or work with database management systems and databases. 

 

Lectures:

Students are urged to attend all given formal lectures with tentative schedule as:

Comp-3150 (60-315)  TENTATIVE SCHEDULE Winter  2021)

Week (of)

Activity

1  (Jan. 7)

Review of course outline, DBMS concepts & architecture (Chapter 1)

2  (Jan 11)

DBMS concepts & architecture (Chapters 1 & 2) **

3  (Jan 18)

Database design, Relational model  (Chapters 3 & 5)

4  (Jan 25)

Relational model       (Chapter 5)  **

5  (Feb 1)

functional dependencies and normal forms (Ch 14), Midterm 1 (written Thurs, Feb. 4, 2021);

6 (Feb 8)

Family day, Reading Week (Sat., Feb. 13, 2021 – Sun., Feb, 21, 2021; No Classes)

7  (Feb 15)

functional dependencies and normal forms; (Chapters 14)

8  (Feb 22)

SQL DDL,  SQL DML  (Chapters 6 & 7) **

9   (Mar 1)

SQL DML (Chapter 7) , Midterm 2 (written Thurs, Mar. 4, 2021); 

10 (Mar 8)

SQL DML ((Chapter 7)

11 (Mar 15)

Relational Algebra (Chapter 8)  **

12 (Mar 22)

Relational Calculus, File and Index Structures (Chapters 8 & 17)

13 (Mar 29)

File and Index Structures (Chapter 17);  Revision (Apr. 5)

*All schedules presented in this document are only tentative and subject to possible revisions in the course of the term.  Any changes will be announced in class or will be posted on the course website.

** in schedule means assignment is handed out and/or is due that week.

 

COURSE EVALUATION

Work

Mark (out of 100%)

Three Assignments (due Thurs, Jan. 28; Feb. 25; Mar. 18)

15% 

Midterm 1 (due Thurs, Feb. 4, 2021)

27.5%

Midterm 2 (due Thurs, Mar. 4, 2021 )

27.5%

Final Exam (TBA)

30%

 

 

 

 

 

 

 

CONVERSION OF MARKS (% marking scheme used for Winter 2021)

Only raw % scores are assigned in course work and meaning of scores in transcripts are:

% Score

Grade

% Score

Grade

Comments

90-100

A+

63-66.99

C

In computing a student's average, grades from 0% to 22% are calculated as 22%. Grades from 23% to40% calculated as 40%. Grades from 40% to 49% are calculated as is into the student’s average. All grades are recorded in the transcript as is.  All grades below 50% are considered failures. (see mark/grades descriptor page of calendar www.uwindsor.ca/calendar for details).

 

The University of Windsor uses a percentage marking and grading scale

85-89.99

A

60-62.99

C-

80-84.99

A-

57-59.99

D+

77-79.99

B+

53-56.99

D

73-76.99

B

50-52.99

D-

70-72.99

B-

0-49.99

F

67-69.99

C+

 

 

 

 

ASSIGNMENT & EXAMINATION TENTATIVE SCHEDULE

 

Handed Out (Thurs)

Due Date (Thurs)

Assn   1 (Chs 1, 2, 3)

Jan. 14, 2021

Jan. 28, 2021

Assn 2  (Chs 5, 14)

Jan. 28, 2021

Feb. 25, 2021

Midterm 1 (Chs 1, 2, 3, 5)

 

Feb. 4, 2021 (In class)

Midterm 2 (Chs 14, 6, 7)

 

Mar. 4, 2021  (In class)

Assn 3 (Chs 6, 7, 8)

Feb. 25, 2021

Mar. 18, 2021

Final Exam (all materials covered in class)

Time and Venue (TBA)

Time and Venue (Venue: TBA)

 

IMPORTANT DATES (as in University calendar www.uwindsor.ca/calendar)

Thurs., Jan. 7th, 2021  …………        Classes begin.

Wed., Jan. 20th, 2021  ………..         Final day for registration revisions (Add/Drop).

Sat., Feb. 13, 2021 – Sun., Feb, 21, 2021 …. Study Week (No classes).

Mon., Feb. 15, 2021    …………        Family Day (No classes).

Wed., Mar. 17, 2021   ……….           Last day for voluntary withdrawal from courses.

                                    Last day to receive partial refund for withdrawal from courses

Fri., Apr. 2, 2021     ……….              Good Friday (No classes)

Sun., Apr. 4, 2021   ……….               Easter Sunday

Fri., Apr. 9, 2021        ………..          Last day of classes

Mon., Apr. 12, 2021   ………            Winter term final examinations begin

Thurs., Apr. 22, 2021  ………..          Winter term final examinations end

Mon., May 10, 2021     ………...       Intersession, 12 week sessions begin

 

ASSIGNMENTS AND COURSE WORK

1.       There will be 3 individual assignments, 2 midterms and a final examination.

2.       Completed individual assignments must be handed in electronically on the day and time on which they are due.

3.       All assignments should be handed in electronically through blackboard, http://blackboard.uwindsor.ca.

4.       Online assignment and test submissions require that students submit individual files in accepted formats (.pdf, .doc, .txt, .jpeg) and not in any other needing-to-convert or packaged file format (such as .zip or .rar) or marks may be lost.

5.       Late assignments will not normally be accepted.

6.       No make-up tests will be given for missed tests.  If a test is missed for medical reasons (valid Student Medical Certificate completed by a physician shown), the weight of the student’s final examination is increased by the weight of the missed test.

7.       Final examination must be taken to obtain a final score in the course. If a final exam is missed for valid medical or emergency reason (proof needed), student is allowed to write a makeup final exam in the first week of the following term, for all students who missed final exam.

8.       After final examination marks and all course marks are converted into a final exam score, only students who completed all course work (including class participation marks) may be rounded up to the next grade level if their total mark falls short by less than 1%. Thus, there are other prices for completing all course work other than learning the materials and the necessary skills to handle higher level courses and be prepared for jobs.

9.       The following confidentiality agreement and statement of honesty will need to be signed by students for all handed-in course work to discourage and prevent academic dishonesty and cheating. Note that if two assignments are found to be a copy of each other, a mark of 0 will be assigned to both assignments.

 

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 this assignment/examination.   I confirm knowing that a mark of 0 may be assigned for copied work. 

 ________________________________________                                            ________________________________________

Student Signature                                                                               Student Name (please print)

________________________________________                                             ________________________________________

Student I.D. Number                                                                                          Date

________________________________________________________________________________________________________________

Preparation for lectures (VERY IMPORTANT)

1.       Attendance at all lectures is highly recommended.  Students should read the course text and notes ahead of lectures.  A detailed schedule is given on this document.  Lectures are not substitutes for student reading.  Students who do not read ahead may find themselves lost in the lectures.

2.       Individual Assignments: Students should attempt to complete individual assignments by the suggested completion dates.  This will help you prepare for materials to be covered in subsequent lectures, and for tests. 

3.       Time Required for Course Work: Students should set aside a total of about 10 hours weekly for work related to this course.  This enables them devote 3 hours to lecture material preparation, 3 hours to attending lectures,  and 3 to 4 hours for working towards completing individual assignments and tests.

4.       Course Blackboard / Web Page: Answers for individual assignments, lab exercises and tests will be made available only on the Blackboard page (not web page) so that students can revise concepts that were misunderstood, and assess their own progress. Students’ marks are also posted on this page and students should keep track of their marks and report any discrepancies.

5.       Computing Resources Available for Course Work: Computing laboratories will be available from the second week of the semester onwards.  The CS laboratories are located on the third floor of Lambton Tower and Erie Hall (called Java lab (ER 3150) and X-lab). The Leddy library, general IT services laboratories at the basement of the Computer Centre are also available to students. Students can also connect to campus machines (from their home PCs or laptop) to work online.

 

PENALTIES AND DISCIPLINARY ACTION FOR DEFICIENT TERM WORK

While collaboration with course mates is encouraged for discussing class topics, students are expected to develop individual learning and research abilities in the area and hand in assignments prepared individually by themselves.  In other words, cheating is not allowed in this course.

Policies on Repeating Courses/ Classroom Evacuation

1. Note that no student is allowed to take a course more than two times without permission from the Dean.

2. Check www.uwindsor.ca/emergency and posted copy in class for Classroom evacuation instructions in case of emergency.

Policy on cheating
The professors and teaching assistants will report any suspicion of cheating to the Director of the School of Computer Science and/or assign a mark of 0 for any submitted work that is copied or allowed to be copied by other students.  If sufficient evidence is available, the Director will begin a formal process according to the University Senate Bylaws.  The instructor will not negotiate with students who are accused of cheating but will pass all information to the Director of the School of Computer Science. The following behaviour will be regarded as cheating (together with other acts that would normally be regarded as cheating).

1) Copying assignments solutions from the web or other students,  2) Allowing another student to copy an assignment from you and present it as their own work, 3) Copying from another student during a test or exam,  4) Referring to notes, textbooks, etc. during a test or exam, 5) Talking during a test or an exam,  6) Not sitting at the pre-assigned seat during a test or exam, 7) Communicating with another student in any way during a test or exam, 8) Having access to the exam/test paper prior to the exam/test, 9) Asking a teaching assistant for the answer to a question during an exam/test, 10) Presenting another’s work as your own, 11) Modifying answers after they have been marked, 12) Any other behavior which attempts unfairly to give you an advantage over other students in the grade-assessment process, 13) Refusing to obey the instructions of the officer in charge of an examination.
Several University of Windsor students have been caught cheating during the last few years.  In most cases the evidence was sufficient to invoke a disciplinary process which resulted in various forms of punishment including letters of censure, loss of marks, failing grades, and expulsions.  Do not cheat, if you are caught and found guilty, you could be thrown out of the university and will have to explain why when you go looking for a job.

Policy on Recording of Lectures:
Students are not generally allowed to record lectures in this class as all necessary recording or posting of lectures will be taken care of by the instructor. Below is the Senate policy on recording of lectures and use of any such posted recording by the instructor.

Any recording of lectures or guest lecturer/classmate presentations by students can be used only for the purposes of private study by the individual student. The recording (including any transcriptions or any translation to any other form) cannot be shared, distributed, emailed, posted online or otherwise disseminated or communicated in any form or to any other person (including fellow classmates) unless written consent has first been obtained from the instructor or presenter.

 

Link to Senate policy on recording of lectures is given below:

https://lawlibrary.uwindsor.ca/Presto/content/Detail.aspx?ctID=OTdhY2QzODgtNjhlYi00ZWY0LTg2OTUtNmU5NjEzY2JkMWYx&rID=MjEy&qrs=RmFsc2U=&q=KFVuaXZlcnNpdHlfb2ZfV2luZHNvcl9DZW50cmFsX1BvbGljaWVzLkFwcHJvdmVyPSgiU2VuYXRlIikpIEFORCAoVW5pdmVyc2l0eV9vZl9XaW5kc29yX0NlbnRyYWxfUG9saWNpZXMuVHlwZT0oIlBvbGljeSIpKQ==&qcf=OTdhY2QzODgtNjhlYi00ZWY0LTg2OTUtNmU5NjEzY2JkMWYx&ph=VHJ1ZQ==&bckToL=VHJ1ZQ==&rrtc=VHJ1ZQ==

Support for Students 

Mental Health:  http://www.uwindsor.ca/studentcounselling/299/resources

Feeling Overwhelmed?
From time to time, students face obstacles that can affect academic performance. If you experience difficulties and need help, it is important to reach out to someone. For help addressing mental or physical health concerns on campus, contact (519) 253-3000:
- Student Health Services at ext. 7002 (http://www.uwindsor.ca/studenthealthservices/)
- Student Counselling Centre at ext. 4616 (http://www.uwindsor.ca/studentcounselling/)-
- Peer Support Centre at ext. 4551

24 Hour Virtual Support is Available
My Student Support Program (MySSP) is an immediate and fully confidential 24/7 mental health support that can be accessed for free through chat, online, and telephone. This service is available to all University of Windsor students and offered in over 30 languages. Call: 1-844-451-9700, visit https://keepmesafe.myissp.com/ or download the My SSP app:Apple App Store/Google Play.

A full list of on-and off-campus resources is available at http://www.uwindsor.ca/wellness. Should you need to request alternative accommodation contact your instructor, head or associate dean.

For the revised bylaws, go to: www.uwindsor.ca/policies


More on Senate BYLAW/POLICY 31 and 51/54 STATEMENTS AND INFORMATION

1.       Student Evaluation of Teaching (SET) will be administered during the two weeks of classes.

2.       Exams in this course are protected by copyright.  Reproduction or dissemination of exams or the contents or format of exams in any manner whatsoever (e.g., sharing content with other students), without the express permission of the instructor, is strictly prohibited.  Students who violate this rule or engage in any other form of academic misconduct will be subject to disciplinary action under Senate Bylaw 31: Academic Integrity.

3.       Please read Senate Bylaw 31 on Academic Integrity procedures at the following link:

http://www.uwindsor.ca/secretariat/sites/uwindsor.ca.secretariat/files/bylaw_31_-_academic_integrity_amended_170526.pdf

Bylaw 31 defines the various types of academic misconduct that exist (e.g., plagiarism, cheating), lists and describes the stages of the process that will be followed in the event that academic misconduct is suspected or identified, and includes definitions and examples of sanctions that will be applied to first-time and subsequent offences.  The rights of students and the roles that the instructors and Department Head of Kinesiology play within this process are also outlined in this bylaw. If instructors plan to use software (e.g., SafeAssign, Turnitin) to prevent plagiarism and provide students with feedback on their writing, they must indicate this in their syllabi.

4.       Please read Senate Bylaw 51 on academic evaluation procedures at the following link:

http://www.uwindsor.ca/secretariat/sites/uwindsor.ca.secretariat/files/bylaw_51_-_academic_evaluation_procedures_amended_170526.pdf

Instructors should feel free to highlight specific clauses from Bylaw in full, if they wish to draw things to the attention of students (e.g., what to do if they have three or more in-term assessments within a 24-hour period).

5.       Please read the Senate Policy on the Conduct of Exams and Tests at the following link:

http://www.uwindsor.ca/secretariat/sites/uwindsor.ca.secretariat/files/conduct_of_exams_and_tests_amended_sa161111.pdf

Expectations and Responsibilities (Code of Conduct and/or Classroom Behaviours)

Instructors are encouraged to describe any expectations they have of students in a code of conduct as related to classroom behaviours. Alternatively, instructors should describe the process by which students will contribute to the development of a code of conduct or expectations for classroom behaviours for the class.

 

Intellectual Property 

Copyright of Course Materials

Lectures and course materials prepared by the instructor are considered by the University to be an instructor’s intellectual property covered by the Copyright Act, RSC 1985, c C-42. Course materials such as PowerPoint slides and lecture recordings are made available to you for your own study purposes. These materials cannot be shared outside of the class or “published” in any way. Posting recordings or slides to other websites without the express permission of the instructor will constitute copyright infringement.