Examination 3 Question Count

Examination 3 has 30 questions. All of the questions are from the packet.

You must skip 4 questions. This means that you need only answer 26 of the 30 questions.

TA's office hours

10 - 4 on Tuesday before the test

Examination room moved

The room for examination 3 has been moved to 645 Baldwin

Late Night Munchies

More places to get late night munchies are solicited.

Examination 3 Review

The review for examination 3 will be held on next Sunday. The review will start at 5 PM.

December 2: Lecture Topics

• Review: Databases in general

• Object Oriented Databases

• Object-Relational Databases

• Data Warehouses

November 30: Lecture Topics

• Concurrency

• Distributed Databases

Examination 3 Schedule

The third examination will be held Tuesday, December 7, 4-6 PM, regular classroom

November 23 Topics

An introduction to data mining

Regrading of examination 2

The time window for regrading examination 2 is closed

Review questions for second examination

From the packet:

• B: all
• G: all
• P: all
• IN: all
• S: all
• SG: all
• Y: none
• IT: all
• D: all
• R: 1-39
• OP: all
• T: 1-12, 14-17
• N: 1-36a, 37-70, 75, 76, 81, 82-85, 105-110, 114
• CD: none
• DD: all

November 9: Second Examination

• Same format as first examination

• All material covered in class so far

• Material covered in Codd article

Examination 2 Review

This coming Saturday, noon

Same format as last time:
• Students propose answers to packet questions
• No new lecture material
• Voluntary participation

November 4: Topics

• Review of Boyce-Codd Normal Form (BCNF)

• Review of Data Dependency

• Navigation

• Integrity facilities

November 2 Topics

• Boyce-Codd Normal Form (BCNF)

• Multi-valued dependencies (MVDs)

• Fourth Normal Form (4 NF)

October 28 Topics

• Access path dependency from Codd article

• Relational Integrity exception management (continued from October 26)

• Third Normal Form (3 NF)

TA can regrade examinations

Until this week Thursday, for examination 1, the TA can regrade examinations.

Students can ask the course instructor to consider their examinations for regrading. However, students are encouraged to see the TA first.

Longer Office Hours For TA

The TA now has office hours from 10 AM to 1:30 PM, Tuesday & Thursday

Late night munchies

Places to have late night munchies are still solicited. As before, email them to the course TA.

October 26 Topics:

• Data independence/dependence

• Second normal form

• Null Values

• Relational integrity

October 21 Topics

* Review: Inconsistency

* Manipulating Relations

* Data Dependency

Examinations contribution to course grade

* Examination 1: 30%
* Examination 2: 34%
* Examination 3: 36%

October 19 Topics

* Normalization as reduction of hierarchy

* Normal form general constraints

* Normalization pre-conditions: Zero Normal form

* Return of Examination 1 in last part of class.
- High grade: 80, subject to adjustment
- Review correct answers.
- TA mis-graded some questions giving half points. All of these questions have been regraded to whole points.
- Exams questions considered for regrading until October 29. If any question is considered for regrading, entire exam may be regraded

Thursday: October 14

* Concatonated keys

* Start relational databases: definitions: repeating groups, homogenous, primary key, first normal form

Concatenated keys

Concatenated keys are keys made up of more than one attribute.

We did not fully cover them in class. For the first examination, students are not responsible for questions that ask about concatenated keys.

Review questions for first examination

You should review the following packet question for the first examination.

B: all

G: all, except 5, 18, 19, 21

P: all

IN: all

IT: 1,2

S: all

SG: 1-27, 31-33, 35, 38, 39, 48, 49, 52, 53, 57, 59, 60, 62, 67, 69

D: all

Date Of First Examination

The first examination will be on Tuesday, October 12.

Seeking Late Night Munchies

If you know of a place that serves both food and some form of alcohol after midnight on weekdays (Monday, Tuesday, Wednesday, Thursday), please email the name, address, and telephone number to the course TA. The location must be within the I-275 loop around Cincinnati.

Engineering Job Fair

There will be a job fair next week Thursday. The link to the job fair is: http://tribunal.uc.edu/careerfair

First Examination Review

We will have a review of material covered in class up through this week Friday.

The review will be held on Sunday, 3 PM, in the regular classroom.

During the review, students may present their answers to packet questions.

The first examination will only cover material presented and discussed in class.

TA Office hours cancelled for Oct 14, Moved to Oct 13

The TA's office hours are canceled for Oct 14,; they are moved to Oct 13Wednesday October 13 from 1-3 PM.

Child Friendly

This is a child friendly course. You may bring your children to class as long as they are quiet and do not otherwise disturb the class.

Graduate Student Grade Replacements

Graduate students may not take this or any other graduate course for a second time and then replace the first grade for the course with the second grade. This is the university's policy and the course instructor cannot change it.

Grade Replacement For Undergraduates

If there are any undergraduate students repeating this class who wish to replace the grade of the former attempt at the class, the student needs to fill out a petition in the first week of the term. This is the relevant university policy. If the student does not fill out a form, nothing can be done later to accomplish the replacement. To repeat, students must fill out forms to replace grades for repeat classes; and, it must be done in the first week of the quarter.

Announcement Postings

Starting with the second day of class, news and announcements posted on the web will only be put on this blog