UML Basics - Sequence Diagrams
Lectures 23 • 40 slides
Narration
Lecture 23 Slide 1: Database Design and ER Diagrams
Lecture Overview
- Learn the basic concepts of database design
- How to create ER diagrams (Entity-Relationship Diagrams)
- Concepts and practice of normalization
mindmap
root((DB Design and ER Diagram))
ER Diagram Basics
Entity
Attribute
Relationship
Normalization
1st Normal Form
2nd Normal Form
3rd Normal Form
Index
What You Will Learn Today
- Basics of ER Diagrams and How to Create Them
- Normalization (1st to 3rd Normal Form)
- Types of Relationships
- Basics of Indexing Strategies
Review of Last Time
- Lecture 22 "Microservices and Monoliths"
- Architectural choices also affect database design
1/40