New semester starts. DB course on W/M/F 9:05-9:55AM at BEL 0102.
COP 4710-0001 Databases
Date: Aug 26-Dec 13, 2019
Time: M/W/F 9:05AM-9:55AM
Location: BEL 0102
Instructor: Jiawei Zhang
Email: jzhang [AT] cs.fsu.edu
Office: 169 James Love Building
Office Hours: W/F 10:00-11:00AM
TA: Yixin Chen (Assignments, Exams)
Office: MCH 101D
Office Hours: 10:00-12:00PM Wednesday
TA: Haopeng Zhang (Projet, Exams)
Office: MCH 101D
Office Hours: 3:00-5:00PM Monday
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.
Students should come with good programming skills. COP3330: Object-oriented Programming and MAD2104: Discrete Mathematics or equivalents courses are required. If you are not sure whether you have the right background, please contact the instructor.
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 in discussions, there will be several in-class quizzes for students.
The course grade will break down as follows