• Draw an Entity Relationship Diagram (ERD)
• Identify and diagram one-to-one, one-to-many and many-to-many relationships between data entities
• Distinguish between entities and attributes
• Discuss data normalization needs and techniques

Concepts

• Explain what a database is and why you would use one
• Explain how a DBMS, a database, and SQL relate to one another
• Describe a database schema and how it relates to tables, rows and columns

Mechanics

• Create a new PostgreSQL database
• Set up a PostgreSQL database schema with a saved SQL file
• Seed a PostgreSQL database with a saved SQL file
• Execute basic SQL commands to execute CRUD actions in a database

• Define what a foreign key is
• Describe how to represent a one-to-many relationship in SQL database
• Explain how to represent one-to-one and many-to-many relationships in a SQL DB
• Distinguish between keys, foreign keys, and indexes
• Describe the purpose of the JOIN
• Use JOIN to combine tables in a SELECT
• Describe what it means for a database to be normalized

This lesson is broken down into three parts...

1. Domain Modeling & ERDs
2. Basics of Databases, and SQL
3. Relationships in SQL

• What is an ERD and why would we use one?
• What is the distinctive feature of a relational database?
• How is information stored in a relational database?
• What are the different types of relations that exist in a relational database?
• How do we indicate a one-to-many relationship in a database?

• WDI7 (Matt Scilipoti): Part 1, Part 2
• ERDs WDI7 (Matt Scilipoti): https://youtu.be/IDnOMi9jHgo