Assignment $3$

Why are we doing this?

A database is a repository for data. It allows data to be organized in a way to allow easy access

and manipulation of the data it contains. Traditionally, databases are stored as files, which

contain tables. Tables are composed of records $($rows$)$ that contain various columns$/$fields$.$

For this assignment you will use NJIT$$s MySQL server, which is an open$-$source relational

database management system. SQL $($Structured Query Language$)$ is a language that allows for

the manipulation of data stored within relational databases. This assignment will help you

understand how to create and manipulate databases.

Bootstrap MAY NOT be used for any projects in this course

The Assignment

Using phpMyAdmin you will create database tables that contain

$$ Occupational Therapist$$s records $(10$ unique and valid receptionist records$)$

$$ Client$$s records $($each therapist should have at least one client and clients can have a

records with more than one therapist$).$

$$ Client$$s Personal Information Record $($each patient needs one record$).$

$$ Client$$s Treatment Plan records $($each patient needs at least one record$).$

$$ Client$$s schedule records $($each patient needs at least one record$).$

The records in each of these tables must contain valid and unique data. Points will be

deducted if data is not valid and unique.

Your database tables should also be normalized. The process of normalization can be found in

Week Eight$$s Supplemental Reading, Recap and PPT slides.

Your column$/$field names should be meaningful.

I strongly suggest $($especially for those that are new MySQL that when creating your tables

and columns$/$fields $($in your tables$)$ that you create tables and columns$/$field names that have

no spaces. This alleviates the need for $``($tick marks$)$ around table and column$/$field names

when creating SQL commands. I have found in the past the need for $``($tick marks$)$ has

caused many issues for those new to SQL regarding SQL syntax and thus causing errors.

For example: calling a column$/$field FirstName rather than First Name is preferable.

Assignment $3$

Why are we doing this?

A database is a repository for data. It allows data to be organized in a way to allow easy access

and manipulation of the data it contains. Traditionally, databases are stored as files, which

For this assignment Tables are composed of records $($rows$)$ that contain various columns$/$fields$.$

database management system. SQL $($Structured Query Language$)$ is a language that allows for

the manipulation of data stored within relational databases. This assignment will help you

the manipulation of data stored within relational dat understand how to create and manipulate databases.

Bootstrap MAY NOT be used for any projects in this course

The Assignment

Using phpMyAdmin you will create database tables that contain

Occupational Therapist's records $(10$ unique and valid receptionist records$)$

Client's records $($each therapist should have at least one client and clients can have a

records with more than one therapist$).$

Client's Personal Information Record $($each patient needs one record.

Client's Treatment Plan records $($each patient needs at least one record$)$

Client's schedule records $($each patient needs at least one record$)$

The records in each of these tables must contain valid and unique data. Points will be

deducted if data is not valid and unique.

Your database tables should also be normalized. The process of normalization can be found i

Week Eight's Supplemental Reading, Recap and PPT slides.

Your column$/$field names should be meaningful.

I strongly suggest $($especially for those that are new MySQL that when creating your tables

and columns$/$fields $($in your tables$)$ that you create tables and columns$/$field names that have

when creating SQL commands. I have found in the past the need for $"\text{'}($tick marks$)$ has

caused many issues for those new to SQL regarding SQL syntax and thus causing errors.

For example: calling a column$/$field FirstName rather than First Name is preferable.

Your records will have the following columns$/$fields associated with a Therapist :

Therapist First Name

Therapist Last Name

Therapist Password

Therapist ID Number

Therapist Phone Number

nt Last Name

Client ID

You will also need the Client's Personal Information.

Client Address

Client Phone Numbe

Client Date of Birth

You will also need information about the Client's Treatment Plan.

Your records will have the following columns$/$fields

Injury type

Script for occupational therapy sessions

Devices$/$Supplies that are needed for treatment

Finally, you will need a table for the Client's Sessions.

Your records will have the following columns$/$fields:

Appointment Dates

The fields listed for each table are the basic fields needed, but remember you are normalizing

your tables so you will need fields in your table that will serve as keys.

Once the tables are created you are to design a form $($how the form looks is up to you, but it

must include a HOME button, the buttons should change color when hovered over and a

backgro