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

1. 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. 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
6. The primary key and any secondary keys for each table are identified. If secondary keys are used, a rationale is provided
7. The paper concludes with a recap of the content and insights gained from working on this assignment.

Criteria for Paper Format and Special Instructions:

1. All aspects of the paper are in APA format as expressed in the current edition, unless otherwise noted
2. Only scholarly literature is used to support decisions
3. The paper (excluding the title page, references, and appendix) is 2-3 pages in length
4. A minimum of two references are required. One of the course texts may be used as a reference.
5. Grammar, spelling, punctuation, and APA formats are consistent with formal academic writing.