CIS 4331 Database Systems Fall 2013

Instructor:      Dr. Anwar Mamat
Office:         Wachman  Hall Room 414
Phone:         215-204-4207
EMAIL:       anwar@temple.edu
Course Meeting Times:
                        Wednesday & Friday 12:30 PM - 13:50 PM   [Tuttleman 401B]
                        Laboratory  Monday  12:00 PM – 13:50 PM [Wachman 104]
Office Hours:     [appointments are encouraged]
Monday 10:00AM - 12:00 PM 
(other times available by appointment)

Teaching Assistant:
Office: 1015A Wachman Hall
Office Phone: 215-204-3950
Mobile: 215-301-4655
Website: http://astro.temple.edu/~tue68607/

Textbook (required):
Modern Database Management (11th Edition) by Jeffrey A. Hoffer , Ramesh Venkataraman, Heikki Topi, ISBN-10: 0132662256, ISBN-13: 978-0132662253

Course Prerequisites:
CIS 1068 Program Design & Abstraction using JAVA (Sufficient ability to program in Java or willingness to acquire it through self-study.)

Reading Assignments
You are required to read the assigned chapters and sections of the textbook before the corresponding topics are discussed in class. In answering your questions on the topics discussed in class, the instructor will assume you are already familiar with the relevant material in the textbook.

Grading:
          Course grade will be determined by :
                Final Exam (30%)  [final exam will be comprehensive, covering all course material]
                Midterm Exam (20%)
                Laboratory Projects (30%): 2-3 projects
                Quizzes, homework, class participation (20%)
                Unexcused absences will result in a decrease in the course grade
Course Topics
This course will present the fundamental concepts in database management. The following topics will be covered.

1. Oracle Database Introduction
2. SQL
3. Data modeling: entity-relationship approach, Relational model
4. Database Design
5. Database programming basics (JDBC): Oracle with JDBC frontend.
6. PL/SQL
7. Constraints and triggers
8. Transactions, security, and authorization in SQL
9. Data storage and index structures
10. Recovery
11. Concurrency control
12. Distributed databases

Lecture Schedule
This is a tentative outline of when the various topics will be covered. You are expected to have Schedule: read the designated chapters prior to attending the class. Exams will generally be based on material covered in class, but not necessarily restricted to it. The slack in the schedule provides for spill over and scheduling lectures for additional topics.

Student Responsibilities
Student's are responsible for reading all assigned text materials, handouts, and referenced sources. Students are responsible for participating in classroom discussions and discussions carried out electronically though Blackboard or other class facilities.
The CIS laboratory computer systems are available for use in homework and laboratory exercises. Access to the computer systems in CIS labs is through Temple University AccessNet username and password. Wachman laboratories 104, 200, 207, and 209 have dual boot Windows and Linux systems. We will be using the computer systems in room 104 for laboratory assignments. These systems will have access to both Linux and Windows source code for laboratory work. You are responsible for performing and completing all of the laboratory exercises. This includes becoming familiar with, and being able to use, all of the tools and software that are to be used in these exercises. 

Students are responsible for taking all quizzes and exams in the course. All work turned in for grading or review by the instructors of the course must be the students own work. The objectives of the course can only be met by your doing all of the work and presenting only your work for grading. Presenting work that is not your own will result in disciplinary action.

Student attendance to each class and each laboratory is Mandatory. 
Students who miss the final exam and do not make alternative arrangements with me before I turn in grades, will receive a grade of F.

Collaboration and Cheating Policy

You are welcome to discuss assignments and laboratory projects with other students, provided that all work turned in must be your own. If you do discuss your work on assignments with other students, please list your collaborators at the top of your assignment, underneath your name. This does not excuse you from submitting your own work! For the in-lab parts of laboratory projects completed in teams, both team members should contribute equally and will be graded individually. The write-ups and out-of-class portions of labs must be completed independently.
In summary, when you are turning in an assignment with your name on it; what you turn in must be your work, and yours alone. Cheating will not be tolerated.