Project $1-$ MyFirstDatabase

CSC$2235$

Gregory Book, MS

Objectives

Become familiar with table columns, rows, and relations and create your first database.

Background

We love relational databases.

After you complete your college degree and enter the workforce, you will notice that your programming skills are only part of what you use at your job. The other piece of your job is understanding whatever your job requires you to understand. If you work in insurance, you need to become an expert in insurance. If you work in retail, the military, manufacturing, or medicine, you will need to become an expert in those fields.

For every organization you work for, you will need to understand what they do so that you can apply your skills as a programmer to help your employer. This often means learning something you know nothing about and becoming an expert enough in the topic to automate a process or create a program.

For this assignment you will learn all about medical imaging. Every time a patient has an xray, MRI, CT$,$ or ultrasound, the imaging equipment will generate images that are sent to a central database known as a PACS. This system stores and allows retrieval of images.

Every patient can have any number of imaging studies. Each time a patient goes into a piece of equipment, and comes out, the data collected during that time is a study. While the patient is in the equipment, they can receive multiple scans known as series. Those series contain a set of images.

Data relationships

$$ Every patient can have any number of studies

$$ Every study can have any number of series Subject data fields

$$ PatientID

$1$

$$ Name $$ DOB

Study data fields $$ Datetime

Series data fields

$$ NumberOfImages

The Assignment

Your assignment is to create a medical imaging database. Create tables in a MariaDB database using the HeidiSQL. Make sure each table has a primary key $($such as a subject$\_$id field...$)$ and indicate any foreign keys. For example, your studies table will need a foreign key for the subject$\_$id$.$

What to submit

The SQL code to create the table$($s$).$