Recent News

• The final exam will be held on April 29 (Monday) during 2:50-5:40 pm in class. It will be comprehensive (include entire course material) and have the same format as the quizzes (open book/notes and multiple choice).
• Quiz 4 will be held on April 17 (Wednesday). It will be the same format as Quiz 3 (open book/notes and multiple choice).
• Solutions to phase 3 of the project are due by 5:00 pm on April 23 (Tuesday). There will be no extensions as group project demos will be held on 24th thru 26th (more details on demo scheduling to be provided soon).
• Quiz 3 will be held on April 1. It will be open book and the same format as Quiz 2.
• Solutions to phase 2 of the project are due in Klaus 2320 by 5:00 pm on March 29 (Friday).
• Solutions to phase 1 of the project are due on Feb 18 at the start of class. See the project deliverables for what to turn in. There will be no credit for turning in after the deadline except for personal emergencies approved by the Dean of Students.
• The regrade policy is specified below. It will be enforced without exception.

Course Information

Time: 3:05-4:25 pm, Monday and Wednesday	Location: Instr Center 117
Instructor: Mayur Naik Email: naik@cc.gatech.edu Office hours: 2:00-3:00 pm, Monday and Wednesday, and by appointment Office: Klaus 2320	Teaching Assistants: Mohan Sitaram Email: msitaram3@gatech.edu Office hours: 11:00-noon, Tuesday Office: Lounge beside Klaus 2324 Xin Zhang Email: xin.zhang@gatech.edu Office hours: 2:00-3:00 pm, Friday Office: Lounge beside Klaus 2324 Kunal Malhotra (Head TA - Project Only) Email: kunalxvision@gmail.com Office hours: None Office: Klaus 3319

Course Description

Required Textbook: The textbook is Fundamentals of Database Systems (Addison-Wesley) by Elmasri and Navathe. You can use either the 5th or 6th edition. Chapteter slides will be posted on T-Square under Resources.

Class Project: The course will involve a hands-on project to be done in teams of 3-4 students. The project will have three phases. Students will be given the choice of either the full or light version. In the light version, the third phase of the project will be replaced by assignments. The top teams doing the full project version will receive awards and be invited to demo their project to the class.

Prerequisites: Students are expected to already know or be willing to put in extra effort to master basic programming skills.

Discussion Forums: Use the appropriate forum (Group Formation, Project, or Course Content) on the course's piazza website.

Grading:

Class Participation	5% (distribution: survey=0.5%, notecard=0.5%, clicker=4%)
Quizzes 1-4	50% (12.5% each)
Project Phase 1	10% (distribution: EER=60%, IFD=30%, constraints=10%)
Project Phase 2	15%
Project Phase 3	heavy option = 20%, light option = 5%
Bonus Assignments	10%

The policy for regrading is as follows:

• Email your regrade request clearly to both the teaching assistants within a week of receiving your grade. Requests after a week will not be considered.
• We reserve the right to regrade your entire quiz/project. So, regrades may increase or decrease your score.
• Email your regrade request to the instructor if you are not satisfied with the handling of your regrade request by the teaching assistants.
• We realize that it is easy in multiple-choice quizzes to inadvertently mark the wrong answer. Since it is impossible to determine whether a wrong answer was inadvertent, however, we will not consider such regrade requests. We encourage you to use the extra time allotted for each quiz to avoid such mistakes.

Important Dates:

Quiz #	Topics	Date	5th Ed. Reading	6th Ed. Reading
1	DB Concepts and ER/EER Model	Jan 30	1, 2, 3, 4	1, 2, 7, 8
2	Relations, Algebra & Calculus, and QBE	Feb 27	5, 6	3, 6
3	ER-Relational Mapping and SQL	Mar 27 Apr 1	7, 8	4, 5, 9
4	Normalization and Physical Design	Apr 22 Apr 17	10, 11, 13, 14	15, 16, 17, 18
Final	Comprehensive (all of the above)	Apr 29	All of the above	All of the above

Project	Due Date
Assigned	Jan 25
Phase I	Feb 15 Feb 18 start of class
Phase II	Mar 27 Mar 29 by 5:00 pm
Phase III	Apr 23 by 5:00 pm

Project demo dates: Apr 24 thru 26 (more details on demo scheduling will be provided soon).

Academic Honesty: Students are expected to abide by the Georgia Tech Honor Code. Honest and ethical behavior is expected at all times. No collaboration is allowed between students in different project teams. All assignments must be done individually unless explicitly told otherwise. All incidents of suspected dishonesty will be reported to and handled by the office of student affairs.

Hands-on Tools

Interactive interpreter tool for relational algebra

• Download "raeval-0.3.1.jar" (tool executable) and "raeval-0.2-basic-instructions.pdf" (tool user guide) from here.
• Download data sets movies.csv and flights.csv.
• Find out whether your machine has Java installed by running command "java". If not, you can download and install Java from here.
• Start the tool by running command "java -jar raeval-0.3.1.jar". Read the tool user guide above for further commands.

Lecture Schedule

Date	Topic	Chapters (5th Edition)	Chapters (6th Edition)
Jan 07	Welcome and introduction (guest lecture by Prof. Sham Navathe)
Jan 09 Jan 14	Basic concepts	1, 2	1, 2
Jan 16 Jan 23 Jan 28	Conceptual database design - Entity-Relationship Model	3, 4	7, 8
Feb 04	DBMS Design Methodology	notes (GTPEMethodology.pptx)
Feb 06 Feb 11 Feb 13 Feb 18 Feb 20 Feb 25	Relational Data Model - introduction, relational algebra, relational calculus	5, 6	3, 6
Mar 04	Mapping from ER Model to Relational Model	7	9
Mar 06 Mar 11 Mar 13	SQL Query Language	8	4, 5
Mar 18 Mar 20	Holiday: Spring Break
Mar 25 Mar 27	SQL Query Language (Contd.)	8	4, 5
Apr 3 Apr 8	Relational database design - normal forms, functional dependencies	10, 11	15, 16
Apr 10 Apr 15	Physical database design - storage structures	13, 14	17, 18