CS 4354: Concepts of Database Systems

Fall 2018

All the announcements and course contents will be available on Blackboard@TTU 

Class Time and Place

TR 6:30-7:40, Media & Communication, 00353

Prerequisite

CS 3364

Instructor

Md Ariful Islam: Email: ariful.islam@ttu.edu

Instructor's Office Hour

Thursday: 2-5 pm

Teaching Assistants

Shah Dewang  Email: dewang.shah@ttu.edu

Course Objectives

• Understanding of data modeling concepts

• Relational model for storage and retrieval of information

• Formal query languages

• Current database technologies such as SQL

Textbook

• Database Management Systems (3rd Edition) 

      Raghu Ramakrishnan and Johannes Gehrke

      Publisher: McGraw-Hill College

      ISBN-13: 978-0072465631 ISBN-10: 0072465638

Reference Books

• Database Systems: A Practical Approach to Design, Implementation, and Management (6th Edition)

      Thomas Connolly, Carolyn Begg.

      Publisher: Pearson

      ISBN-13: 978-0132943260; ISBN-10: 0132943263

​

• First Course in Database Systems (3rd Edition)

      Jeffrey D. Ullman, Jennifer Widom

      Publisher: Prentice Hall

      ISBN-13: 978-0132943260; ISBN-10: 0132943263

Grading Policy

The final grade for this course will be based on the following categories

• ​Attendance: 5%

  • Each 1 point ​penalty will be given to each missing after the first two absences

  • Absent with doctor's note is acceptable

• Project: 25%​

  • Each 2 (or 4)-member team is expected to carry out a design/implementation project​

• Homework: 20%​

  • Four homeworks: ​5% each

  • All homework must be submitted to instructor in the beginning of the class

  • No ​late homework submission is allowed

• Exam: 50%​

  • First exam: 15%, second exam: 15% and final exam: 20%​

  • No makeup for missing exam. Exception: medical issue, doctor 's note must be submitted

• Grading Scale​

  • A: 90-100; B: 80-89; C:70-79; D:60-69; F: ​59-0

​

Course Schedule

The following schedule of class lectures is subject to change. All changes will be announced as far in advance as possible on the course website (Blackboard). You are responsible for reading the appropriate chapter (check reading materials below) in the course textbook before each class. 

​

​

​

​

Ethical Conduct

The rule governing academic conduct and honesty by TTU and College of Engineering should be strictly obeyed. Zero tolerance to plagiarism- once  caught in any assignment (from a single homework or a project), all involved will get an F for this class and be reported to the university. Everything you do for credit in this course is supposed to be your own work. Whenever you have doubts about the problems in homework and assignment, discussing with TA or instructor is encouraged. However you need to write the solution yourself and list the contribution from other people.

Classroom Civility

All violation of classroom civility will be reported to the Student Judicial Programs. The TTU catalog states: "Students are expected to assist in maintaining a classroom environment that is conductive to learning." In order to ensure that all students gain from the time spent in class, students are prohibited from engaging in any form of distraction, e.g., reading newspaper (or other articles), working on other courses, and using cell-phones or laptops for calls or messages. If you indulge in any such inappropriate behavior, without explicit consent of the instructor, you will, at the very least, be asked to leave the classroom.

Student with Disabilities

Any student who, because of disability, may require special arrangements in order to meet course requirements should contact the instructor as soon as possible to make any necessary arrangements. Students should present appropriate verification from Student Disability Services during the instructor's office hours. Please note that instructors are not allowed to provide classroom accommodations to a student until appropriate verification from Student Disability Services has been provided. For additional information, you may contact the Student Disability Services office in 335 West Hall or 806-742-2405.

​

Useful Links​

• MySQL Website

• MSSQL Docker for Mac OS X