NR542 Assignment 2: Relational Schema Paper

NR542 Assignment 2: Relational Schema Paper

NR542 Assignment 2: Relational Schema Paper

This paper is intended to facilitate the database project through identification of the relational schema underlying the planned database.

(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)

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.

KINDLY ORDER NOW FOR A CUSTOM-WRITTEN, PLAGIARISM-FREE PAPER

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

Thorough recap of the paper
Detailed insights from completing the assignment

Conclusion includes

Simple recap of the paper
Insights – without detail – from completing the assignment

Conclusion includes one of the following:

Recap of the paper
Insights from completing the assignment

Conclusion includes neither of the following:

Recap of the paper
Insights from completing the assignment.

No conclusion is present

Content

_____ of 120 points

APA Format

10 points

9 points

8 points

4 points

0 points

1 – 2 errors in title page, body of the paper, citations, references, tables, and/or appendices.
Page specifications are met.

3 – 5 APA errors in title page, body of the paper, citations, references, table, and appendix.
Page specifications are met

6 APA errors in title page, body of the paper, citations, references, tables, and/or appendices.
Page specifications are met

7 APA errors in title page, body of the paper, citations, references, tables, and/or appendices

OR

KINDLY ORDER NOW FOR A CUSTOM-WRITTEN, PLAGIARISM-FREE PAPER

Page specifications are not met.

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