Project $2-$ Importing and Getting Data

CSC$2235$

Gregory Book, MS

Objectives

Become familiar with importing and selecting data from a database.

Background

Expanding upon Project $1,$ we will now attempt to input data into our database and get data out of the database. Getting data into the database uses the INSERT statement. Getting data out of the database uses the SELECT statement.

The Assignment

$1)$ There is a SQL file provided on Blackboard that contains $4$ tables for a research subject database. Import this file into your MariaDB database using HeidiSQL.

$2)$ Get the row counts of the imported tables

$3)$ Perform the following queries and get the row counts for each of them:

a$.$ Find all Male $($gender $=$ M$)$ subjects between the age of $25$ and $50(>=25$ and $<mtext></mtext><mn>5</mn><mn>0</mn><mi>)</mi>$

b$.$ Find all subjects with a name starting with $\text{'}$a$8\text{'}$

c$.$ Find all imaging series where the subject was female and aged $25$ to $50(>=25$ and For this query, you will need to calculate the "age at imaging scan" which will be the difference between their birth date and the series$\_$datetime

d$.$ Perform the query in part $($c$)$ and also find series$\_$desc that contains 'localizer'

e$.$ Find the number of subjects that have at least one imaging series that has more than $500$ files $($series$.$numfiles column$)$

What to submit

A document containing the following:

$1)$ The row counts for each of the four tables