CSE 5331/4331 Database Systems 2Fall 2011
Course Information and Outline
Instructor: Ramez Elmasri
Office: 654 ERB Office Phone: 817-272-2348
Classroom: 108 NH Class Time: 5.30pm-6.50pm, Monday/Wednesday
Email:
Office Hours: Monday/Wednesday: 1.30-3.00pm
GTA: Nandish JayaramGTA Email:
GTA Office and Office Hours: TBD
Course Web page:crystal.uta.edu/~elmasri/db2/
Textbook: Fundamentals of Database Systems, Sixth Edition, by Elmasri/Navathe, published by Addison/Wesley, 2010.
Course Contents:
This is a second course in database systems. The prerequisite is the first database course (CSE 5330 or CSE 3330 or equivalent). The prerequisite material covers Chapters 1 through 9, plus chapters 13, 14, 15, 17, 18 of the same textbook. In this course, we plan to cover the following topics. Parts or all of items 9 through 11 may be omitted if time does not permit to cover all the topics.
1. Chapters 21, 22, and 23: Transaction processing, concurrency control, and recovery concepts.
2. Chapter 11: Object-oriented and object-relational databases, object extensions to SQL, ODMG object model, ODL, OQL.
3. Section 12: Overview of XML.
4. Chapter 26: Active databases and triggers, introduction to temporal databases.
5. Chapter 17, 18: Quick review of file structures and indexing (this is covered in database 1).
6. Chapter 6: Quick review of relational algebra (this is covered in database 1).
7. Chapter 19: Query processing and optimization.
8. Chapter 24: Introduction to database security.
9. Chapter 25: Introduction to distributed databases.
10. Chapter 26: Overview of data warehousing and data mining techniques.
11. Chapters 27: Overview of other database topics.
Grading Policy:
There will be three tests (each test will cover approximately 1/3 of the course materials). The schedule for the tests will be posted on the course Web site. There is no final exam. In addition, two projects will be given. The final grade will be calculated based on the three tests (60% of grade) and projects (40% of grade). The grade cutoffs for graduate students are generally as follows: 90-100 A, 75-89 B, 60-74 C. The grade cutoffs for undergraduates will be lower than for graduate students. (Important Note: The exact cutoffs for each letter grade will be determined at the end of the course).
Projects may require SQL and JAVA programming using JDBC and ORACLE or MySQL. References to the documentation will be provided on the course Web site.
Note: The Instructor reserves the right to modify the grading policy, course calendar and all other course policies. Make-ups for Tests may be arranged if your absence is caused by illness or emergency. In order to get acceptance for make-ups, a written explanation along with the supporting documents must be submitted to the Instructor.
Student Code Name and Email Account:
Each student should send an email to the GTA with the following information:
- The preferred email for the student; the GTA will use this email to notify students of relevant announcements and course information.
- A secret code name made of 5 alphanumeric characters (starting with a letter); the student will use this code to access their grades.
Submission Policy for Assignments:
Assignments are due in their entirety on the due date by 12:00 midnight. There will be a 5% penalty per day late. Lateness is determined with respect to your submission time. For instance, an assignment due on Tuesday: if submitted on Wednesday before 12:00 midnight is considered one day late. No assignments will be accepted if late more than three days.
Omega Machine:
For programming projects, you can either use your own computer or a UTA computer. Some projects can be done in the programming language of your choice, while other projects may require a database system. Make sure you have an account on Omega (omega.uta.edu), the computer offered by ACS. This is the machine on which all projects can be implemented. UTA’s OIT (Office of Information Technology) has a help desk and a link from UTA’s Web page if you need assistance with Omega and other OIT managed resources.
You will also have an account created for you on the ORACLE and the MySQL database systems, which should have the same initial account name and password as your original Omega account.
Disability:
If any student needs special accommodations because of a disability, please contact the Instructor during the first week of classes.
Academic Honesty:
You are expected to adhere to the highest standards of academic integrity. This means that plagiarism in any form is unacceptable. Plagiarism will be assumed, until disproved, on work that is essentially the same as that of other students. Your work must be your own. This refers to tests, quizzes, and programming projects. Should you be found to be cheating, at a minimum, you will fail that assignment and a letter will be sent to the Department, the College of Engineering, and to the Graduate School. The Instructor reserves the right to stronger action should the situation warrant it.