Verified Document

Team D. Agreed To Focus Research Paper

Foreign key fields (i.e. The key that represents the value of a primary key in a related table) may exist in the case of CLEBSI speciment: date of diagnosis, date and time of specimen (where latter may replicate). Under 'Patient', CLEBSI line is a foreign key, too.

V. Atomic-level data

Atomic data would be the most reducible element of information (without elaboration). So for instance for hand hygiene it would be Chlorhexidine Skin Antisepsis Antimicrobial Dressing Placement

VI. Schemas of the database will be:

Patient with the attributes of name, age, medical record number (MRN), diagnosis, central line; Central line with the attributes of medical record number, date of insertion, insertion site, date of removal, line days, inserting provider, the components Central Line Bundle compliance, antimicrobial dressing placement; and CLABSI infections with attributes of MRN, date of diagnosis, date and time of specimen, organism detected. Central Line Bundle compliance will be measured by the evidence-based standards determined by the Institute for Healthcare Improvement (IHI, n.d).

In short, the data will be organized in the following way:

Patient, Central Line, CLABSI Infection will be the field names. The primary key of the Patient table will be the MRN, of the Central Line Table - the Insertion site, and of CLABSI infection -MRN.

Their attributes will be the 'master keys' with the relevant information (i.e., the details) being the 'order' keys. These 'order' keys...

For presentation of these order keys see above under field types.
The entire assignment was somewhat complex, but once I had an idea of the requirements of CLABSI, and reformulated some of the information I was able to get past the roadblocks. One challenge, for instance, was determining the primary keys for Central Line and CLABSI since the central line by the former can by definition exist of more than one, and even more than one on the same day. I, therefore, transferred primary key to Insertion site. By CLABSI, I left MRN as primary key since we are focusing on the Primary Blood Stream Infection (BSI) and it is this that health-care institutions use to record presence of CLABSI (CDC, 2010)

Reference

CDC (2010) Central Line-Associated Bloodstream Infection (CLABSI) Event. Retrieved April 1, 2011 from www.cdc.gov/nhsn/PDFs/pscManual/4PSC_CLABScurrent.pdf

Databasics: A Database Dictionary. Retrieved April 1, 2011 from: http://www.geekgirls.com/database_dictionary.htm

Institute for Healthcare Improvement. (n.d.). Implement the central line bundle. Retrieved March 21, 2011, from http://www.ihi.org/IHI/Topics/CriticalCare/IntensiveCare/Changes/ImplementtheCentralLineBundle.htm

Moodle. Database Fields. Retrieved April 1, 2011 from http://docs.moodle.org/en/Database_fields#Field_name_and_description

Walkthrough: Creating a Master / Detail. Retrieved April 1, 2011 from http://msdn.microsoft.com/en-us/library/y8c0cxey.aspx

Sources used in this document:
Reference

CDC (2010) Central Line-Associated Bloodstream Infection (CLABSI) Event. Retrieved April 1, 2011 from www.cdc.gov/nhsn/PDFs/pscManual/4PSC_CLABScurrent.pdf

Databasics: A Database Dictionary. Retrieved April 1, 2011 from: http://www.geekgirls.com/database_dictionary.htm

Institute for Healthcare Improvement. (n.d.). Implement the central line bundle. Retrieved March 21, 2011, from http://www.ihi.org/IHI/Topics/CriticalCare/IntensiveCare/Changes/ImplementtheCentralLineBundle.htm

Moodle. Database Fields. Retrieved April 1, 2011 from http://docs.moodle.org/en/Database_fields#Field_name_and_description
Walkthrough: Creating a Master / Detail. Retrieved April 1, 2011 from http://msdn.microsoft.com/en-us/library/y8c0cxey.aspx
Cite this Document:
Copy Bibliography Citation

Related Documents

Teams to Undertake Many Operations
Words: 6596 Length: 20 Document Type: Term Paper

It is important to ensure that the team for any specific task comprises members who are knowledgeable and posses the required skills needed to carry out the task. Teams should also try to work across organizational boundaries/levels and break down internal barriers and deal with people and issues directly and avoid hidden agendas from both within the group and from external sources. Prior to selecting team members, the purpose and the

D.E.A. "Tell Me and I'll
Words: 1742 Length: 5 Document Type: Essay

These were followed by positive school climate, administrative support, collegial support and collegial friendships. At the bottom of the list were salary and benefits. Conversely, lack of administrative support, role conflict, and difficulty working with colleagues were the main causes of attrition. In order to provide high quality programs for children with disabilities, and ensure that they make good progress toward attaining their goals and meet increasingly rigorous academic standards,

Leadership Solutions Leadership Focuses on
Words: 1050 Length: 3 Document Type: Thesis

According to Murphy, such checklists provides teams with greater focus, a better ability to function as a team, and ultimately a smaller margin for error. The article makes good use of credible sources to bring across the point that checklists are in fact an essential part of effective solutions leadership. The fairly brief article by Shaun Parker, entitled "Is Project Management Software the Way Forward?" promotes the use of project

Growth Behind Online Dating Team
Words: 5133 Length: 20 Document Type: Research Proposal

It is obvious that public perceptions regarding such services have changed. This research must analyze the reasons that led to these changes. Online dating is wider accepted now than it was before. Something has determined this change, and this research must find out the elements that have influenced this situation. Another issues hat this research proposal must take into consideration refers to the types of online daters that are most frequent

Pfeiffer Industries President Smith Re: Optimizing Team
Words: 580 Length: 2 Document Type: Essay

Pfeiffer Industries President Smith Re: Optimizing Team Performance Creating teams has galvanized our employees together around common goals and led to greater level of achievement, yet there is much work still to be done. I agree with your assessment of team performance, and am writing to respond to the several questions and concerns you listed in your latest memo on this subject. I will also explain how I plan on fixing the situation

Team and Group Dynamics
Words: 1452 Length: 4 Document Type: Term Paper

Strengthening Others for Team Excellence For a team to be successful in their activities, they need a strong leader who will bring the team together by ensuring the team members trust each other and look forward to achieving the goal of the team. According to Northouse (2012), the team leader is important and should exhibit traits such as intelligence, confidence, integrity, and determination. Kouzes and Posner (2012) also suggest similar qualities

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now