CSCI 4333 Design of Database Systems: Course Contents in Concept Maps

by K. Yue

Syllabus in Concept Map

A concept map (CM) shows concepts and their relationships. There are hundreds of relevant concepts in a class. The CM below identifies the main concepts in this class and how they are related.

Syllbaus in Cm

 

Relationships with Student Learning Objectives (SLO)

Student Learning Objectives (SLO): After completing the course, the students are expected to be able to

  1. Describe the stages of database design, various database architectures, and data models.
  2. Explain the concept of entity-relationship model, and relational model.
  3. Explain the theoretical background of relational database: relational algebra and relational calculus.
  4. Implement relational database systems using DBMS, SQL, including both data description and manipulation languages.
  5. Explain the importance of normalization of databases, and convert a given relational database into different normal forms.

The following CM shows how these SLOs are related.

SLO in CM

Relationships with Homework Assignments

Focuses of Homework Assignments:

  1. HW #1: Simple query in Microsoft Access
  2. HW #2: Simple queries in SQL and MySQL; Keys in the relational model
  3. HW #3: Constructing Entity Relationship Diagram (ERD) to capture the requirement of a database problem
  4. HW #4: Converting the ERD to relation schema
  5. HW #5: Relational Calculus, Relational Algebra and DDL in MySQL
  6. HW #6: Queries in SQL
  7. HW #7: Embedded SQL programming with Python
  8. HW #8: SQL Queries in Bitcoin
  9. HW #9: Relational DB design and normalization theory
  10. HW #10: Web Database Development using Python and MySQL

HW in CM

Relationships with Applied Critical Thinking (ACT)

EoT in CM