[Solved] CIND119 Assignment 2-Querying an RDBMS database using SQLiteStudio

$25

File Name: CIND119_Assignment_2-Querying_an_RDBMS_database_using_SQLiteStudio.zip
File Size: 621.72 KB

SKU: [Solved] CIND119 Assignment 2-Querying an RDBMS database using SQLiteStudio Category: Tag:
5/5 - (1 vote)

Querying an RDBMS database using SQLiteStudio

Complete this assignment using SQLiteStudio.

  1. Create a database called sample.
  • Create a table called test_data and load the following data into the table. (5 points)
class age menopause tumor_size node_caps deg_malig breast breast_quad irradiat
NO 35 premeno 31 no 3 left left_low no
NO 42 premeno 22 no 2 right right_up no
NO 30 premeno 23 no 2 left left_low no
NO 61 ge40 16 no 2 right left_up no
NO 45 premeno 2 no 2 right right_low no
NO 64 ge40 17 no 2 left left_low no
NO 52 premeno 27 no 2 left left_low no
NO 67 ge40 21 no 1 left left_low no
YES 41 premeno 52 no 2 left left_low no
YES 43 premeno 22 no 2 right left_up no
YES 41 premeno 1 no 3 left central no
YES 44 ge40 27 no 2 left left_low no
YES 61 lt40 14 no 1 left right_up no
YES 55 ge40 26 no 3 left right_up no
YES 44 premeno 32 no 3 left left_up no
  1. Write SQL queries to select/compute data from the test_data table. (2 points each)
    1. Select all rows where menopause column has the value ge40.
    2. Select all rows where age is less than 41.
    3. Select all rows where age is less than 41 and menopause column has the value ge40.
    4. Compute the average age across all rows.
    5. Compute average age across rows where deg_malig value is equal to 3.

Reference: Full dataset available at GroupLens

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Shopping Cart
[Solved] CIND119 Assignment 2-Querying an RDBMS database using SQLiteStudio
$25