The Sports Physical Therapy clinic uses supplies when conducting therapies on patients. The database administrator is creating

Question:

The Sports Physical Therapy clinic uses supplies when conducting therapies on patients. The database administrator is creating a table that lists all the possible supplies that the clinic orders. The design of this table is Supplies (SupplyID, Description, Price, SupplierID, SupplierName, SupplierAddress, SupplierPhone). Is this table designed correctly? If not, what normal form would correct it?

a. No; first normal form

b. No; second normal form

c. No; third normal form

d. Yes, it is correctly designed.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: