University of South Carolina

Department of Computer Science and Engineering

 

 

CSCE 520 – Database Management Systems

Fall 2023

 

Sections 001 & H10:Tuesday, Thursday  2:50 – 4:05pm

Section J60:  APOGEE class

 

Instructor:                   Csilla Farkas

Office:                         Horizon II, 2253

Office Hours:              Tuesday, Thursday 12:30 – 1:00 pm and 4:15 pm – 5:15 pm in-person or by appointment

E-mail:                                    farkas@cec.sc.edu

Class homepage:             https://cse.sc.edu/~farkas/csce520-2015/csce520.htm   

Graduate TA:              Nihang Fu

Office:                         Horizon II RM 2240

Office Hours:              TBA

Email:                         nihang@email.sc.edu

Description

Database management systems; database design and implementation

 

Prerequisite

CSCE 245 or GEOG 563 or permission of the instructor

 

Course Text

 

·        J. D. Ullman and  J. Widom: A First Course in Database Systems, 3rd edition, Prentice Hall, ISBN: 013600637X

 

Assignments:

·        Homework: there will be 8-10 homework assignments during the semester.  Homework should be individual work.  There will be a late submission penalty of 20%/day (including weekends) after the due date.  (You can always turn it in early.)

·        Quizzes: there will be several short quizzes reviewing materials from the previous lectures.

·        Exams: two open book tests will cover the course material.

 

 

Course Outcomes: Students will be able to:

·        Describe the major components of a database management system and state their

functions and purpose.

·        Develop a data model for a database application using an appropriate modeling tool such

as ER diagrams.

·        Use the concepts of data normalization to develop well-designed database applications.

·        Implement a database application using an appropriate relational DBMS.

·        Use SQL to access database information.

·        Describe major operational issues associated with database applications, including transaction management, security, and integrity.

 

Course Overview

Lectures slides, homework and project assignments, and announcements will be posted in MS Teams.  All class assignments and tests will be handled electronically.  Students expected to use MS Teams and the dropbox.cse.sc.edu website for class related materials and assignment submissions. 

 

Communication: Responses to email communication and questions will be provided within 2 workdays.

 

Assignment Grading: Grades for assignments will be returned within a week of due date (assuming the assignment is turned in on time).

 

Test Grading: Grades for tests will be returned within 72 hours of due date.

 

Technology

Students will use mySQL for hands-on homework assignments. 

 

Grading:

Assignments contribution to the final grade:

Quizzes: 10%, Homework assignments: 40%, Midterm: 20%Final exam: 30%

 

Undergraduate students will have 100 possible points.  Final grade will be assigned based on the percentage of points achieved by the students as follows.

 

Final grade:                             A  = ≥ 90%                         C = 70-74%

(undergraduates)         B+= 85-89%               D+= 65-69%

B = 80-84%                D = 60-64%

C+= 75-79%               F = < 60%

 

Graduate students will have 120 possible points.  Final grade will be assigned based on the percentage of points achieved by the students as follows.

 

Final grade:                             A  = ≥ 90%                         C = 70-74%

(graduates)                  B+= 85-89%               D+= 65-69%

B = 80-84%                D = 60-64%

C+= 75-79%               F = < 60%

 

Course Policies

Attendance: The course will be delivered online. It may be accessed either synchronously or asynchronously via the web. There is no expectation of physical attendance. 

 

Tardiness, late assignments: homework is due at midnight on the due date (submitted via dropbox.cse.sc.edu). Late assignments will be charged 20% per day. Dates for the exams are announced at the beginning of the semester and posted on the class’ website.  Students must complete the exams as scheduled unless impeding circumstances outside of their control.  Such circumstances must be clearly documented.

 

Policy on disabilities or special needs: Reasonable accommodations are available for students with a documented disability. Students, you have a disability and may need accommodations to fully participate in this class, contact the Student Disability Resource Center:  803-777-6142, TDD 803-777-6744, email sasds@mailbox.sc.edu , or stop by LeConte College Room 112A. All accommodations must be approved through the Office of Student Disability Services.   See https://www.sa.sc.edu/sds/.

 

Violations of academic honesty: Homework assignments and exams are expected to be the sole effort of the student submitting the work. All students are expected to practice the highest possible standards of academic integrity. Any deviation from this expectation will result in a minimum academic penalty of your failing the assignment and will result in additional disciplinary measures including referring you to the Office of Academic Integrity. Violations of the University's Honor Code include, but are not limited to, plagiarism, cheating, falsification, complicity, and any other form of academic misrepresentation. For more information, see https://www.sa.sc.edu/academicintegrity/

 

Diversity: To learn, we must be open to the views of people different that ourselves. In this time we share together over the semester, please honor the uniqueness of your fellow classmates and appreciate the opportunity we have to learn from one another. Please respect each other’s opinions and refrain from personal attacks or demeaning comments of any kind. Finally, remember to keep confidential all issues of a personal or professional nature that are discussed in class.

 

Topics covered

1. E/R diagrams

2. The relational database models

3. Relational algebra

4. SQL

5. XML and semi-structured databases

6. Datalog

7. Transactions

8. Access control