Use the Sports database for this assignment. 1 Create a view named PATIENT_SMALL_BALANCE It consists of the patient number, last name, first name, and zip code for every patient that has a balance less than $1000.00 2. Create the command using the PATIENT_SMALL_BALANCE VIEW to retrieve the patient last name, zip code and balance where the zip code is in 72379, 72381 and 72512 3. Create view named THERAPIST_THERAPIES that returns Therapist ID, last name, first name, zip code, therapy code, and description of the therapy. You will need to join three tables, Therapist, Session and Therapies. 4. Create a query on that lists all the records from the THERAPIST_THERAPIES view where the Therapist ID is 'JR085' 5. Write but do not execute a command to give John permission to retrieve data from the Patient table. 6. Create a query that allows Sally and Mary the permission to add new Therapies to the Therapies Tables 7. Users John, Sally and Mary must be able to update the balance in the Patients table. Create a query that gives them permissions. 8. Create an Index on the Session Date field of the Sessions table 9. Create query to add a foreign key constraint to the PatientNum field in the Sessions Table 10. Create a query to add a check constraint to the UnitOfTime field in the Therapies table The UnitOfTime is between 0 and 35 Patient Num 1010 1011 1012 LastName FirstName Koehler Robbie King Joseph Houghland Susan ZipCode 72510 74081 72380 Balance 1535.15 212.8 1955.4 Falls Tierra 1013 72511 1000.35 1014 525 Odepaul Ben 74093 Address City State 119 West Bay Dr. San Vista TX 941 Treemont Oak Hills TX 7841 Lake Side Dr. Munster TX 44 Applewood Ave. Palm Rivers TX 546 WCR 150 South Munster TX 37 High School Road Waterville TX 2691 Westgrove St. Delbert TX 1928 10th Ave. Munster TX 300 Erin Dr. Waterville TX 4238 East 71st St. San Vista TX 919 Horton Ave. Georgetown TX 424 October Blvd. Waterville TX 432.3 Venable 1015 74183 Isaiah 1016 1017 1018 1019 1020 1021 Waggoner Short Baptist Culling Marino Wilson Brianna Tobey Joseph Latisha Andre Tammy 72381 72512 76658 74071 72379 76658 713.25 967.6 1846.75 1988.5 688.95 2015.3 Session Num 27 28 29 30 31 32 33 34 35 36 37 38 SessionDate 2018-10-10 2018-10-11 2018-10-11 2018-10-12 2018-10-15 2018-10-16 2018-10-17 2018-10-17 2018-10-18 2018-10-18 2018-10-19 2018-10-19 Patient Num 1011 1016 1014 1013 1016 1018 1017 1015 1010 1019 1020 1021 LengthOfSession Therapist TherapyCode 45 JR085 92507 30 AS648 97010 60 SW124 97014 30 BM273 97033 90 AS648 98960 15 JR085 97035 60 SN852 97039 45 BM273 97112 30 SW124 97113 75 SN852 97116 30 BM273 97124 60 AS648 97535 UnitOfTime 15 TherapyCode Description 90901 Biofeedback training by any modality 92240 Shoulder strapping 92507 Treatment of speech 92530 Knee strapping 92540 Ankle and/or foot strapping 95831 Extremity or trunk muscle testing 97010 Hot or cold pack application 97012 Mechanical traction 97014 Electrical stimulation 97016 Vasopneumatic devices N. 97018 Paraffin bath 97022 Whirlpool 97026 Infrared 97032 Electrical stimulation 97033 lontophoresis 97035 Ultrasound 97039 Unlisted modality 97110 Therapeutic exercises to develop strength and endurance range of motion, and flexibility 97112 Neuromuscular re-education of movement balance, coordination, etc. 97113 Aquatic therapy with therapeutic exercises 97116 Galt training 97124 Massage 97139 Unlisted therapeutic procedure 97140 Manual therapy techniques 97150 Group therapeutic procedure Dynamic activities to improve functional performance, direct (one-on-one) with the 97530 patient 97535 Self-care/home management training 97750 Physical performance test or measurement 97799 Unlisted physical medicine/rehabilitation service or procedure 98941 CMT of the spine 98960 Education and training for patient self-management 15 15 15 15 15 15 15 15 15 15 15 15 15 30 Therapistid LastName FirstName Street ZipCode AS648 BM273 Shields McClain Anthony Bridgette 5222 Eagle Court 385 West Mill St. City State Palm Rivers TX Waterville TX Palm Rivers TX Livewood TX 72511 76658 JR085 SN852 Risk Nair Jonathan Saritha 72511 72512 1010 650 North 25 North Elm St. 7354 Rockville Road SW124 Wilder Steven San Vista TX 72510