80%(10)8 out of 10 people found this document helpful
This preview shows page 1 - 4 out of 4 pages.
Module 02 Written Assignment - Database ArchitectureThis assignment has been submitted on February 26, 2020 for M229/HIM2652 Section 01 HealthcareInformation Technologies - Online Plus - 2020 Winter Quarter Term 2
Module 02 Written Assignment - Database ArchitecturePart One:DATA ATTRIBUTEDEFINITIONCHARACTERSTYPEOTHER SPECIFICATIONFIRST NAMEPATIENT FIRST NAME30TEXTNONELAST NAMEPATIENT LAST NAME35TEXTALLOW HYPHENATED APOSTROPHEDATE OF BIRTH PATIENT DOB10DATE FIELD(MMDDYYYY)ADDRESSPATIENT ADDRESS40TEXT/NUMERICNONEPHONE #PATIENT PHONE #10NUMERIC10 DIGITSOCIAL SECURITY NUMBERPATIENT SS#9NUMERICNO SPACES, HYPENS ALLOWEDOCCUPATIONPATIENT JOB30TEXTNONEETHNICTY RACE15TEXTNONESEXPATIENT GENDER6TEXTNONESTATUSPATIENT STATUS9TEXTNONE
Module 02 Written Assignment - Database ArchitectureA database is a structured element on a computer that is constructed in the brains of the computer. It is comprised of data structures that are held and accessible in many various ways. In