Week 8 Mar. 4-8, 2024 • Classify Total Specialization Rule and Partial Specialization rule • Identify Disjoint Rule and Overlap Rule • Know how to use Disjoint Rule, Overlap Rule, Disjoint Rule, and Overlap Rule when creating ERD. • Specifying Completeness Constraints ✓ Total Specialization Rule ✓ Partial Specialization Rule • Specifying Disjoint Constraints ✓ Disjoint Rule ✓ Overlap Rule Week 9 Mar.11-15, 2024 • Discuss Disjoint Subtype and Overlapping Subtype. • Illustrate the use of Disjoint Subtype and Overlapping Subtype. • Defining Subtype Discriminators ✓ Disjoint Subtype ✓ Overlapping Subtype • MIDTERM EXAM Week 10 Mar.18-22, 2024 • Define Data Structure, Data Manipulation, and Data Integrity. • Compare Primary Keys, Foreign Keys, and Composite Key. Construct Relational Tables using the appropriate Relational Keys The Relational Data Model • Basic Definitions ✓ Data Structure ✓ Data Manipulation ✓ Data Integrity • Relational Data Structure • Relational Keys ✓ Primary Key ✓ Foreign Key ✓ Composite Key • Properties of Relations Week 11 Mar.25-29,2024 • Differentiate Domain Constraints, Entity Integrity, and Referential Integrity. • Recall properties of a well-structured relations. Construct a well-structured relation. • Integrity Constraints ✓ Domain Constraints ✓ Entity Integrity ✓ Referential Integrity • Creating Relational Tables • Well-Structured Relations Week 12 Apr. 1-5, 2024 • Know how to transform EER Diagram into relations and • Illustrate how to transform EER Diagram into relations. • Transforming EER Diagrams into Relations Week 13 Apr.8-12, 2024 • Recall the definition and purpose of MySQL as a relational database management system. • Explain the role of MySQL in storing and managing structured data efficiently • Relate the benefits of using MySQL to data-driven decision-making in organizations. Demonstrate proper installation of MySQL. • Introduction to MySQL • MySQL Installation