|Time: 3:05-4:25 pm, Monday and Wednesday||Location: Instr Center 117|
Office hours: 2:00-3:00 pm, Monday and Wednesday, and by appointment
Office: Klaus 2320
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.
|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%|
The policy for regrading is as follows:
|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||7, 8||4, 5, 9|
|4||Normalization and Physical Design||10, 11, 13, 14||15, 16, 17, 18|
|Final||Comprehensive (all of the above)||Apr 29||All of the above||All of the above|
|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.
Interactive interpreter tool for relational algebra
|Date||Topic||Chapters (5th Edition)||Chapters (6th Edition)|
|Jan 07||Welcome and introduction (guest lecture by Prof. Sham Navathe)|
|Jan 09 |
|Basic concepts||1, 2||1, 2|
|Jan 16 |
|Conceptual database design - Entity-Relationship Model||3, 4||7, 8|
|Feb 04||DBMS Design Methodology||notes (GTPEMethodology.pptx)|
|Relational Data Model - introduction, relational algebra, relational calculus||5, 6||3, 6|
|Mar 04||Mapping from ER Model to Relational Model||7||9|
|SQL Query Language||8||4, 5|
|Holiday: Spring Break|
|SQL Query Language (Contd.)||8||4, 5|
|Relational database design - normal forms, functional dependencies||10, 11||15, 16|
|Physical database design - storage structures||13, 14||17, 18|