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

Please Note: The database project will be developed in Microsoft Excel or Access.  Your three questions should be included on the diagram.

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.  Your three questions should be included on the diagram. 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.

Solution:

 Relational Schema

A relational database is valuable in organizing data points that have defined relationships for ease of access. In this view, this paper introduces the concept of relational tables, E-R diagrams, and a description of the key concepts in relational tables.

The Concept of Relational Tables

A relational table takes into consideration, table of columns or fields that define rows of data. A relation, also defined as a table, is a subset of the Cartesian product of a list of domains whose key feature is the name. Within each table, there is a row representing a group of related data and values (Oppel, 2009). A column with the table is known as an attribute. Therefore, an attribute is used to describe a record; hence a record can have a set of attributes. Ideally, a database comprises multiple dates, and each of the data has the data…….To access the solution  click the icon below to purchase at $10