Module 5 Sports

docx

School

St. Petersburg College *

*We aren’t endorsed by this school

Course

3212

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by CoachAntelope4685

Jeffrey Diaz 2/08/2024 ISM 3212 Professor Dugan Module 5 Sports Physical Therapy Case Critical Thinking 1. When the Sports Physical Therapy database was created, the database designers identified PatientNum and PatientSocialSecurityNumber as candidate keys for the Patient table. Why was PatientSocialSecurityNumber not chosen to be the key field of that table? a. The social security number was not chosen to be the key field because not every person might have a social security number. That would cause the primary key field to be Null for some patients. 2. What is the notation for each table in the Sports Physical Therapy database? a. P (PNum, LName, Add, Cy, St, ZCode, Bal) b. S (SNum, SDate, PNum, LenOfSes, TtlD, TyCode) c. Tt (TtlD, LName, FName, Str, City, St, ZCode) d. Ts (TyCode, Desc, UOT)

Discover more documents: Sign up today!

Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Module 5 Sports

Related Documents