Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone show me the actual steps on how to do this? Screenshots are preferred and it should be done in SQL server, Python3 I

image text in transcribed

Can someone show me the actual steps on how to do this? Screenshots are preferred and it should be done in SQL server, Python3

image text in transcribed

I have no idea

1) Set up a SQL database named 'mydb' in your jupyter notebook. 2) Create a table named 'students' that has the following fields/columns with the corresponding datatype: ID (INTEGER) and is the PRIMARY KEY Name (TEXT) Last_Name (TEXT) 3) Add the following data into your table. (Make sure you commit the changes after both creation of table and insertion of data) ID NAME LAST_NAME 1779 Alice Smith 1921 Bob Claire 1832 Carol Dee 4) Create another table in the database called 'enrolled which has the following fields: - ID (INTEGER) and is PRIMARY KEY - Enrolled (BOOLEAN) 5) Add the following data to the table: ID Enrolled 1779 True 1922 False 1921 True 1888 True 6) Use the LEFT JOIN and INNER JOIN command to get the names and last names of students along with their enrolment status. How do the results vary? 1) Set up a SQL database named 'mydb' in your jupyter notebook. 2) Create a table named 'students' that has the following fields/columns with the corresponding datatype: ID (INTEGER) and is the PRIMARY KEY Name (TEXT) Last_Name (TEXT) 3) Add the following data into your table. (Make sure you commit the changes after both creation of table and insertion of data) ID NAME LAST_NAME 1779 Alice Smith 1921 Bob Claire 1832 Carol Dee 4) Create another table in the database called 'enrolled which has the following fields: - ID (INTEGER) and is PRIMARY KEY - Enrolled (BOOLEAN) 5) Add the following data to the table: ID Enrolled 1779 True 1922 False 1921 True 1888 True 6) Use the LEFT JOIN and INNER JOIN command to get the names and last names of students along with their enrolment status. How do the results vary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transactions On Large Scale Data And Knowledge Centered Systems Xxviii Special Issue On Database And Expert Systems Applications Lncs 9940

Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Qimin Chen

1st Edition

3662534541, 978-3662534540

More Books

Students also viewed these Databases questions

Question

LO6 Summarize various ways to manage retention.

Answered: 1 week ago

Question

LO3 Define the difference between job satisfaction and engagement.

Answered: 1 week ago