NURS 6411:Week 5: Fundamentals of Relational Databases in Microsoft Access Part 1 Essay Assignment Paper

We have advanced nursing paper writers to help on NURS 6411:Week 5: Fundamentals of Relational Databases in Microsoft Access Part 1 Essay Assignment Paper

NURS 6411:Week 5: Fundamentals of Relational Databases in Microsoft Access Part 1 Essay Assignment Paper

NURS 6411: Information and Knowledge Management | Week 5

Throughout this course, you have been exploring how databases are used in health care organizations to store, organize, and navigate large quantities of patient data and information. Before you can develop those databases, however, you need to have a firm grasp of key principles and terminology. This will ensure that you can create a database that will save and retrieve information in the most efficient manner. Microsoft Access is a database application that can be used to simplify the process. It is, therefore, an important and powerful tool for nurse informaticists to have in their toolkit. In order to use it effectively, however, you must understand the structure of a database.

This week, you review some of the key concepts involved in creating a database. In particular, the focus is on examining exactly what is meant by the term relational database. You also gain hands-on experience using Access. You begin working with features in Access including tables and queries.

Learning Objectives

Students will:

• Analyze the relationship between relational and entity relational databases
• Develop a conceptual model for a database

Learning Resources

Required Readings

Coronel, C. & Morris, S. (2017). Database systems: Design, implementation, and management (12th ed.). Boston, MA: Cengage Learning.

• Chapter 3, “The Relational Database Model” (review) (pp. 71-106)
• Chapter 4, “The Entity Relationship Model (ERM)” (review) (pp. 117-152)

Cox, J. & Lambert, J. (2013). Step by step: Microsoft Access 2013. Richland, WA: Microsoft Press.

• Chapter 2, “Creating Databases and Simple Tables” (pp. 53–90)>In this chapter, the authors demonstrate how to create databases both from templates and manually, how to construct a table structure, and how to define the relationship between tables.
• Chapter 3, “Create Simple Forms” (pp. 91–114)The focus of this chapter is creating forms, which enables standardized data to be entered into a database. The authors demonstrate how to create, format and customize the layout of forms.
• Chapter 4, “Display Data” (pp. 115–134)This chapter concentrates on sorting and filtering information within a database in order to locate and display desired information. It begins with simple sorts and progresses through displaying information that matches specific, multiple criteria.

Optional Resources

There are a wide variety of online tutorials available to assist with using Microsoft Access. Below are several you might consider, as needed:

Goodwill Community Foundation, Inc. (2010). Access 2010. Retrieved from http://www.gcflearnfree.org/office

 

This free resource provides a series of lessons, interactives, and video tutorials to assist in learning how to use Access 2010.

Pollock, A. (2010). Access 2010 essential training. Retrieved from http://www.lynda.com/Access-2010-tutorials/essential-training/62642-2.html

 

This series of videos provides detailed instruction on all aspects of Microsoft Access 2010 use. This resource requires a paid subscription.

Discussion: Core Database Principles

When embarking on any new project or learning experience, it is essential that you have a strong foundation of understanding constructed from key concepts and parameters. As you begin your work with databases and database design, you should develop a firm understanding of key concepts and parameters that are critical to the foundation of all database design.

In this Discussion, you examine these key fundamental principles of database design.

To prepare:

• Review the information in this week’s Learning Resources concerning relational and entity relational databases. Focus on how the two are interconnected.
• Review information concerning cardinalities and consider what they are, how they are developed, and their role in database design.
• Review information concerning business rules, what they represent, and how they are reflected in the entity relationship diagrams.
• Review the conceptual model (Figure Q4.5) on page 150 of your text, Database Systems: Design, Implementation, and Management  Think of a similar example of how each of these concepts would be reflected in a database design for your own organization.

By Day 3

Post a brief analysis of the connection between entity relational modeling and relational databases. Discuss a brief example of a conceptual model that could be used in your own organization and list at least one business rule and two cardinalities that apply to that model.

Read a selection of your colleagues’ responses.

By Day 6

Respond to at least two of your colleagues on two different days. Help clarify their explanations of key concepts. For the conceptual model they provided, suggest an additional cardinality that would apply and why it would be necessary to use it.

The time to relieve your academic stress is now. Never again should you struggle with your pressing nursing assignments when Advanced Nursing Writers writers got you covered. Our Advanced Nursing Writers writing service got your back!

If you need help with your nursing paper, We are your ultimate nursing assignment writing helper. Our professional nursing writers are always ready to tackle even the hardest of nursing papers. Get in touch. Order today and Always.
Best site that aces nursing papers and the best place to get nursing papers done.

Our professional writers are well experienced in writing nursing papers and are thereby able to tackle any topic around Nursing, Biochemistry, Biology, Chemistry, Pedagogy, Gynecological, Medicine & Health, Healthcare, Nutrition, or Pharmacology.

We guarantee customer satisfaction to all our clients.

Let our professional nursing essay writers be there for you. Our Advanced Nursing Writers writing service comprises 100% Plagiarism-Free Papers, On-Time Delivery, 24/7 Support, and Full Confidentiality.

We have advanced nursing paper writers to help on NURS 6411:Week 5: Fundamentals of Relational Databases in Microsoft Access Part 1 Essay Assignment Paper

Factors that make us special:

• We handle assignments for all nursing courses. So, don’t worry about the topic of the essay you want, we are ready to help you with your assignment regardless of the course or topic.
• Our writers read, understand, and follow one by one, the instructions provided to deliver the most accurate essays. We offer the correct form and style of essays.
• You can be sure the paper will have proper references based on the type of citation style you choose.
• You can always work with the same writer you liked. You can include the writer’s ID in the order form and we will ensure your expectations are met. We have writers who are experienced in all areas of study.
• Affordable services. Relax! we are not expensive, by the way, our prices are fair for the writers, but affordable to you as a customer. We will offer you a discount to try our services. Become part of our loyalty discount program by coming back for more and more services.
• We have a very flexible pricing system. The good news is that we let you choose from five quality levels, from High School to Ph.D. We also let you choose from different deadlines, from 5/6 hours to 20 days