Data Dictionary:

Patient Table

Element	Definition	Type	Length	Default	Constraints
MR#	Unique identification number	Numeric	9	None	100000000-999999999
Lname	Individual's Last Name	Alpha	25	None	None
Fname	Individual's First Name	Alpha	20	None	None
Gender	Individual's gender	Alpha	1	None	"F" or "M"
Bdate	Individual's birth date	Date	8	None	None

Data retrieval request:

List all patients with the last name of "Johnson".

List all patients who are female.

List all patient last names and the medical record number of each.