ITEC 3335 Database Development:: 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.

cm

Relationships with Student Learning Objectives (SLO)

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

  1. Clearly describe the concepts of database development for problem solving.
  2. Broadly understand some relevant issues related to data (information) and databases.
  3. Construct valid and relevant data model using Entity-Relationship diagrams to analyze problems and design effective database solutions.
  4. Clearly understand the theory of the relational model and apply it to construct effective relational database solutions.
  5. Effectively construct Structured Query Language (SQL) solutions for relational databases.

The following CM shows how these SLOs are related.

CM_SLO

Relationships with Homework Assignments

Focuses of Homework Assignments:

  1. HW #1: Data connectivity and Microsoft Access, Excel, and MySQL
  2. HW #2: Query in MS Access
  3. HW #3: Simple query in SQL and MySQL
  4. HW #4: Constructing Entity Relationship Diagram (ERD) to capture the requirement of a database problem
  5. HW #5: Converting the ER model to relation schema
  6. HW #6: More advanced queries in SQL
  7. HW #7: Database development using embedded SQL programming in Python
  8. HW #8: Embedded SQL programming with Python
  9. HW #9: Data Visualization in Tableau
  10. HW #10: Database Administration in MySQL and SQL

CM_HW

Relationships with Applied Critical Thinking (ACT)

CM_EOT