In each exercise, represent your answer in both DBDL and with a diagram. You may use any
Question:
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
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last