CSE 3330 Database Systems
TA: TBD
TA Office:
TBD
TA Office
Hours: TBD
Prerequisites: CSE 2320 or consent of
instructor
Catalog Description: Database system architecture;
management and analysis of files,
indexing, hashing, and B+-trees; the relational model and algebra; the SQL database language; database programming
techniques; database design using
Entity-Relationship, extended E-R, and UML modeling; basics of normalization. Introduction to
database security, query processing, and transaction management.
Objective: This is an introductory (first)
database course for graduate students. It is useful for non-cse major graduate
students as well if they foresee the use of a DBMS as part of their work. The
objective of this course is to give the student a thorough understanding of
Relational database management system fundamentals. In this course, the
emphasis is on the concepts underlying various functionalities supported by a
DBMS. The emphasis of this course is to gain sufficient understanding of a
DBMS, SQL, and its usage, from an end-user/application perspective, to maximize
the benefits of a DBMS
usage.
Course Outline: The course will cover the DBMS fundamentals
as part of three modules. Module I: Requirements analysis, Application design
using ER and Extended ER models,
Relational
concepts, translation of EER to relations, and normal forms. Module II: Relational algebra, SQL, Query
processing/optimization, Storage structures (e.g., disk resident B+ tree and
Hash data structures). Module III:
Basics of concurrency control, Recovery, and security.
Time
permitting, advanced database concepts will be discussed.
Textbook:
1.
Fundamentals
of Database Systems by R. Elmasri and S. Navathe, Fourth Edition, Addison
Wesley, ISBN 0-321-12226-7, 2003. Can also use 5th edition (or 6th
edition)
References:
Lectures slides provided by the instructor
Project: Since the emphasis of this course is on learning how to map
you application to a DBMS and use a DBMS, there will be a semester-long project
that will have several parts. It will start with the identification of an
application (of your interest), doing a requirements analysis, coming up with
an ER/EER representation for the application, mapping the ER diagram to
relations (or schema), normalizing them, populating the relations, and
executing several types of queries (ad hoc and gui-based) from an end-user of
the application. The project will be done in stages and points are accumulated
over the entire semester. The final 2 phases of the project involves coding and
need to be demonstrated for grading. We will use either the ORACLE or MySQL
DBMS on Omega for this project.
Grading: There will be 5 phases in the
hands-on projects that will constitute approximately 45% of the total grade.
There will be at most 3 in-class tests/quizzes that will constitute approximately 50%
of the total grade and attendance and class presentation will carry 5% of total
grade.. . The above is an initial
grading proposal. The instructor reserves the right to re-distribute the
percentages if deemed necessary. Students may be asked to make an in-class
presentation on the project experiences. Attendance and class participation is
important for doing well on the course. This includes visiting the Instructor
and the GTA to understand the material and complete projects. Based on past observations, you need to be
in the class average range for a B grade. Need to be at least one standard
deviation above the class average for an A.
50% is passing grade.
Academic Honesty: I strictly adhere to The
University of Texas at Arlington rules and guidelines for handling violations
of academic dishonesty. Please refer to the pamphlet “CHEATING: Definitions and
Consequences” for additional information. You are required to sign and return
two statements about academic dishonesty. If
anyone is caught for cheating, plagiarism or collusion either on the project or
on the quiz/exam, the grade for the course will be an automatic Fail grade (F).
For projects, all members of the team will receive the same penalty; so make
sure you are aware of what your partner is doing!
How to Do Well in This Course: Students who get the most out of
this course will be the ones who put in the most effort. If you want to do
well, attend all the lectures, read the assigned sections of the book/papers,
and start early on your projects. Working out the assigned sample questions and
questions from book chapters will immensely help in doing well on
quizzes/exams. If you are having difficulty, you owe it to yourself to get
help. We will be more than happy to help you. Don't be afraid to come and see
us. We will hold extensive office hours. If you can't make it to office hours
but really need help, contact one of us for an appointment. I sincerely want
all of you to do well. It is your
responsibility to check the web site at least twice a week.
NOTE
1: The class schedule, exam, and project due dates are
tentative. Project deadlines and exam
dates may be changed (with sufficient notice) based on the progress made in the
class. The course officially ends on the day of the final exam. No makeup
quizzes or exams will be given unless there is a justifiable, documented reason.
NOTE
2: Once the grade of a quiz/exam/project is distributed, you
will have 5 business days to dispute it and get it re-evaluated. No
re-evaluation will be entertained after the 5 day period. For projects, as part
of the document, what has been designed and implemented by each partner (in the
team) should be clearly stated and documented.