Solution guide for Guided Project: Designing and Creating a Database

Hi,

Is there a solution guide for the Intermediate SQL in R mission “Guided Project: Designing and Creating a Database”?

Also, I don’t think that DataQuest has provided enough information to actually accomplish this mission. For instance, I don’t recall learning how to create a new database in SQL (though I do know how to create a new table). Similarly, I don’t know how to use the dbExecute function (though I do know how to use dbFetch, dbGetQuery, dbSendQuery).

Please advise and indicate where the solution guide is. Thanks.

1 Like

Hello!

The intended solution guide for the “Guided Project: Designing and Creating a Database” project is located here. The original naming for the solution guide was initially unhelpful, and it has since been revised to better indicate that it belongs with the Designing and Creating a Database mission.

Thank you for your feedback on the mission! We’ll be sure to have a look at it and see where we might make some changes to better clarify this or teach the necessary functions. Have a great day!