Kim Wood

Database Prototype

Schema

Data Dictionary

Patient_Information

PatientID Patient’s Medical Record Number

FirstName Patient’s First Name

LastName Patient’s Last Name

DateOfBirth Patient’s Date of Birth

Gender Patient’s Gender

BMI

PatientID Patient’s Medical Record Number

HeightFeet_Inches Patient’s Height in Feet and Inches

WeightPounds Patient’s Weight in Pounds

BMIValue Patient’s Numeric BMI Value

BMICategory Patient’s Descriptive BMI Category

SQL Database Prototype

CREATE TABLE Patient_Information (PatientID char(6) not null, LastName varchar(64) not null, FirstName varchar(24) not null, DateOfBirth varchar(24) not null, Gender varchar (24) not null);

Queries

1. Patients with a BMI Value greater than 19.

SELECT BMI_VALUE

FROM BMI

WHERE BMI_VALUE >19;

Synopsis

Childhood obesity is a worldwide epidemic ….

BMI

PatientID

HeightFeet_Inches

WeightPounds

BMIValue

BMICategory

Parent_Information

PatientID

CaregiverType

MaritalStatus

Education

School_Information

PatientID

SchoolName

VendingOptions

Patient_Information

PatientID

FirstName

LastName

DateOfBirth

Gender

1 *

11

1

*