Database Implementation and Maintenance: A Comprehensive Report

This report details a comprehensive plan for database implementation and maintenance. It includes the selection of database development tools, such as software, and justification for the choices made. The report provides SQL statements to create a database, create and populate a table with primary and foreign keys, and query data. The report outlines security measures, testing strategies, and plans for future updates, including specific metrics for validating the database's effectiveness in meeting the original requirements. The report covers all the necessary elements, including an introduction, SQL queries, security and maintenance strategies, and a conclusion to ensure the database's integrity, performance, and long-term viability. The report provides detailed SQL statements, maintenance strategies, and security protocols for a robust and scalable database system.

Implementation and Maintenance Plan
Assignment Description
50 points
Present your strategy for implementing and maintaining the database you have designed.
This paper should be a 4 to 7 page MS Word document. It should be formatted using 1.5
line spacing and a 12-point font size. The margins of the paper should be 1 inch each.
Number the pages and add a project cover page and table of contents. [The required 4 to
7 page count does not include the cover page and table of contents.] Do not pad the paper
with extra page breaks, spacing, or verbiage from this assignment description. Criteria for
the paper’s technical content are provided in the following table.
At a minimum, this installment of the project documentation should
include the following content: Points*
An Implementation section with…
1. The software tool(s) you would use to develop the database and
why;
5
2. Evidence the document is within the scope of the original instructor-
provided topic.
5
3. An SQL section containing:
a. A basic SQL statement to create your database (5 pts);
b. A basic SQL statement to create one of your tables, including the
columns, primary and foreign keys, data type, length, null/not null
and, if applicable, default values. [Note: Select a table from your
design that consists of three or more columns.] (5 pts);
c. A basic SQL statement to display all data in the table you created in
step 3.b (above) and sorted by one of the columns (5 pts);
d. A basic SQL statement to display all data meeting a certain condition
in the table you created in step 3.b (above) (5 pts);
e. A single SQL statement that displays data from/across two of your
tables. [Note: Refer to your database design documentation.] (5 pts);
Present the information for this step in a two-column format. The first
column should be used to describe the action. The second column
should contain the complete SQL statement using the correct syntax.
25
A Maintenance section with…
4. Security measures you will put in place for the database; 5
5. Your strategy for testing, collecting feedback and making future
updates;
5
6. Your strategy for validating effectiveness at meeting the original
requirement(s). Identify specific metrics you will collect and analyze.
5
*Assignments submitted after the due date will only qualify for up to half of the point
value.

Implementation and Maintenance Plan
Assignment Description
50 points
Email the paper to the instructor when you are done. Include your name and the words
“Implementation and Maintenance Plan” in the email subject line.