CSE 3330 Database Systems

Department of Computer Science and Engineering

The University of Texas at Arlington

Offering: Fall 2014

Time: Tuesday/Thursday 3:30Pm to 4:50 Pm

Place: NH 112

Instructor: Sharma Chakravarthy, 632 ERB

Phone: 272-2082, email: sharma@cse.uta.edu,

Course URL: https://wweb.uta.edu/faculty/sharmac

Research URL: http://itlab.uta.edu/sharma

Instructor Office Hours: Tu/Th  2:00pm-3:20pm, + by appointment

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.