COP4710 Database Systems (Fall 2021)

Instructor: Peixiang Zhao

| Syllabus | Announcement | Schedule | Assignment | Project | Resources |

Basic Information


Textbooks and readings


Students should come with good programming skills. The courses COP3330: Object-oriented Programming and MAD2104: Discrete Mathematics, or equivalents, are required. If you are not sure whether you have the right background, please contact the instructor.

Note: We will not cover programming-specific issues in this course.

Format and activities

The course is lecture-based with two examinations (midterm and final). There are individual assignments and a group-level programming project. In order to encourage attending classes and participating dicussions, there will be several in-class quizzes for students.


Course Objectives

Course Discription

As the first introductory course for databases, COP4710 studies the fundamentals of relational database management systems (RDBMS). Materials include, but are not limited to, the ER(Entity-Relationship) model and its mapping to the relational data model, the algebraic language in the relational data model and its relationship to the commercial relational query language: SQL, database design that conforms to different normal forms, database applications, database indexing, transaction management, recovery and other advanced topics. Furthermore, students will participate in a semester-long project and build a web-based database system (e.g., an online bookstore) starting with a customer specification. In summary, this course is about the principles of designing and developing applications using relational database systems.

Course Policies

General Policy

Collaboration/Academic Honesty

All course participants must adhere to the academic honor code of FSU which is available in the student handbook. All instances of academic dishonesty will be reported to the university. Evey student must write his/her own homework/code (unless you are in the same group for the programming progject). Showing your code or homework solutions to others is a violation of academic honesty. It is your responsibility to ensure that others cannot access your code or homework solutions. Consulting related textbooks, papers and information available on Internet for your coding assignment and homework is fine. However, copying a large portion of such information will be considered as academic dishonesty. If you borrow a small piece of any such information, please acknowledge that in your assignment. Please see the following web site for a complete explanation of the Academic Honor Code.

Late Policy and Make-up Exams

Students with Disabilities

Americans With Disabilities Act: Students with disabilities needing academic accommodation should: (1) register with and provide documentation to the Student Disability Resource Center; (2) bring a letter to the instructor indicating the need for accommodation and what type. This syllabus and other class materials are available in alternative format upon request. For more information about services available to FSU students with disabilities, contact the: Student Disability Resource Center, 874 Traditions Way, 108 Student Services Building, Florida State University, Tallahassee, FL 32306-4167, (850) 644-9566 (voice), (850) 644-8504 (TDD),,

Grading Policy

The course grade will break down as follows,

Any regrading request should be submitted to the intructor or the TA(s) within one week since the graded deliverables are handed out to the students.

And your final grade will be assigned as follows, This table indicates minimum guaranteed grades. Under certain limited circumstances (e.g., an unreasonably hard exam), we may select more generous ranges or scale the scores to adjust.

Last updated: Jun. 23rd, 2021