GTA: Madhuri Debnath
Office hrs: 2:30pm-3:30pm, Tuesday/Thursday
Office Room: ERB 307
E-mails: madhuri.debnath@mavs.uta.edu

 Textbook: Fundamentals of Database Systems, Sixth Edition, by Elmasri/Navathe, published by Addison-Wesley, 2012.

 Course Contents:

This is a first course in database systems. The prerequisites are knowledge of programming and data structures (CSE 2320 or equivalent). We will cover the following chapters from the textbook. Parts or all of items 8 through 10 (below) may be omitted if time does not permit to cover all the topics.

1.    Chapters 1, 2: Introduction to database concepts and architecture.

2.    Chapter 3: The relational data model.

3.    Chapters 4, 5: The SQL database language.

4.    Chapter 6 (Sections 6.1-6.5): The relational algebra

5.    Chapters 7, 8, 9: Conceptual database design using the Entity-Relationship model and Extended Entity-Relationship modeling, and mapping to relational model.

6.    Chapters 13, 14: Database programming techniques.

7.    Chapters 17, 18: File and index structures and search methods for database storage.

8.    Chapters 15, 16 (Sections 16.1-16.4): Introduction to relational database theory, functional dependencies, and normalization.

9.    Sections 24.1, 24.2: Introduction to database security.

10.  Sections 6.6, 6.7: Relational calculus.

11.  Sections 19.1, 21.1: Overview of some of the material covered in the second database course (CSE5331). 

Grading Policy:

There will be three tests. 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 are generally as follows: 90-100 A, 75-89 B, 60-74 C. (Important Note: The exact cutoffs for each letter grade will be determined at the end of the course).

Projects will require JAVA programming using JDBC and Oracle or MySQL, or C/C++/C# programming with ODBC/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 documented illness or emergency and requested in advance if possible. 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:

1. The preferred email account for the student; the GTA will use this email to notify students of relevant announcements and course information.
2. 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:

Make sure you have an account on Omega (omega.uta.edu), the computer offered by OIT that hosts the Oracle and MySQL database systems. This is the machine on which all projects will 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 database system.

 Disability:

If any student needs special accommodations because of a disability, please contact the Instructor during the first week of classes.

 Academic Honesty:

  Chapter correspondence between 4^th, 5^th and 6^th editions of the textbook:

Sixth Edition                         Fifth Edition                         Fourth Edition

1,2                                          1,2                                          1,2

3                                              5                                              5

4,5                                          8                                              8,9.1,9.2

6                                              6                                              6

7,8                                          3,4                                          3,4

9                                              7                                              7

13,14                                      9,26.2-26.5                           9.3-9.7(no equivalent to 14)

17,18                                      13,14                                      13,14

15,16                                      10,11                                      10,11

24                                           23                                           23

Computer Science & Engineering Department
University of Texas at Arlington
P.O. Box 19015
Arlington, TX  76019-0015  USA