search

ga-wdi-boston / sql-references-diagnostic

Diagnostic covering foreign keys and join tables in PostgreSQL
Other
1 stars 164 forks source link

update instructions to specify usage of SELECT in conjunction with INSERT #155

Open neugierige opened 8 years ago

neugierige commented 8 years ago

For WDI015, many developers submitted responses whereby they are inserting id values into the tables, and bypassing the SELECT method entirely. This should not be allowable, even though the solution produces the appropriate result. Currently, the instructions do not specify that this is NOT what they are supposed to do. For example for question 3:

Create the following appointments by inserting the appropriate rows into the appointments table.

I propose that we update the language to the following:

Create the following appointments by selecting the appropriate objects, and inserting the appropriate data into the columns of the appointments table.

Jcornmanhomonoff commented 7 years ago

@gaand do you have any thoughts on this? I reviewed the above comment and it seems pretty self explanatory that one should use INSERT. Open to feedback.