Course Information

Class hours:MWF 1:00pm – 1:50pm
Class location:Chemistry-Physics Bldg, Rm. 220
Instructor:Licong Cui
Office Address:233 James F. Hardymon Building
Email: licong.cui@uky.edu
Office Phone:859-257-3062
Office hours:Wednesdays 9am-11am or by appointment
Course website:https://uk.instructure.com/courses/1908573

Course Description

Study of fundamental concepts behind the design, implementation and application of database systems. Brief review of entity-relationship and an in-depth coverage of the relational model including relational algebra and calculi, relational database theory, concepts in schema design and commercial database languages.

Prerequisites

CS 315 (Algorithm design and analysis) and graduate or engineering standing

Expected Preparation

The student is expected to be familiar with
  1. Basic programming language concepts, and with a variety of mathematics tools for modeling and analyzing discrete structures.
  2. Data structures, algorithm design and analysis technique.
  3. Concepts of propositional logic and proof construction, including induction.
  4. Elementary set theory including concepts of relations and functions from an abstract point of view.

Student Learning Outcomes

After completing this course, the successful student will be able to:
  1. Understand and appreciate the theoretical foundation of database systems.
  2. Become proficient using SQL.
  3. Use sound design principles when designing a database.
  4. Become familiar with databases in client server environment.
  5. Build a client-side user interface to a database.
Textbook (Required)

Fundamentals of Database Systems (7th edition) by Ramez Elmasri and Shamkant B. Navathe

Grading Criteria

Grading scale for undergraduates: 90 – 100% = A; 80 – 89% = B; 70 – 79% = C; 60 – 69% = D; < 60% = E.
Grading scale for graduate students: 90 – 100% = A; 80 – 89% = B; 70 – 79% = C; < 70% = E.

Grade normalization, if any, will be done against peer students, i.e., undergraduates will only be normalized with undergraduates, and graduates with graduates.

Course Policies

Submission Policy:
Academic Integrity:
Students can discuss the content covered in the class, but need to independently complete the homework assignments. For collaborative course projects, clear statements of each member’s contribution need to be included in the written reports. Proper acknowledgement is required if you borrow idea or content from other sources. More information about University policy for plagiarism and cheating can be found at http://www.uky.edu/Ombud/Plagiarism.pdf

Attendance Policy:
According to the University policy, students are expected to withdraw from the class if more than 20% of the classes scheduled for the semester are missed (excused or unexcused).

Excused Absences:
Senate Rules 5.2.4.2 defines the following as acceptable reasons for excused absences: (a) serious illness, (b) illness or death of family member, (c) University-related trips, (d) major religious holidays, and (e) other circumstances found to fit “reasonable cause for nonattendance” by the professor. See http://www.uky.edu/Ombud/ForStudents_ExcusedAbsences.php for more information.

Verification of Absences:
Students must notify the instructor of an absence within one week after the absence. Students may be asked to verify their absences in order for them to be considered excused. Senate Rule 5.2.4.2 states that faculty have the right to request “appropriate verification” when students claim an excused absence because of illness, or death in the family. Appropriate notification of absences due to University-related trips or a major religious holiday is required prior to the absence.

Accommodations due to disability:
Students who have a documented disability and require academic accommodations are encouraged to contact the instructor as soon as possible. In order to receive accommodations in this course, students must provide the instructor with a Letter of Accommodation from the Disability Resource Center (DRC) for coordination of campus disability services. The DRC is located in Suite 407 of the Multidisciplinary Science Building, 725 Rose Street, Lexington, KY 40536-0082. Please call (859) 257-2754 to contact the DRC by phone.