|Class hours:||MWF 1:00pm – 1:50pm|
|Class location:||Chemistry-Physics Bldg, Rm. 220|
|Office Address:||233 James F. Hardymon Building|
|Office hours:||Wednesdays 9am-11am or by appointment|
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.
CS 315 (Algorithm design and analysis) and graduate or engineering standing
The student is expected to be familiar with
- Basic programming language concepts, and with a variety of mathematics tools for modeling and analyzing discrete structures.
- Data structures, algorithm design and analysis technique.
- Concepts of propositional logic and proof construction, including induction.
- 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:
- Understand and appreciate the theoretical foundation of database systems.
- Become proficient using SQL.
- Use sound design principles when designing a database.
- Become familiar with databases in client server environment.
- Build a client-side user interface to a database.
Fundamentals of Database Systems (7th edition) by Ramez Elmasri and Shamkant B. Navathe
Grading scale for undergraduates:
- Homework/Programming Assignments (25%)
- Midterm (20%): Wednesday, March 7
- Final (25%): Wednesday, May 2
- Close book and notes
- Project team: each team consists of up to 4 people.
- Deliverables: mid-project report (due March 9), final project report and program (due April 20)
- Clear statement of contribution for each team member
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.
- Homework assignments and project deliverables will be posted and submitted electronically via Canvas https://uk.instructure.com/courses/1908573.
- Late submission will be penalized 10% per day within 3 days. Submission that is late for more than 3 days will not be accepted.
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
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).
Senate Rules 188.8.131.52 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 184.108.40.206 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
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.