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.

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.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