N606 In Group Discussion 31
N606 In Group Discussion 31
Team Member Names (Telehealth): Delphine Munya, Esther Yankey, Blandine Sama, Melissa Haldeman, Maria Lazaro-Elemos, and Chelsie Tilton
1.) Describe the info needed to answer the question. 2.) List the data elements needed organized into two tables. 3.) Draw the relationships between the two tables using the notational symbols. 4.) Develop a data dictionary table.
1. Data Needed: Going to need to know the diagnoses of the patients seen in the E.D. within the past thirty days, the gender of the patients seen in the E.D. and amount of the time the patient stayed in the E.D along with the date of the visit. The patient clinic number will also need to be known, and the patient date of birth.
2. Data elements in two tables 3. Draw Relationship
E.D. Visit
*+Clinic Number
Diagnosis
Length of E.D. stay
Date of E.D. visit
Patient
*Clinic Number
Gender
Date of Birth
*Primary key
+Foreign key
4. Data Dictionary
| Field Name | Field Description | Source of Data | Table | Source of Data (How entered) | Field Type |
| MRN | Patient clinic number | EHR | Patient | Import | Numeric |
| Gender | Sex of the patient (Male, Female, Unidentified) | EHR | Patient | Import | Short text |
| Date of birth | Date of birth of the patient | EHR | Patient | Import | Numeric |
| MRN | Patient clinic number | EHR | E.D. Visit | Import | Numeric |
| Diagnosis | Medical diagnosis found upon E.D. visit | EHR | E.D. Visit | Import | Short text |
| Length of stay | Length of stay in the E.D. (hours) | EHR | E.D. Visit | Import | Numeric |
| Date | Date of E.D. visit | EHR | E.D. Visit | Import | Numeric |
ORDER CUSTOM, PLAGIARISM-FREE PAPER
The purpose of this assignment is for student to demonstrate knowledge and purpose of databases and to include database terms and data dictionary. This knowledge will promote students’ success in future graduate courses. No more than 5 pages in length (excludes cover page, references and any tables/charts).
Objectives:
1. Demonstrate how nursing problems may be answered through databases.
2. Exhibit knowledge of database terms.
3. Develop a data dictionary.
| Key Points of the Assignment: | Points |
| · Describe a nursing problem (2-3 paragraphs)
· Reference at least two peer reviewed journal articles noting the nursing problem. |
15 |
| · Describe what question is to be answered by the database. | 15 |
| · Describe in a narrative format the information needed to answer the question. | 15 |
| · List the data elements needed organized into at least 2 tables. | 15 |
| · Describe and explain why you have chosen the relationship between the tables. You also must draw the relationship between the tables using the notational symbols with lines joining the tables. | 5 |
| · Complete a data dictionary. Note the primary key, and as appropriate, foreign key for each table. Include the following categories in this dictionary. (25 points)
a. Field Name b. Field Description c. Source of Data d. Table e. Source of Data (How entered) f. Field Type |
25 |
| · APA format and writing style. | 10 |
| Total |