Partido state university



Download 352.36 Kb.
View original pdf
Page3/5
Date15.02.2024
Size352.36 Kb.
#63523
1   2   3   4   5
inbound3768759909119050958
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

Download 352.36 Kb.

Share with your friends:
1   2   3   4   5




The database is protected by copyright ©ininet.org 2024
send message

    Main page