01 Jun Relational Schema Paper

Posted at 16:59h in Essay Writing Services by Blogger

Question

Relational Schema Paper

Assignment #2

Guidelines with Scoring Rubric

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)

Due Date: Sunday 11:59 PM MT at the end of Week 5

Total Points Possible: 150

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

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

Directions and Assignment Criteria

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

Grading Rubric

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	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	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
Relations	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
Attributes	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
Keys	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	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
APA Format	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 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
References	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
Writing Mechanics	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

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 Ask A Question and we will direct you to our Order Page at WriteDemy. 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.

Do you need an answer to this or any other questions?

About Writedemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. 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.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Print page