In each exercise, represent your answer in both DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram.

1. Design a database to produce the following reports. Do not use any surrogate keys in your design. 

a. For each therapist, list the therapist ID, last name, first name, street, city, state, and zip code. 

b. For each patient, list the patient number, last name, first name, address, city, state, zip code, and balance. 

c. For each therapist, list the sessions, the date, the length of session, therapist ID, and therapy code. 

2. Expand the database design you created in Exercise 1 so that it will also support the following situation: A specific therapist handles each therapy (a therapist can handle more than one). Along with all the details concerning sessions listed in Exercise 1, list the ID, last name, and first name of the therapist assigned to handle the request. 

3. Sports Physical Therapy has a list of approved vendors who supply things such as office supplies, therapy tools, towels, and wraps. Design a database to meet the following requirements: 

a. For each vendor, list the vendor ID number, vendor name, address, city, state, zip code, telephone number, and type of supply provided. 

b. For each supply, list the product number (UPC or SKU), product name, description, vendor ID number, quantity, and price. 

c. For each order, list the product number, product name, vendor ID number, quantity, total price, date ordered, and expected date of arrival

Transcribed Image Text:

Patient PatientNum LastName FirstName Address City State ZipCode Balance 1010 Koehler Robbie 119 West Bay Dr. San Vista TX 72510 $1,535.15 1011 941 Treemont King Houghland Joseph Susan Oak Hills TX 74081 $212.80 1012 7841 Lake Side Dr. Munster TX 72380 $1,955.40 1013 Falls Tierra 44 Applewood Ave. Palm Rivers TX 72511 $1,000.35 1014 Odepaul Ben 546 WCR 150 South Munster TX 74093 $525.00 Isaiah 74183 37 High School Road 2691 Westgrove St. 1015 Venable Waterville TX $432.30 1016 Waggoner Brianna Delbert TX 72381 $714.25 1017 Short Tobey 1928 10th Ave. Munster TX 72512 $967.60 Вaptist Culling 1018 Joseph 300 Erin Dr. Waterville TX 76658 $1,846.75 1019 Latisha 4238 East 71st St. San Vista TX 74071 $1,988.50 1020 Marino Andre 919 Horton Ave. Georgetown TX 72379 $688.95 1021 Wilson Tammy 424 October Blvd. Waterville TX 76658 $2,015.30 Patient PatientNum LastName FirstName Address City State ZipCode Balance 1010 Koehler Robbie 119 West Bay Dr. San Vista TX 72510 $1,535.15 1011 941 Treemont King Houghland Joseph Susan Oak Hills TX 74081 $212.80 1012 7841 Lake Side Dr. Munster TX 72380 $1,955.40 1013 Falls Tierra 44 Applewood Ave. Palm Rivers TX 72511 $1,000.35 1014 Odepaul Ben 546 WCR 150 South Munster TX 74093 $525.00 Isaiah 74183 37 High School Road 2691 Westgrove St. 1015 Venable Waterville TX $432.30 1016 Waggoner Brianna Delbert TX 72381 $714.25 1017 Short Tobey 1928 10th Ave. Munster TX 72512 $967.60 Вaptist Culling 1018 Joseph 300 Erin Dr. Waterville TX 76658 $1,846.75 1019 Latisha 4238 East 71st St. San Vista TX 74071 $1,988.50 1020 Marino Andre 919 Horton Ave. Georgetown TX 72379 $688.95 1021 Wilson Tammy 424 October Blvd. Waterville TX 76658 $2,015.30