NR542 2021 January Week 5 Assignment Latest

NR542 Managing Data and Information

Week 5 Assignment

Relational Schema Paper

PURPOSE

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

REQUIREMENTS

In a2-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:

1.            An introduction informs the reader about the topic of the paper and how the paper will be organized

2.            The concept of relational tables is explained briefly

3.            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. 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.

4.            Relational tables, each with a unique name, are presented in standard relational-table format

5.            Foreachrelationaltable,attributesarenamed, along with one datacharacteristicfor each attribute. Thiscontent can be presentedin narrative form, as individual tables,or in vertical lists

6.            Theprimarykeyand anysecondarykeysforeachtable areidentified. Ifsecondarykeysare used,arationale isprovided

7.            Thepaper concludeswith a recap of the content and insightsgainedfromworking onthisassignment.

Criteria for Paper Format and Special Instructions:

1.            All aspectsof the paper areinAPAformatasexpressed inthecurrent edition,unless otherwise noted

2.            Only scholarlyliterature isusedtosupportdecisions

3.            Thepaper (excluding thetitle page, references,and appendix)is 2-3 pagesin length

4.            A minimumof two referencesarerequired. Oneof the coursetextsmaybe used asa reference.

5.            Grammar, spelling,punctuation, andAPA formatsareconsistentwithformal academic writing