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
- 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.
- Understand the precise concepts and issues associated with designing a relational database (e.g. normalization, good decomposition, foreign keys).
- Comprehend various normal forms and their uses in logical inferences in database design.
- Apply relevant query language concepts and techniques to accurately answer queries (question).
- Understand physical database design concepts and issues (e.g. indexing).
- Understand some of the important relevant issues (e.g. ACID, SQL transactions) in transaction processing, concurrency control, and database recovery.
- 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):
- Purpose
- Question at Issue/Problem
- Information
- Interpretation and Inference/Solution
- Concepts
- Assumptions
- Implications and Consequences
- Point of View