CSCI 5333 DBMS Course Contents in Concept Maps

by K. Yue

Syllabus in Concept Map

Relationships with Student Learning Objectives (SLO)

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

1. Clearly and precisely model problems using various conceptual design approaches with all elements of thought in critical thinking (such as purpose, questions, information and assumption) using a modeling language such as ER or UML Class diagrams.
2. Understand the precise concepts and issues associated with designing a relational database (e.g. normalization, good decomposition, foreign keys).
3. Comprehend various normal forms and their uses in logical inferences in database design.
4. Apply relevant query language concepts and techniques to accurately answer queries (question).
5. Understand physical database design concepts and issues (e.g. indexing).
6. Understand some of the important relevant issues (e.g. ACID, SQL transactions) in transaction processing, concurrency control, and database recovery.
7. Understand some of the advanced topics in databases, their purposes and relevance (e.g. XML).

Relationships with Homework Assignments

Focuses of Homework Assignments:

• HW #1: UML modeling using class diagram on a semi-realistic problem.
• HW #2: Conversion of an UML model to relational schema.
• HW #3: Relational Algebra queries using mathematical notations and a RA interpreter.
• HW #4: Relational Calculus
• HW #5: SQL queries
• HW #6: PHP-MySQL Web database development
• HW #7: SQL programming: views, stored subroutines and/or triggers
• HW #8: Relational DB design and normalization theory
• HW #9: XML, XPath and/or XQuery

Relationships with Applied Critical Thinking (ACT)

• Foundation of Critical Thinking (FCT): model of critical thinking, https://www.criticalthinking.org/ctmodel/logic-model1.htm
• Eight Elements of Thought (EoT, or Elements of Reasoning):
  1. Purpose
  2. Question at Issue/Problem
  3. Information 
     
  4. Interpretation and Inference/Solution
     
  5. Concepts
     
  6. Assumptions 
     
  7. Implications and Consequences
     
  8. Point of View