CSE 5330/3330                            Database Systems 1                            Summer 2008

Course Information and Outline

 

 

 

Instructor: Ramez Elmasri

Office: 108 GACB                          Office Phone: 817-272-2348

Classroom: 105 GACB                 Class Time: 6pm-7.50pm, Tuesday and Thursday

Email: elmasri@uta.edu

Office Hours: Tuesday, Thursday: 3-3.30pm, 5.30-6pm

GTA: Kyungseo Park, and Jae Sung Choi.               Email: kpark@uta.edu, cse5330@gmail.com

GTA Office: NH 239

GTA Office Hours: Tu, Th 5:00-6:00pm.

Companion Course Web page: crystal.uta.edu/~elmasri/db1/

 

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

 

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 may be omitted if time does not permit to cover all the topics.

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

1.    Chapter 5, plus Sections 6.1-6.5: The relational data model and relational algebra.

2.    Chapter 8: The SQL database language.

3.    Chapter 9: Database programming techniques.

4.    Chapters 3, 4 and Sections 7.1, 7.2: Conceptual database design using the Entity-Relationship model and Extended Entity-Relationship modeling, and mapping to relational model.

5.    Chapters 13 and 14: File and index structures and search techniques for database storage.

6.    Chapter 10, plus Sections 11.1, 11.2: Introduction to relational database theory, functional dependencies, and normalization.

7.    Sections 23.1, 23.2: Introduction to database security.

8.    Sections 6.6, 6.7: Relational calculus.

9.    Sections 15.1, 15.7.1, 17.1, 17.2, 17.3: Overview of some of the material covered in the second database course (CSE5331).

 

 

Grading Policy:

There will be three tests plus a number of pop quizzes. The schedule for the tests will be posted on the course Web site. The pop quizzes can be administered at any time during class and there is no schedule for pop quizzes. There is no final exam. In addition, two projects will be given. The final grade will be calculated based on the three tests and quizzes (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. 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:

  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 ACS. 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, 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.