Widener MIS358 2025 lecture2
Brian Finnegan
Widener MIS358 2025 lecture2
2:27:06
HW5Q7 Bonus Solution
Brian Finnegan
HW5Q7 Bonus Solution
15:54
Inner vs. Outer Joins in SQL
Brian Finnegan
Inner vs. Outer Joins in SQL
9:20
SQL Three Table Join Examples
Brian Finnegan
SQL Three Table Join Examples
14:13
EER to Relational Translation Techniques
Brian Finnegan
EER to Relational Translation Techniques
14:46
SQL WHERE versus HAVING Example
Brian Finnegan
SQL WHERE versus HAVING Example
11:45
Informal, ERD-centric Introduction to the Fifth Normal Form (5NF)
Brian Finnegan
Informal, ERD-centric Introduction to the Fifth Normal Form (5NF)
12:55
Fourth Normal Form vs ER Modeling
Brian Finnegan
Fourth Normal Form vs ER Modeling
5:37
Normalization: The First Normal Form
Brian Finnegan
Normalization: The First Normal Form
12:04
Referential Integrity in the Relational Model
Brian Finnegan
Referential Integrity in the Relational Model
7:37
Enhanced Entity-Relationship Model Part 2: Generalization vs. Specialization and EER Constraints
Brian Finnegan
Enhanced Entity-Relationship Model Part 2: Generalization vs. Specialization and EER Constraints
16:32
Update Anomalies
Brian Finnegan
Update Anomalies
12:46
Normalization and the Third Normal Form
Brian Finnegan
Normalization and the Third Normal Form
9:07
RDBMS Normalization: Introduction to Second Normal Form
Brian Finnegan
RDBMS Normalization: Introduction to Second Normal Form
12:13
Introducing Functional Dependencies in Relational Design
Brian Finnegan
Introducing Functional Dependencies in Relational Design
13:09
When to Index an RDBMS
Brian Finnegan
When to Index an RDBMS
10:58
DBMS Indexing: The Basic Concept
Brian Finnegan
DBMS Indexing: The Basic Concept
9:52
Introducing Aggregation in SQL
Brian Finnegan
Introducing Aggregation in SQL
9:46
Introduction to Nested Select Statements
Brian Finnegan
Introduction to Nested Select Statements
9:02
Translation Part 1
Brian Finnegan
Translation Part 1
8:04
Translation Part 3A - Mapped Translation Introduction
Brian Finnegan
Translation Part 3A - Mapped Translation Introduction
8:52
Translation Part 2
Brian Finnegan
Translation Part 2
8:49
Competing ERD Standards
Brian Finnegan
Competing ERD Standards
9:18
Weak Entity Modeling
Brian Finnegan
Weak Entity Modeling
13:02
Ternary Relationships
Brian Finnegan
Ternary Relationships
11:26
Translation Part 6 - Multi-Relationship, ERD-wide Translation Example
Brian Finnegan
Translation Part 6 - Multi-Relationship, ERD-wide Translation Example
7:47
Intro to Joins
Brian Finnegan
Intro to Joins
13:08
Unary or Recursive Relationships in ERDs
Brian Finnegan
Unary or Recursive Relationships in ERDs
6:16
The Participation Constraint in the ER Diagram
Brian Finnegan
The Participation Constraint in the ER Diagram
9:00
Translation Part 3B - Mapped Translation Applied
Brian Finnegan
Translation Part 3B - Mapped Translation Applied
6:25
Translation Part 5 - Stable Translation
Brian Finnegan
Translation Part 5 - Stable Translation
5:36
Additional Join Syntax Options
Brian Finnegan
Additional Join Syntax Options
9:21
Translation Part 4 - Mapped Translation w- Particpation (total-partial) Consideration
Brian Finnegan
Translation Part 4 - Mapped Translation w- Particpation (total-partial) Consideration
14:00
Collision Detection in Alice Intro
Brian Finnegan
Collision Detection in Alice Intro
5:22
Managing Camera Angles in Alice with Dummy Objects
Brian Finnegan
Managing Camera Angles in Alice with Dummy Objects
4:14