NR542 Managing Data and Information Week 5 Project Relational Schema
NR542 Managing Data and Information Week 5 Project Relational Schema
Purpose
This paper is intended to facilitate the database project through identification of the relational schema underlying the planned database.
Course Outcomes
Through this assignment, the student will demonstrate the ability to:
(CO#4) Synthesize contributions of the data-information-knowledge-wisdom model and database principles and practices to the support of evidence-based practice (PO 11)
Requirements
In a 2-to-3-page paper, explain the concept of relational tables and submit all of the relational tables for the database. Provide at least one data characteristic for each attribute. Explain how the tables relate to each other. Name the primary key for each table. Confirm any secondary keys and explain why they are used.
Preparing the Assignment
Please Note: The database project will be developed in Microsoft Excel or Access. Your three questions should be included on the diagram.
Criteria for Content:
An introduction informs the reader about the topic of the paper and how the paper will be organized
The concept of relational tables is explained briefly
The complete Entity-Relationship diagram will be updated from the initial diagram included in your Week 3 assignment incorporating any changes that were necessary to address your three questions and from your relational table work in this Week 5 assignment. Your three questions should be included on the diagram. The updated diagram will include the necessary entities, attributes including primary and secondary keys, and cardinality rules (i.e. properly drawn lines and symbols). If possible, please indicate which entities and/or attributes will utilize standard nomenclature.
Relational tables, each with a unique name, are presented in standard relational-table format
For each relational table, attributes are named, along with one data characteristic for each attribute. This content can be presented in narrative form, as individual tables, or in vertical lists
The primary key and any secondary keys for each table are identified. If secondary keys are used, a rationale is provided
The paper concludes with a recap of the content and insights gained from working on this assignment.
Criteria for Paper Format and Special Instructions:
All aspects of the paper are in APA format as expressed in the current edition, unless otherwise noted
Only scholarly literature is used to support decisions
The paper (excluding the title page, references, and appendix) is 2-3 pages in length
A minimum of two references are required. One of the course texts may be used as a reference.
Grammar, spelling, punctuation, and APA formats are consistent with formal academic writing.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.