Syllabus
We
assume that the student is familiar with the introductory issues in
Databases such as SQL and database design. The course will start with a
brief review of these topics and an entry SQL exam will be instituted.
Individuals who will not be able to get a satisfactory mark on that exam
will be encouraged to drop this class. While the exam will be easy, the
student should expect not only SQL proper, but also the issue of modeling,
so Entity-Relationship questions and even (slightly) more difficult
questions pertaining to foreign keys, normal forms, etc.
Following
the current University practice, and the fact that the course is open to
undergraduate students, the lecture will be divided into two parts. Each of
these parts will have a separate grade, and the final score will be the
arithmetic mean of both scores. According to the University rules the
midterm grade will be recorded in student's record along with the final
grade (for undergraduate students only). The two parts of the lecture is
tentatively subdivided further
as the following.
1.
Part I
1.
Brief review of E-R model, SQL and
database design.
2.
Security in databases.
3.
Storage and indexing.
2.
Part II
1.
Transaction management
2.
XML
3.
Brief Introduction to data mining
Prerequisite:
CS405G: Introduction to database
systems.
Credit For the Course
Due to the recent university requirement, there will be a
mid-term grade and a final grade for this course.
The credit for the first part of the course will be determined
as follows:
·
Homeworks : 30%
·
Project: 30%
·
Midterm Exam: 30%
The credit for the second part of the course will be
determined as follows:
·
Homeworks: 30%
·
Project: 30%
·
Final Exam: 40%
The final grade will be the average of the results of part I
and part II.
Grading Scale:
·
91%+: A
·
81%-90%: B
·
71%-80%: C
·
61%-70%: d
·
<70%: F
Academic Conduct Expectations
Students are expected to complete
all assignments independently. Honest and ethical behaviors are always
expected. There will be no
tolerance for plagiarism or other academic misconduct. The minimum punish-
ment is an E grade that cannot be
removed by the repeat option. You may read U.K. Student Rights and
Responsibilities at
http://www.uky.edu/StudentAffairs/Code for a detailed description.
Required Textbook
Resources
|
