Review List May 7 Final Exam COSC 6340
The final exam is scheduled for Tu., May 7, 11a-2p
in room 104 C (Roy Cullen) --- be aware of the room change.
The exam will be "open textbooks
and notes". The following material is relevant for the exam:
- *** E/R Model everything that was discussed in
class conc. the E/R model
(even if it is not discussed in Raghu's textbook; e.g. min and max
cardinality constraints).
- ** SQL Queries and Triggers: review chapter 5 sections 5.1, 5.2, 5.3,
5.4, 5.5, 5.12, 5.13 of
our textbook;
write SQL-queries (similar to those in Project1 or those you would need
to populate a OLAP cube) and triggers.
- *** Relational Database Design: Chapter 15 of the textbook excluding 2NF, 3NF,
join-dependencies, inclusion dependencies, and 5thNF,
centering on material discussed in class or that was part of
the homework.
- *** OLAP and Data Warehouses: Read: 1) the Nigel Pendse article (expect
some general questions related to the contents of this article)
2) pages 39-68, 79-83 and 98-99 of the Han book 3) pages
682-690 and 694-703 Ramakrishnan book. Moreover, what you did in Part1 of
Project2 is relevant for the final exam.
- **** Association Rules: pages 225-239, 244-257, 269-271 in the Han book, exam
questions will
center on topics that were discussed in class; you also should have detailed
knowledge about the APRIORI algorithm.
- * Classification: Han book pages 279-290 (you do not need to know
how the information gain heuristics works) and sections 7.9 and 7.10.
- *** Clustering and Similarity Object Similarity Evaluation: pages 335-351
of the Han book; be prepared to construct a similarity measure with respect
to a given set of objects.
- *** Internet Databases and XML: Review chapter 22 of the textbook (pages
642-645, 651-663 centering on what was
discussed in class, especially XML; also review the "american XML slideshow"(link
is in the 6340-homepage), and
be prepared to design an XML DTD for a particular application (similar to
the problem in the second homework).
Most problems (at least 80%) will cover material that was
discussed in class. The exam will take approx. 150 minutes.
last updated: April 19, 2002 3:13p