- Information
- AI Chat
CS 6400 Database Systems Concepts AND Design
Db Sys Concepts& Design (CS 6400)
Georgia Institute of Technology
Recommended for you
Preview text
CS 6400 DATABASE SYSTEMS CONCEPTS AND DESIGN – SUMMER 201 8 (OMSA)
Instructor: Will Johnson; tjohnson306@gatech
Course Creator: Leo Mark ; leo@pe.gatech
Head TA: Peter Graening; peter@gatech
Several additional TAs: (TBD)
Office hours: Probably Thursday 7-8 pm EST (details TBD)
Overview: We believe in learning-by-example and learning-by-doing. This course presents an example of applying a database application development methodology to a major real -world project. All the database concepts, techniques and tools that are needed to develop a database application from scratch are introduced along the way when they are needed. In parallel - slightly delayed - learners in the course will apply the database application development methodology, the techniques and the tools to their own major class team project. In addition to the development methodology, techniques and tools learned in this course will include the Extended Entity Relationship Model, the Relational Model, Relational algebra, calculus and SQL, database normalization, efficiency and indexing. Finally, techniques and tools for metadata management and archival will be presented.
Prerequisites : Learners should be familiar with at least one scripting or programming language, e. PHP, Python, Java. Some familiarity with software engineering concepts and Git/source control will be helpful. Flexibility to work remotely with team members.
Learning Outcomes: At the end of this course the learner will: § Understand and apply the concepts of data independence, database and database management system architecture, and the role and placement of a database management system the application stack § Understand and apply the theoretical foundation of relational databases and query languages to create SQL data structure definitions and queries that meet identified requirements § Create a relational database application, including the requirement analysis, specification, design and implementation of relational database applications § Evaluate alternative internal schema structures and create indices for efficient database operation
Grading Summary:
1% Onboarding Exam 1% Initial Survey 50% Three exams - Exam 1 – 15% - Exam 2 – 20% - Exam 3 – 15% 37% Three project phases (12% each) 10% Team assessment
Please note: If your team assessment for a phase of the project indicates that you did no work on that phase, you may receive a reduced grade or even a zero for that phase, and it will be your responsibility to justify why you should share the grade that your team earned.
Date Event Topic or Deliverable Chapters Lecture Videos 6/24 Midnight AoE Phase 2 due Design: § (revised) EER diagram § EER to Relational mapping. (25%) § SQL Create Table statements (25%) § Task designs w/abstract code that refers to EER replaced w/SQL that refers the relations (50%)
5, 6, 7, 9 Methodology III: Design; Methodology III: Design [SQL]
6/28 Midnight AoE – 7/1 Midnight AoE
Exam 2 Relations, algebra, calculus, map ER, EER to relations
5, 6, 7, 8,
9
EER Relational Mapping; Relational Query Languages: Algebra, Calculus, SQL 7/8 Midnight AoE Phase 2 Team Evals due 7/3 – 7/4 – Holiday Independence Day 7/12 Midnight AoE – 7/15 Midnight AoE
Exam 3 FDs, Normalization, file organization, indexing
14, 15,
15, 16,
17
Normalization, Efficiency; Indexing
7/22 Midnight AoE Phase 3 due Implementation: - Evaluation of completed functionality demonstrated by your team, incorporating inserts, updates, deletes, and queries - Specific criteria will be provided later this semester
10, 11,
14, 15,
15, 16,
17
Methodology IV: Implementation
7/25 – 7/29 Demos 7/29 Midnight AoE Phase 3 Team Evals due Before 8/3 Course Instructor Opinion Survey (CIOS) 8/3 Official end of term. Note: all chapters listed are for the 7th edition of the textbook
You will receive all assignments and projects through Canvas, and each entry will show a due date. Please be sure to complete all assignments and projects by their due date, as late work will not be accepted for grading and no credit will be granted for work not completed and submitted on time. You will also receive grades and information on how much each graded item counts toward the overall grade for the course through Canvas.
Communications: We will be using Piazza a s a forum. Please submit all of your course-related questions through Piazza. Please also make sure to read all Piazza postings, or you may miss important information about the course and the project. You should check Piazza every day throughout the semester.
Office hours will be held. All students are strongly encouraged to either watch in real time, or watch the recording, as information given during the office hour may not be presented separate from the office hour.
Please do not contact the course staff via email or Canvas. Any communications received outside of Piazza may be ignored or discarded. When posting on Piazza, make sure to post to the “Instructors” group (not an individual) or your post may not be answered in a timely manner.
Required text : Elmasri & Navathe: Fundamentals of Database Systems. 7 th Edition. Pearson 2016. Please respect the intellectual property and hard work of the textbook authors and purchase a licensed copy of the text, either electronic or physical. A downloaded PDF from the Internet is NOT a legal copy of the text. Prior editions of the text are not supported in this course. Additional course material will be available online.
Additional Resources: WAMP installation guide, and more will be posted online.
Academic honesty : All Georgia Tech students are expected to uphold the Georgia Tech Academic Honor Code. Deep collaboration within project teams is encouraged. Collaboration between teams is not allowed in any way whatsoever. Any of your work from this class may not be shared publicly.
Diversity and Disability Statement: Georgia Tech values diversity and inclusion; we are committed to a climate of mutual respect and full participation. Our goal is to create learning environments that are usable, equitable, inclusive and welcoming. If there are aspects of the instruction or design of this course that result in barriers to your inclusion or accurate assessment or achievement, please notify the instructor as soon as possible. Students with disabilities should contact the Office of Disability Services to discuss options of removing barriers in this course, including accommodations. ODS can be reached at 404.894, dsinfo@gatech, or disabilityservices.gatech
CS 6400 Database Systems Concepts AND Design
Course: Db Sys Concepts& Design (CS 6400)
University: Georgia Institute of Technology
