CIS 4301 (Information & Database Systems I)

Instructor:	Tamer Kahveci
Email:	tkahveci @ ufl
Location:	Norman Hall (NRN), 1020
Time:	Monday/Wednesday/Friday 4th period (10:40 - 11:30 AM)
Section:	1304
Office hour:	Monday/Wednesday (11:40 AM - 12:30 AM)
Contact:	E566 (office), (office phone) 352-294 6654
TAs:	Zachary Allen (zachary.allen@ufl.edu) Ke Chen (ke.chen@ufl.edu) William Coggins (william.coggins@ufl.edu) Natalie Kwak (kwakn@ufl.edu) Qing Li (li.qing@ufl.edu) Antwane Mason (antwane.mason@ufl.edu) Avary McCormack (a.mccormack@ufl.edu) Heng Zhou (zhouheng@ufl.edu) Michelle Zou (mzou@ufl.edu)

Goals:

This course covers the topics needed to understand how database systems can be used to store and access data. This course avoids the low level details on how the database is stored on disk and how the queries are acutally implemented. Instead, this course assumes that these are already implemented and explains the logical structure of the data and how it can be queried using high level querying languages.

Announcements:

Zoom link "https://ufl.zoom.us/my/tkahveci join meeting -> tkahveci (passcode = 231442)
Here is the course syllabus
You will use Canvas to submit soft copies of your homeworks (if needed) and check grades.
You can follow the weekly progress of the classes from here.
Test 1 will be held on October 4, 2023
Test 2 will be held on November 1, 2023
Test 3 will be held on December 1, 2023
Check the class page regularly for announcements

Topics:

I am planning to cover the following topics.

Relational data model.
Design issues in Relational Databases (dependencies, decompositions)
Database models (E/R model, UML)
Relational algebra
Structured Query Language
Constraints
Database Views and Indexes

Grading:

Exams: Test 1 (23%) Test 2 (23%) Final (23%)
Homeworks (31%)

Text book:

First Course in Database Systems, Third Edition, ISBN: 013600637X, Prentice Hall, by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom

Note that this is the first half of "Database Systems: The Complete Book, 2nd Edition" by the same authors. If you would like to learn details on implementation of database systems, I recommend you to buy the complete book.

Other:

Check out disability resources.
Cheating, plagiarism, and other types of academic dishonesty will be subject to punishment.
I encourage class attendence.
Please return your homeworks, project and surveys in time. Late returns will cause 20 % deduction in your grade for that homework (etc) for each late day. Submissions after 5 days from the due date will not be graded.
Please visit only during office hours. If you really need to meet me out of the office hours email me to make an appointment. If I postpone or cancel the office hour, I will post it in the announcements section and (try to) put a note on my office door.
Please avoid any activities that will disturb the flow of the lectures: Silence your cell phones, pagers, etc.

Tamer Kahveci