Database Systems–Spring 2018

CSCI 3410

Clément Aubert

May 4, 2018

Quick Facts

Presentation

Course Description

This course offers an introduction to database systems as a key concept in information management. The course covers logical and physical database organization, data models, file structures, indexing, hashing, query optimization, and design issues. This course will cover the design and implementation of databases.

Learning Outcomes

Upon successful completion of this class, the student will:

Format and Procedures

Lectures are devoted to general explanations of the concepts and ideas underlying the topic at stake. All practical work, coding, programming, testing, etc. will be carried at home.

Homework assignments will assist the students in making sure they understand classes expectations and the content of the lecture, as well as to practice their coding and problem-solving skills. Additional resources will be used on a regular basis. The progression of the students will be regularly tested and assessed through quizzes and tests. Active and relevant participation during the lectures is appreciated.

Teaching Philosophy

It is our mutual interest for you to succeed: I love to share knowledge and to expand it by helping students, and students want to gain a useful and agreeable experience that will prove valuable in their future endeavors. To this end, here is:

What I’m expecting from you

  • Check the announcements periodically on the class website.
  • Read this entire syllabus carefully.
  • Participate actively in all class discussions.
  • Do the homeworks wisely: read your notes before starting the homework assignment, make sure you understand it completely before considering it done.
  • Come prepared and on time to classes, exams and quizzes.

What you should expect from me:

  • Clear and accessible lectures.
  • Fair and impartial grading.
  • Availability, during office hours, by appointment, and by email.
  • Open hear to your suggestions to improve this class.
  • Dedication to your success!

Course Requirements

Practical Information

Time and Place

Monday and Wednesday, 11:30 am–12:45 pm in Algood Hall, E-157

Instructor

Name Dr. Clément Aubert
Office Algood Hall E-128
Phone 706-737-1566
Email
Office Hours Monday 2:30 pm–4:30 pm, Thursday 3:00 pm–5:00 pm and by appointment
Institute School of Computer and Cyber Sciences vice Hull College of Business

Feel free to drop by when I’m in my office, but be aware that I may be busy, too: if you have multiple questions or if your question requires more than 5 minutes to be exposed and answered, please arrange an appointment with me.

Getting Help

I am committed to follow the principles of Universal design and try to construct a welcoming environment for every student. I should be your first point of entry, but getting help from other persons is perfectly acceptable and encouraged if you feel the need to.

For tutoring resources, consult the tutoring center.

Grades

Students will be evaluated using three different types of evaluation:

  1. Seven homework assignments will be given during the course of the semester: they are not expected to be handed back, and won’t be graded, but seven quizzes with questions taken or inspired from those assignments will be given. Those quizzes happen (almost always) every other Wednesday (see the planned schedule), are closed book and timed (5–20 min.).

  2. There will be two in-class exams, held during the regular class periods on Wednesday, 14th February, and Wednesday, 28th March.

  3. The final exam will take place during the exam period, i.e., Wednesday, 2th May, 11:00 am–1:00 pm, in AH E-157.

Your grade will be computed as follows:

Quizzes (×7) 20%
In-class Tests (×2) 40%
Final Exam 40%

using the following course grade scale:

Below 65 65–70 70–79 80–89 90–100
F D C B A

Planned Course Schedule

Week Date Topic Chapter Note
1 01/08 Syllabus, Introduction 1–1.3.4 Homework #1 released
2 01/15 Relational Data Model and Constraints 3 01/15: MLK day
3 01/22 Continued - 01/24: Quiz #1, Homework #2 released
4 01/29 SQL 4–4.4, 5.1–5.1.3, 5.1.7, 5.2, 5.4 -
5 02/05 Continued - 02/07: Quiz #2, Homework #3 released
6 02/12 Review Session - 02/14: Exam #1
7 02/19 Entity-Relationship Model 7–7.7, 7.9–7.10 02/21: Quiz #3, Homework #4 released
8 02/26 Database Design by mapping ER to relations 9–9.1 -
9 03/05 Normalization 15–15.4 03/07: Quiz #4, Homework #5 released
10 03/12 Database Design and UML diagrams 7.8, 10.3 -
11 03/19 Disk Storage and Hashing 17.4, 17.6–17.8.3 03/21: Quiz #5, Homework #6 released
12 03/26 Review Session - 03/28: Exam #2
13 04/02 - - Spring Break
14 04/09 Introduction to SQL Programming Using Java 13.3.2 04/11: Quiz #6, Homework #7 released
15 04/16 Continued - -
16 04/23 Introduction to Database Security 24.1–24.4 04/25: Quiz #7
17 04/30 - - 04/30 is end of class, 05/02, 11:00 am–1:00 pm, in AH E-157: Final

This schedule is subject to change and enhancements, but provide an indication of the pace, assignments, and major deadlines that you will need to plan for the semester.

Additional Material and Resources

Textbook

Textbook is optional, but strongly recommended. You can use either

Fundamentals of Database Systems (6th Edition) by Elmasri and Navathe, Pearson, 2010. ISBN-10: 0136086209. ISBN-13: 978-0136086208.

or

Fundamentals of Database Systems (7th Edition) by Elmasri and Navathe, Pearson, 2015. ISBN-10: 0133970779. ISBN-13: 978-0133970777.

The chapters in the schedule above are for the 6th edition, for the 7th edition, you should refer to the following table of correspondence:

Topic 6th edition 7th edition
Introduction 1–1.3.4 1–1.3.4
Relational Data Model and Constraints 3 5
SQL 4–4.4, 5.1–5.1.3, 5.1.7, 5.2, 5.4 6–6.4, 7.1–7.1.3, 7.1.7, 7.2, 7.4
Entity-Relationship Model 7–7.7, 7.9–7.10 3–3.7, 3.9, 3.11
Database Design by mapping ER to relations 9–9.1 9–9.1
Normalization 15–15.4 14–14.4
Database Design and UML diagrams 7.8, 10.3 3.8, Chapter removed
Disk Storage and Hashing 17.4, 17.6–17.8.3 16.4, 16.6–16.8.3
Introduction to SQL Programming 13.3.2 10.3.2
Introduction to Database Security 24.1–24.4 30.1–30.4

The textbook can be purchased through JagStore, select

Online Resources

Homework Assignments

Check the schedule for more information.

Snippets of Code

Documents Shared in Class

Date Title
03/15 Study Guide webpage, printable document

Miscellaneous