CJones_ Module 02 Written Assignment - Database Architecture_02262020.docx - Module 02 Written Assignment Database Architecture 1 Module 02 Written

CJones_ Module 02 Written Assignment - Database Architecture_02262020.docx

This preview shows page 1 - 4 out of 5 pages.

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
Image of page 1
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
Image of page 2
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
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture