·   Take:  Quiz on unit 3  (Relational Algebra)   (6/11/12)

Jun 11 – Unit 3: Relational Algebra

Assign Homework 2

Point value: 100 points

Due date:  June 25 at 7:00 PM via email

FOR NEXT WEEK (IF NOT SOONER)  

·   Read:  Chapters Fifteen and Sixteen of the Elmasri textbook

·   Take:  Quiz on Chapters Fifteen and Sixteen of Elmasri (6/18/12)

·   Read:  Unit Four of the online notes

·   Take:  Quiz on Unit Four  (6/18/12)

Jun 11 – Unit 4: Relational Database Design Theory

FOR NEXT WEEK (IF NOT SOONER)

·   Read:  Unit Five of the online notes (Minimal Covers)

·   Do:     Tutorial: Minimal Covers

·   Take:  Quiz on Minimal Covers (6/18/12)

·   Read:  Unit Five of the online notes (Decomposition of Relations)

·   Take:  Quiz on Decomposition of Relations (6/18/12)

·   Read:  Unit Five of the online notes (Preserving Dependencies)

·   Take:  Quiz on Preserving Dependencies (6/18/12)

Jun 18 – Unit 5: Min. covers, lossless joins, preserving depend.

HW 1 Due

FOR NEXT CLASS (IF NOT SOONER)

·   Read:  Unit Six of the online notes (Normal Forms)

·   Take:  Quiz on Normal Forms   (6/25/12)

·   Read:  Unit Six of the online notes (Bernstein's Synthesis)

·   Take:  Quiz on Bernstein's Synthesis  (6/25/12)

Jun 18 – Unit 6: Normal forms up to 4NF

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Unit Six of the online notes (Boyce-Codd Normal Form)

·   Take:  Quiz on Boyce-Codd Normal Form   (6/25/12)

Jun 25 -  Unit 6: Normal forms up to 4NF, Paired Attribute Algorithm

              HW 2 Due

                  ·   Submit:  Midterm questions by Wednesday, July 1^st, 7 PM.

·   Study!

Jul 02 – Midterm: Closed Book, Closed Notes, 7 PM, Delta 241

Assign Homework 3

Point value: 100 points

Due date:  July 16^st at 7:00 PM via email

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Chapters 17 through 20 of Elmasri

·   Take:  Quiz on Chapters 17 through 20 of Elmasri  (7/09/12)

·   Read:  Unit Seven of the online notes

·   Take:  Quiz on Unit Seven online notes (7/09/12)

·   Read:  Unit Eight of the online notes

·   Take:  Quiz on Unit Eight online notes (7/09/12)

* Last day to drop a class/withdraw for the semester is July 14^th *

Jul 09 – Unit 7: Physical DB Design and Unit 8: Oracle Architecture

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Chapters 21 through 23 of Elmasri

·   Take:  Quiz on Chapters 21 through 23 Elmasri  (7/16/12)

·   Read:  Unit Nine of the online notes (Tran. Proc, Con Ctrl, Rec)

·   Take:  Quiz on Unit Nine online notes (7/16/12)

Jul 09 – Unit 9: Tran. Processing, Concurrency Control, Recovery

Assign Homework 4

Point value: 100 points

Due date:  July 23 at 7:00 PM via email

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Chapters 11 and 25 of Elmasri

·   Take:  Quiz on Chapters 11 and 25 of Elmasri  (7/16/12)

·   Read:  Unit Ten of the online notes (OODB, Dist. Databases)

·   Take:  Quiz on Unit Ten online notes  (7/16/12)

Jul 16 – Unit 10: Object Oriented/Distributed Databases

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Chapters 24, 14, and 12 of the Elmasri textbook

·   Take:  Quiz on Chapters 24, 14, and 12 of Elmasri  (7/23/12)

·   Read:  Unit Eleven of the online notes (Security, Web, XML)

·   Take:  Quiz on Unit Eleven online notes  (7/23/12)

Jul 16 – Unit 11: Database Security, Web Databases, and XML

HW 3 Due

FOR NEXT CLASS (IF NOT SOONER)

·   Read:  Chapters 28 and 29 of Elmasri

·   Take:  Quiz on Chapters 28 and 29 of Elmasri (7/23/12)

·   Read:  Unit Twelve of the online notes (Data Warehousing, Mining)

·   Take:  Quiz on Unit Twelve online notes (7/23/12)

Jul 23 – Unit 12: Data Warehousing, Data Mining

HW 4 Due

FOR NEXT CLASS (IF NOT SOONER)

·  Submit:  Final questions by Wednesday, July 29^th, 7 PM.

·  Study!

Jul 30 – Final Exam: Closed Book, Closed Notes, 7 PM, Delta 241

Other Policies

Homework, Projects, Research Paper

• Homework and projects are due exactly at the prescribed time (usually the beginning of class). As soon as a homework or project is collected, then all others are considered 1 day late (even if it only 3 minutes). In the event you might be running late, you might want to email the assignment. Also, when preparing your assignment, be mindful of possible backlogs at the printer, jammed printer, printer out of toner, etc.

• Late homework/projects are accepted with a penalty of 10% deduction per 24-hour period after the due date. No late project will be accepted one week after the due date. The last homework/project cannot be late.

• There will be no extra-credit homework or projects in this course.

• All homework and projects must be typed not hand-written.

• A cover page is expected for all homework and projects. A sample of this cover page is included in the first assignment.

• VERY IMPORTANT! In certain classes students are encouraged to work in groups. For this class you are expected to work on all homework and projects individually. Students may not discuss, use, email, show, give, buy, sell, borrow, trade, steal, download from the Internet, etc. in whole or part, any of the homework or projects in any manner not prescribed by the instructor. This condition applies even after you complete this course! Penalty for cheating will be extremely severe and may result in an F for this course.

• Handing in an assignment for another student is considered cheating. Penalty for cheating will be extremely severe and may result in an F for this course.

• VERY IMPORTANT! Failing to report to the instructor any incident in which a student witnesses an alleged violation of the Academic Honesty Code is considered a violation of the academic honesty code. Please see me to discuss any incidents.

• VERY IMPORTANT! Purchasing, or otherwise acquiring and submitting as one's own work any research paper or any other writing assignment prepared by others constitutes cheating. Penalty for cheating will be extremely severe and may result in an F for this course.

• Standard academic honesty procedure will be followed. See the following link for additional information.

Tests, Quizzes

• There are no make-up tests except in verified medical emergencies and with immediate notification.

Face-to-face: Rescheduling a final exam in order to catch a plane flight in order to go back home is unacceptable.

Make up exams are harder and different from the original exams.

Pure Web-based: Will be assessed on a case-by-case basis.

Make up exams are harder and different from the original exams.

• There are no make-up quizzes. Allow plenty of additional time in the event that Blackboard crashes.

• You are responsible for all the readings assigned throughout the semester.

• Students are to work on test and quizzes individually.  Students may not discuss, show, give, sell, borrow, trade, share, etc. their tests or quizzes. Penalty on cheating will be extremely severe. Standard academic honesty procedure will be followed.

• VERY IMPORTANT! Providing answers for any assigned work or examination when not specifically authorized by the instructor to do so. Or, informing any person or persons of the contents of any examination prior to the time the examination is given is considered cheating. Penalty for cheating will be extremely severe and may result in an F for this course.

• VERY IMPORTANT! Failing to report to the instructor any incident in which a student witnesses an alleged violation of the Academic Honesty Code is considered a violation of the academic honesty code. Please see me to discuss any incidents.

Miscellaneous

• Any person with a disability who requires a special accommodation should inform me and contact the Disability services office or call 281 283 2627 as soon as possible.

• Incomplete grades or administrative withdrawals occur only under extremely rare situations.

• The ringing, beeping, buzzing of cell phones, watches, and/or pagers during class time is extremely rude and disruptive to your fellow students and to the class flow. Please turn off all cell phones, watches, and pagers prior to the start of class.

• Attendance Policy:

Face-to-face: You are expected to attend every class. If you miss more than 1 class, then your course grade will be reduced by 2 points for each lecture missed. Coming late to class on a regular basis will impact your course participation grade.

Pure Web-based: You do not need to attend any lectures on campus. Also, you do not need to show up in  person to take the exams. However, you may attend any/all of the face-to-face lectures and/or exams. However, it is my experience that those students who do attend class on a regular basis do better on tests than those that don't. If you will be off-campus during the exams, please make the necessary arrangements with me as soon as possible.

• I am willing to provide letters of recommendation/references only if you have attained an 'A' in one of my classes, or two 'A-' in two of my classes.

• I highly recommend that you seek out your advisor and complete you Candidate Plan of Study (CPS) as soon as possible. I am normally not available for advising during the summer months.

• Pay very careful attention to your email correspondence. It reflects on your communication skills. Below is a compilation of email errors I have received during the past year.

dear sir.

wen r u gonna grad the homework, bcoz i have a doubt about the third problem

Some student

Common problems:

   *   wen instead of when

   *   bcoz instead of because

   *   r instead of are

   *   u instead of you

   *   lowecase i instead of I

   *   starting a sentence with a lowercase letter

   *   doubt instead of question

• I immediately discard anonymous emails.

Return to Top

Home • UHCL • SCE

2700 Bay Area Boulevard
Delta Building. Office 171
Houston, Texas 77058
Voice: 281-283-3805
Fax: 281-283-3869
boetticher@uhcl.edu

© 2002-2012 Boetticher:  Database Course, All Rights Reserved.