NR542 Relational Schema Paper Assignment #2
Relational Schema Paper
Having Trouble Meeting Your Deadline?
Get your assignment on NR542 Relational Schema Paper Assignment #2 completed on time. avoid delay and – ORDER NOW
Assignment #2
Guidelines with Scoring Rubric
This paper is intended to facilitate the database project through identification of the relational schema underlying the planned database.
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)
Due Date: Sunday 11:59 PM MT at the end of Week 5
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.
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
- 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 6th 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
|
Assignment Criteria |
Points |
% |
Description |
|
Introduction |
15 |
10 |
Introduction includes information about the topic and the organization of the paper |
|
Concept of Relational Tables |
20 |
13 |
Concept of relational tables is explained clearly and correctly |
|
Relations |
25 |
17 |
All planned relational tables are presented in correct relational-table format |
|
Attributes |
20 |
13 |
For each relational table, attributes are named, along with one data characteristic for each attribute. This can be in narrative form, individual tables, or vertical lists. |
|
Keys |
20 |
13 |
Primary key and any secondary keys for each table are identified. If secondary keys are used, a rationale is provided |
|
Conclusion |
20 |
13 |
Conclusion includes recap of content and insights from completing the assignment |
|
APA format |
10 |
7 |
Uses APA formats correctly in title page, body of the paper, citations, references, tables, and appendix |
|
References |
10 |
7 |
A minimum of two references are required. One of the course texts may be used as a reference. |
|
Writing Mechanics |
10 |
7 |
Fewer than two errors in spelling, grammar, punctuation, and syntax. Paper meets page requirements |
|
Total |
150 |
100 |
|
|
Assignment Criteria |
Exceptional (100%) Outstanding or highest level of performance |
Exceeds (88%) Very good or high level of performance |
Meets (80%) Competent or satisfactory level of performance |
Needs Improvement (38%) Poor or failing level of performance |
Developing (0) Unsatisfactory level of performance |
|
|
Content Possible Points = 150 Points |
|
|
|
|
|
|
|
Introduction
|
15 points |
13 points |
12 points |
6 points |
0 points |
|
|
Introduction includes detailed information about the topic and explains the organization of the paper
|
Introduction includes minimal information about the topic and explains the organization of the paper.
|
Introduction includes information about the topic OR the organization of the paper, but not both.
|
Introduction is present, but information about the topic and the organization of the paper is not included |
Introduction is not present. |
||
|
Concept of Relational Tables
|
20 Points |
18 Points |
16 Points |
7 Points |
0 Points |
|
|
Concept of relational tables is explained thoroughly, clearly, and accurately
|
Concept of relational tables is explained minimally, clearly, and accurately
|
Concept of relational tables is explained but is not clear OR is not accurate
|
Concept of relational tables is explained but is neither clear NOR accurate |
Concept of relational tables is not explained or discussed |
||
|
Relations
|
25 Points |
22 Points |
20 Points |
10 Points |
0 Points |
|
|
Relational tables are presented in correct relational-table format |
All but one relational table is presented in correct relational-table format. |
All but two relational tables are presented in correct relational table format. |
Relational tables are presented but no tables are in correct relational-table format. |
Relational tables not presented.
|
||
|
Attributes |
20 Points |
18 Points |
16 Points |
7 Points |
0 Points |
|
|
For each relational table, attributes are named, along with one data characteristic for each attribute.
This content can be in narrative form, individual tables, or in vertical lists |
For all but one relational table, attributes are named, along with one data characteristic for each.
This content can be in narrative form, as individual tables, or in vertical lists |
Attributes are named for some but not all tables
OR
A data characteristic is provided for some but not all named attributes |
Attributes are named for some but not all tables
AND
A data characteristic is provided for some but not all named attributes |
Attributes are not present in any table |
||
|
Keys |
20 Points |
18 Points |
16 Points |
7 Points |
0 Points |
|
|
Primary key and any secondary keys for each table are identified. If secondary keys are used, a rationale is provided |
Primary key and any secondary keys for all but one table are identified. If secondary keys are used, a rationale is provided |
For one table, a primary key is not identified OR A rationale for any secondary keys in any table is not provided |
For two tables, a primary key is not identified OR A rationale for any secondary keys in any table is not provided |
No primary keys are identified. |
||
|
Conclusion |
20 points |
18 points |
16 points |
7 points |
0 points |
|
|
Conclusion includes
|
Conclusion includes
|
Conclusion includes one of the following:
|
Conclusion includes neither of the following:
|
No conclusion is present |
||
|
Content |
|
_____ of 120 points |
||||
|
APA Format |
10 points |
9 points |
8 points |
4 points |
0 points |
|
|
|
|
OR
|
8 or more APA errors in title page, body of the paper, citations, references, tables, and/or appendices. |
||
|
References |
10 points |
9 points |
8 points |
4 points |
0 points |
|
|
More than two scholarly references were used. One of the course texts may be used as a reference. |
Two references were used. One reference may be a course text, |
Two references were used but only one scholarly reference was used. |
Two references were used, but one or more of the references were not applicable to the paper. |
No references were used. |
||
|
Writing Mechanics |
10 points |
9 points |
8 points |
4 points |
0 points |
|
|
There are no errors in spelling, grammar, punctuation, and syntax |
There are 1 – 2 errors in spelling, grammar, punctuation, and syntax |
There are 3-4 errors in spelling, grammar, punctuation, and syntax. |
There are 5 errors in spelling, grammar, punctuation, and syntax.. |
There are 6 or more errors in spelling, grammar, punctuation, and syntax. |
||
|
|
Format Subtotal |
_______ of 30 points |
||||
|
|
Total Points Possible = ______ of 150 points |
|||||
Explanation & Answer
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.