Thinkful-Ed / node-sql-sequelize-lessons

Extension work on SQL and Sequelize for Thinkful's Node course
https://courses.thinkful.com/node-sql-001v1/unit/1
1 stars 4 forks source link

1.1.4 - code should say 9 instead of 10 #24

Open thinkfulCurricula opened 6 years ago

thinkfulCurricula commented 6 years ago

Robert Frazier (robert.v.frazier@gmail.com) reported an issue.

Name: "Joins, related data, and constraints" assignment Live URL: https://courses.thinkful.com/node-sql-001v1/assignment/1.1.4

Content:

"Now run the following commands:

SELECT FROM grades WHERE id = 15; -- it has restaurant_id of 10 DELETE FROM restaurants WHERE id = 10; SELECT FROM grades WHERE id = 15; -- restaurant_id is null"

Should be:

"Now run the following commands:

SELECT FROM grades WHERE id = 15; -- it has restaurant_id of 9 DELETE FROM restaurants WHERE id = 9; SELECT FROM grades WHERE id = 15; -- restaurant_id is null"

Front logo Front conversations

alfaraday commented 6 years ago

Jacob Zimmerman (jacobzimmerman80@gmail.com) reported an issue.

Name: "Joins, related data, and constraints" assignment Live URL: https://courses.thinkful.com/node-sql-001v1/assignment/1.1.4 Course code: NODE-SQL-001 UUID: 81c2d7a0-e895-11e6-a3eb-03934004d1da Repo: https://github.com/Thinkful-Ed/node-sql-sequelize-lessons

Content:

(bottom of Many to one section)The index of the id will go down 1 if we delete a row as instructed previously. Therefore the code should be updated to delete the restaurant with id 9 instead of 10.