CIS 4301: Information and Database Systems I

Course Syllabus - Fall 2007

 

·         Course Information:

  • Credits: 3
  • Section: 1304
  • Prerequisite: CIS 3020 or CIS 3023, COT 3100
  • Instructor: Prof. Alin Dobra
  • Meeting Times: Tuesday 3:00 to 4:55, Thursday 4:05 to 4:55
  • Where: CSE Building, E119
  • Class web page: http://www.cise.ufl.edu/class/cis4301fa07/
  • Textbook: Database Management Systems, Ramakrishnan and Gehrke (third edition)

·         Course Objectives and Outline:

This course is the first in a two-course sequence that serves as an introduction to modern database systems. This first course provides an in-depth view of databases from a sophisticated user's perspective. Essentially, when you are done with this class you will know the right way to design and implement software that uses a database as a back end to store and manage data. We will not cover database internals or how to tweak them in order to get them to run fast; that is the topic of the next course in the sequence.

·         Topics to be covered:

In the class we will cover the following topics (the number in parenthesis is the corresponding chapter in the textbook).

  • Introduction (1)
  • ER Model and Conceptual Design (2)
  • The Relational Model and SQL DDL (3)
  • Relational Algebra and Relational Calculus (4)
  • SQL (5)
  • Database Application Development (6)
  • Oracle PL/SQL (not in textbook)
  • Internet Applications (7)
  • Overview of Transaction Management (16)
  • Concurrency Control (17)
  • Recovery (18)
  • Schema Refinement, Functional Dependencies, Normalization (19)
  • Security and Authorization (21)
  • Other advanced topics (time permitting)

·         Homework:

We will have 4-5 homework assignments through the semester. The homework problems have to be handed in at the beginning of the class in the day they are due. You can either type of write by hand the homework as long as it is legible and does not put unnecessary strain on the grader. Late submission of homework is not allowed unless specifically permitted in advance by the instructor. You are expected to work on the homework problems on your own and to use only the textbook (no online resources unless explicitly specified).

·         Grading Policy:

homework (15%)

project (30%)

midterm exam  (25%)

accumulative final exam (30%)

 

 

NOTE: the letter grade will be based on the final accumulated score in the following manner:

  • 90 -- 100 A
  • 85 -- 89 B+
  • 80 -- 84 B
  • 75 -- 79 C+
  • 70 -- 74 C
  • 65 -- 69 D+
  • 60 -- 64 D
  • 0 -- 59 E

·         Important Notes:

1.      All exams are closed-book and closed-notes. You are allowed to bring a two sided, letter size, hand written piece of paper to the exam. A student with a proper excuse of being absent from the examination must inform and get a permission from the instructor prior to the time of an examination. Any students who do not take the examination at the scheduled time will receive a zero score.

2.      All homework must be submitted using Coursetool before the due date. No credit will be given to any late submission. Handwritten solution will not be considered. Either individual and/or team-based homework / project may be given. Details will be announced.

3.      You should try to be as clear and precise as possible in your answers of homework assignments, project and exams. Correctness of a solution will be determined solely by the information on the exam or the homework paper.

4.      To request a re-grade of homework and exams, you should attach a short note stating the reasons that you think a re-grade is necessary and submit to the instructor within a week from the date that the paper is returned.

5.      Attending lectures and viewing the lecture tapes are the responsibility of students. All homework, projects and exams will be from the material covered in the lectures.

·         Academic Honesty

 

·         Honor Code Oath

"We, the members of the University of Florida community, pledge to hold ourselves and our peers to the highest standards of honesty and integrity."