Lesson: Introduction to Databases
Objectives
- Understand why we use databases?
- Understand what Tables, Rows, & Columns represent.
- Know what primary keys and foreign keys are.
- Know the difference between database relationship types.
- Practice drawing Entity Relationship Diagrams (ERD).
Lab: Entity Reference Diagrams
Objectives
- Draw entity relationship diagrams with crow's foot notation for ideas for Android apps
- Describe how tables relate to each other using foreign keys
- Explain the different relationship types – 1:1, 1:many, many:many