Checks for understanding of Turing Mod2 week 3 lesson.

Models, Databases, and Relationships.md

1. What is a primary key?

• The unique identifier for each row in a table.

2. What is a foreign key?

• A reference in one table to the primary key in another table that it shares a relationship with.

3. Why would one row of data have both primary and foreign keys?

• When a relationship exists between the tables that requires one table to track a row in another.

4. What is Rails' convention for the column name of the primary key?

• id

5. What is Rails' convention for the column name of a foreign key?

• tablename_id

6. What are dev, test, and prod databases all about?

• For development, testing, and production, respectively. They allow you to separate code from test, development, and production environments.

7. What is the database.yml and how is it used?

• Stores details about the database configuration and environment locations for those databases