R RStudio File Edit Code View Plots Session Build Debug Profile Tools Help chinook (3).rx 日 Source on Save 3 library(DBI) Go to file/function ▾ Addins ▾ Run Environment History Connections Tutorial Source Import Dataset 165 MIB ▼ R▾ Global Environment ▾ a Project: (None) List ▾ 4 library(RSQLite) 5 drv <- dbDriver ("SQLite") 6 7 con <- dbconnect (drv, dbname="chinook.db") ##be sure chinook.db is in the R workir dbListTables (con) Environment is empty 8 query
R RStudio File Edit Code View Plots Session Build Debug Profile Tools Help chinook (3).rx 日 Source on Save 3 library(DBI) Go to file/function ▾ Addins ▾ Run Environment History Connections Tutorial Source Import Dataset 165 MIB ▼ R▾ Global Environment ▾ a Project: (None) List ▾ 4 library(RSQLite) 5 drv <- dbDriver ("SQLite") 6 7 con <- dbconnect (drv, dbname="chinook.db") ##be sure chinook.db is in the R workir dbListTables (con) Environment is empty 8 query
Elementary Linear Algebra (MindTap Course List)
8th Edition
ISBN:9781305658004
Author:Ron Larson
Publisher:Ron Larson
Chapter4: Vector Spaces
Section4.CR: Review Exercises
Problem 82CR
Question
Please show me how this would look in the R studio, I can not get chinook.db to work. Download the chinook database. This is an example assignment to teach us and prepare us for the big test.
Place the “chinook.db” file in your R Studio working directory
library(DBI)
library(RSQLite)
drv <- dbDriver("SQLite")
con <- dbConnect(drv, dbname="chinook.db")
dbListTables(con) to test connection
You should be able to see this line in your console
"Album" "Artist" "Customer" "Employee" "Genre"
"Invoice" "InvoiceLine" "MediaType"
"Playlist" "PlaylistTrack" "Track"
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Elementary Linear Algebra (MindTap Course List)
Algebra
ISBN:
9781305658004
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Elementary Linear Algebra (MindTap Course List)
Algebra
ISBN:
9781305658004
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill