• 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 02/27

  9. Ex9. Declaring Relations in SQL: assigned and due on 02/27

  10. Ex10. Modifying Relations in SQL: assigned and due on 02/27

  11. Test Linux hosts and DBMS access: assigned and due on 03/01

  12. Handling Weak Entity – Q6: assigned and due on 03/03

  13. Handling ISA relationship – Q7: assigned and due on 03/03

  14. Declaring Relations in SQL – Q8: assigned and due on 03/08

  15. Modifying Relations in SQL – Q9: assigned and due on 03/10

  16. Relational Algebra on Sets – Q10: assigned and due on 03/17

  17. Relational Algebra on Sets – Q11: assigned and due on 03/22

  18. Functional Dependencies (Q12): assigned and due on 04/12

  19. Normal Form and Normalization (Q13): assigned and due on 04/14

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

  21. 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. Phase 2. Creating E-R Model: assigned on 02/11 and due by 02/25

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

  4. Phase 2. Improving E-R Model in Group: assigned on 02/27 and due by 03/03

  5. Phase 3. Designing and Implementing Relational Database Schema: assigned on 02/27 and due by 03/30

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

  7. Phase 5. Queries and Preparation for Project Demo: 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 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/27

  7. MariaDB Commands: assigned on 02/27

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

  9. Chapter 6: assigned on 04/01

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

  11. MariaDB Commands: assigned on 04/24

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

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

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

  15. 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

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. Individual Assignment: assigned on 02/27

  4. Individual Assignment: assigned on 02/27

  5. Individual Assignment: assigned on 02/27

Due by 03/01

  1. Individual Assignment: assigned on 03/01

Due by 03/03

  1. Individual Assignment: assigned on 03/03

  2. Individual Assignment: assigned on 03/03

  3. Group project: assigned on 02/27

Due by 03/04

  1. Group project: assigned on 02/25

Due by 03/05

  1. Individual Assignment: assigned on 03/05

Due by 03/08

  1. Individual Assignment: assigned on 03/08

Due by 03/10

  1. Individual Assignment: assigned on 03/10

  2. Individual Assignment: assigned on 03/10

Due by 03/17

  1. Individual Assignment: assigned on 03/17

Due by 03/22

  1. Individual Assignment: assigned on 03/22

Due by 03/30

  1. Group project: assigned on 02/27

Due by 04/12

  1. Individual Assignment: assigned on 04/12

Due by 04/14

  1. Individual Assignment: assigned on 04/14

Due by 04/26

  1. Group project: assigned on 04/01

Due by 05/10

  1. Group project: assigned on 04/24