Answered: 2. Expand the database design you…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Expand the database design you created in exercise1 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 exercise1, list the ID, last name, and first name of the therapist assigned to handle the request.

Proofing
Speech
Accessibility
Changes
Compare
2. Expand the database design you created in Exercise1 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 Exercise1, list the ID, last name, and first name of the
therapist assigned to handle the request.
CRITICAL THINKING
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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions