Module 02 Written Assignment - Database Architecture
1
Module 02 Written Assignment - Database Architecture
Courtnay Jones
Rasmussen College
M229/HIM2652 Healthcare Information Technologies – Online Plus – 2020 Winter Quarter
Term 2
Judy Johnson
February 26, 2020
Module 02 Written Assignment - Database Architecture
2
Database Architecture
Part One:
DATA ATTRIBUTE
DEFINITION
CHARACTERS
TYPE
OTHER
SPECIFICATIONS
First Name
Patient First
Name
30
Text
None
Last Name
Patient Last
Name
35
Text
Allow
hyphenated
apostrophe
Date of Birth
Patient Date of
birth
10
Date Field
2-digit month, 2-
digit day, 4-digit
year
(MMDDYYYY)
Address
Patient address
40
Text/Numeric
None
Phone no
Patient Phone
Number
10
Numeric
10 digits
Social Security
Number
Patient Social
Security
9
Numeric
No spaces, Allow
hyphenated
Occupation
Patient
Occupation
30
Text
None
Ethnicity
Patient Ethnicity
15
Text
None
Sex
Patient Sex
6
Text
None
Status
Patient Status
9
Text
None
Module 02 Written Assignment - Database Architecture
3
Part Two:
A Database is the assembly, storage, organization of data for easy access and recovery. Database’s
