• All dates are in the format of MM/DD where MM is the month and DD is the day.
  • Assignment descriptions are on CUNY Blackboard if not found in the lecture notes or on the class schedule page.
  • This list is periodically updated based on the progression of the class

Overview of Assignments by Type

Individual Assignments

  1. Ex1. Creating E-R diagrams: assigned and due on 02/11

  2. Ex2. Creating E-R diagrams: assigned and due on 02/13

  3. Ex3. (Optional) Creating E-R diagrams: assigned and due on 02/18

  4. Ex4. Relational Model: assigned and due on 02/18

  5. Ex5. E-R Model to Relational Model: assigned and due on 02/20

  6. (Optional) Ex6. E-R Model to Relational Model (Handling Weak Entity): assigned and due on 02/27

  7. (Optional) Ex7. E-R Model to Relational Model (Handling ISA relationship): assigned and due on 02/27

  8. Ex8. Experimenting with Linux hosts and DBMS access: assigned and due on 03/04

  9. Ex9. Declaring Relations in SQL: assigned and due on 03/11

  10. Ex10. Modifying Relations in SQL: assigned and due on 03/11

  11. Ex11. Relational Algebra on Sets: assigned and due on 03/18

  12. Ex12. Relational Algebra on Sets and SQL Implementations: assigned and due on 03/20

  13. In-Class Exercise 13 (on Functional Dependencies): assigned and due on 04/08

  14. In-Class Exercise 14 (on Normal Form and Normalization): assigned and due on 04/10

  15. Aggregation, Grouping, and Subquery – Q14: assigned and due on 03/05

  16. Views, Index, and Transactions – Q15: assigned and due on 03/10

Group Project

  1. Phase 1. Group Forming and Project Proposal: assigned on 02/04 and due by 02/11

  2. Project Presentation (Phase 1 Result): assigned on 02/11 and due by 02/20

  3. Phase 2. Creating E-R Model: assigned on 02/11 and due by 02/25

  4. Project Presentation (Phase 2 Result): assigned on 02/25 and due by 02/27

  5. Phase 3. Improving E-R Model and Designing and Implementing Relational Database Schema: assigned on 02/25 and due by 03/11

  6. Project Presentation (Phase 3 Result): assigned on 03/04 and due by 03/27

  7. Phase 4. Querying the Database (in Relational Algebrea and in SQL): assigned on 03/04 and due by 03/25

  8. Project Presentation (Phase 4 Result): assigned on 04/01 and due by 04/01

  9. Phase 5. Querying the Database in Application Setting: assigned on 04/01 and due by 04/26

  10. Phase 6. Revising the Database Design via Database Normalization and Denormalization: assigned on 04/01 and due by 04/26

  11. Phase 7. Preparation for Project Demo and Final Presentation: assigned on 04/24 and due by 05/10

Reading

  1. Sections 1.1 - 1.8: assigned on 01/28

  2. Chapters 2: assigned on 01/30

  3. Chapter 4: assigned on 02/04

  4. Chapter 3: assigned on 02/11

  5. Sections 7.1 (SQL data types), 8.1 and 8.2 (Relation declaration), 8.3 (Altering Structures of Relation), 8.4 (Modifying Relations), Sections 3.4 (Relational Algebra) : assigned on 02/25

  6. Sections 3.4 (Relational Algebra) : assigned on 03/04

  7. all chapters or sections discussed: assigned on 03/20

  8. Chapter 6: assigned on 04/01

  9. Sections 7.5, 7.7, 7.8, 7.9, 7.11; Sections 8.4, 8.5, 8.6, 8.7: assigned on 04/24

  10. MariaDB Commands: assigned on 04/24

  11. Sections 3.8, 8-2d; 10.1; 15.1: assigned on 05/06

  12. Relevant chapters in the textbook; lecture notes; review guides and tests; project;: assigned on 05/08

  13. Relevant chapters in the textbook; lecture notes; review guides and tests; project;: assigned on 05/13

  14. Relevant chapters in the textbook; lecture notes; review guides and tests; project;: assigned on 05/15

Overview of Assignments by Due Date

Due by 02/11

  1. Individual Assignment: assigned on 02/11

  2. Group project: assigned on 02/04

Due by 02/13

  1. Individual Assignment: assigned on 02/13

Due by 02/18

  1. Individual Assignment: assigned on 02/18

  2. Individual Assignment: assigned on 02/18

Due by 02/20

  1. Individual Assignment: assigned on 02/20

  2. Group project: assigned on 02/11

Due by 02/25

  1. Group project: assigned on 02/11

Due by 02/27

  1. Individual Assignment: assigned on 02/27

  2. Individual Assignment: assigned on 02/27

  3. Group project: assigned on 02/25

Due by 03/04

  1. Individual Assignment: assigned on 03/04

Due by 03/05

  1. Individual Assignment: assigned on 03/05

Due by 03/10

  1. Individual Assignment: assigned on 03/10

Due by 03/11

  1. Individual Assignment: assigned on 03/11

  2. Individual Assignment: assigned on 03/11

  3. Group project: assigned on 02/25

Due by 03/18

  1. Individual Assignment: assigned on 03/18

Due by 03/20

  1. Individual Assignment: assigned on 03/20

Due by 03/25

  1. Group project: assigned on 03/04

Due by 03/27

  1. Group project: assigned on 03/04

Due by 04/01

  1. Group project: assigned on 04/01

Due by 04/08

  1. Individual Assignment: assigned on 04/08

Due by 04/10

  1. Individual Assignment: assigned on 04/10

Due by 04/26

  1. Group project: assigned on 04/01

  2. Group project: assigned on 04/01

Due by 05/10

  1. Group project: assigned on 04/24