omework Assignment #$3-$

Compose a data dictionary needed for a radiology department in a hospital that serves both inpatients and outpatients. Give a minimum of $10$ different field names.

A data dictionary is a table providing a comprehensive description of each field in the database. Data dictionaries $($are used$)$ to describe the characteristics of data including:

field name: the name of the field as it appears in the database.

data type: includes text, number, alphanumeric, date, currency, yes$/$no $($boolean$).$ In computer science, the Boolean data type is a data type, having two values $($i$.$e$.$ true and false; male and female; yes and no$)$

data format: any special formatting applied to the field; e$.$g$.$ number of decimal places in number fields, short, medium and long date and time formats.

field size: the number of characters allowed for a given field.

description: a simple description of field contents.

example: a typical field entry.

This assignment is due Sunday at $11$:$59$ pm

Sample data dictionary for employees of XXX Company $($yours will have different information given that you are designing for a radiology department$)$

Field Name Data Type Data Format Field Size Description Example

User ID Text NNNNNNNN $8$ Unique $8$ digit number represented as text $0001539$

First Name Text alpha $25$ Employee first name William

Last Name Text alpha $25$ Employee last name Smith

DOB Date mm$/$dd$/$yyyy $10$ Date of birth in a short date format $07/15/1982$

Hourly Wage Currency #####$.$## $8$ Rate of pay expressed in dollars per hour $34\mathrm{.}50$

Fees Paid Boolean $1$ Y or N for Yes or No Y

Hire Date Date mm$/$dd$/$yyyy $10$ Date employee hired $12/15/2015$

Rubric

HITT $110625$ Point Assignment Rubric $(2)$