CSE 3330: Database Systems and File Structures

Class:Monday and Wednesday 1:00pm - 2:20pm
Instructor:Leonidas Fegaras
Office:GACB 115 (General Academic Classroom Bldg)
Phone:(817) 272-3629
Email:
Office hours:Monday and Wednesday 11:30am-1:00pm (before class)


Catalogue 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; basics of normalization. Introduction to database security, query processing and transaction management.

Objectives:
Survey the fundamentals of database management systems and practice various steps of database-driven application development such as modeling, design, querying, implementation and optimization.

Prerequisites:
Prerequisite course: CSE2320 (Algorithms and Data Structures) or equivalent
Additionally, students must: Students without adequate preparation are at substantial risk of failing this course.

Required Textbook and Slides:

Other Textbooks (not required):
You may find the following textbooks useful for additional background and explanation:

Grading:
The final grade will be based on Final grades will be assigned according to the following scale:
     A: score >= 90, B: 80 <= score < 90, C: 70 <= score < 80, D: 60 <= score < 70, F: score < 60,
Sometimes, I use lower cutoff points, depending on the overall performance of the class. After the first grades are posted, you can check your grades online at the course web page.

Reading Assignments:
Completing reading assignments before the class period in which the material is discussed is essential to success in this class. Not all the assigned material will be covered in class, but you will be responsible for it on exams.

Exams:
Both exams are open textbook (only the class textbook) and open notes (all notes must be securely bound in one notebook). The final exam will cover the material from the first lecture up to and including the last lecture. Once the exam grades are posted, you will have 10 business days to dispute your grade and get your exam re-evaluated. Before you request for re-evaluation, make sure to compare your answer with the solution. No re-evaluation will be entertained after the 10 day period. No makeup exams will be given unless there is a justifiable reason (such as illness, sickness or death in the family). If you miss an exam and you can prove that your reason is justifiable, you should arrange with the instructor to take the makeup exam within a week from the regular exam time. For any other case, you will get a zero grade for the missed exam.

Homework:
Homework is due one week after it is assigned. Each of the 5 homeworks will be worth the same number of points. Each assignment (homework or programming) is due by 11:55pm on its due date. All submissions must be done electronically using the class web site. Late assignments will be marked 20 points off per day (out of 100 max). So, there is no point submitting a homework more than 4 days late! This penalty cannot be waived, unless there was a case of illness or other substantial impediment beyond your control, with proof in documents from the school.

Project:
There will be a course project involving the implementation/population, querying, and application development of a small database in mySQL, using either Java or C on the omega server at UTA. The project will be done individually. The project is to be completed in three stages spaced throughout the term Details will be given out in class the third week of the course. All submissions must be done electronically using the class web site. Late assignments will be marked 20 points off per day (out of 100 max). So, there is no point submitting a project report more than 4 days late! This penalty cannot be waived, unless there was a case of illness or other substantial impediment beyond your control, with proof in documents from the school.

Cheating:
Homework and project must be done individually. No copying is permitted. Cheating involves giving assistance to or receiving assistance from other students or from other individuals, copying material from the web, etc. 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. If any one is caught for cheating, or indulge in plagiarism or collusion on a programming assignment or on a exam, the grade for the entire course will be an automatic Fail grade (F).

Students are required to read the following document carefully, sign it, return the signed copy to the instructor, and keep a copy for their own records.
Statement on Ethics, Professionalism, and Conduct for Engineering Students
Hardcopies of this document will be provided to the students in the first class. If you print by yourself, please make it double-sided.

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, and start early on your projects. Working out the questions from book chapters will immensely help in doing well on homework and exams. If you are having difficulty, the instructor and the GTA will be more than happy to help you. In addition to regular office hours, the best way of communication with the instructor or the GTA is through email. If you can't make it to the scheduled office hours but really need help, contact one of us for an appointment.

Special Accommodations:
If you require an accommodation based on disability, I would like to meet with you in the privacy of my office, during the first week of the semester, to make sure you are appropriately accommodated.

Course web page:
http://lambda.uta.edu/cse3330/
It is your responsibility to check the web site at least twice a week for announcements and materials.


Last modified: 08/30/10 by Leonidas Fegaras