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 Patient Num 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 Koehler King Houghland FirstName Robbie Joseph Susan City San Vista Oak Hills Munster State TX TX TX ZipCode 72510 74081 72380 Balance 1535.15 212.8 1955.4 1013 Falls Tierra Palm Rivers TX 72511 1000.35 1014 Odepaul Ben Munster TX 74093 525 Address 119 West Bay Dr. 941 Treemont 7841 Lake Side Dr. 44 Applewood Ave. 546 WCR 150 South 37 High School Road 2691 Westgrove St. 1928 10th Ave. 300 Erin Dr. 4238 East 71st St. 919 Horton Ave. 424 October Blvd. 1015 Venable Isaiah Waterville TX 74183 432.3 TX 1016 1017 1018 1019 1020 1021 Waggoner Short Baptist Culling Marino Wilson Brianna Tobey Joseph Latisha Andre Tammy Delbert TX Munster Waterville TX San Vista TX Georgetown TX Waterville TX 72381 72512 76658 74071 72379 76658 714.25 967.6 1846.75 1988.5 688.95 2015.3 Session Num 27 28 29 30 31 32 33 34 Session Date 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 Length OfSession TherapistID 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 35 36 37 38 UnitOfTime 15 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 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 Gait 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 15 15 15 15 15 15 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