Assignment 1 Released; Project Stage Due Soon.
Course Project Released.
NA.
NA
COP 4710-0001 Databases
Date: Aug 27-Dec 14, 2018
Time: M/W/F 1:25PM-2:15PM
Location: MCH 0201
Instructor: Jiawei Zhang
Email: jzhang [AT] cs.fsu.edu
Office: 169 James Love Building
Office Hours: M/W 2:30-3:30PM
TA: Lin Meng and Jiyang Bai (Quizzes, Assignments, Exams)
Email: lm18h@my.fsu.edu and jb18x@my.fsu.edu
Office: MCH 101A
Office Hours: Tuesday 2:30-4:30PM
TA: Shaeke SALMAN (Project)
Email: ss17s@my.fsu.edu
Office: Dittmer 336, Desk TA19
Office Hours: Thursday 1:20-3:20PM
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.
Required textbook.
Recommended textbook.
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
Gemeral Policy