logo

Strategy for Implementing and Maintaining a Database: Guidelines and Criteria

2 Pages535 Words354 Views
   

Added on  2019-09-19

About This Document

This paper provides guidelines and criteria for implementing and maintaining a database, including software tools, SQL statements, security measures, testing and feedback strategies, and metrics for validating effectiveness. It includes an Implementation section with SQL statements for creating and displaying data in tables, and a Maintenance section with strategies for security, testing, and validation.

Strategy for Implementing and Maintaining a Database: Guidelines and Criteria

   Added on 2019-09-19

ShareRelated Documents
Implementation and Maintenance PlanAssignment Description50 pointsPresent 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 paperwith 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;52.Evidence the document is within the scope of the original instructor-provided topic.53.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 conditionin 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.25A Maintenance section with...4.Security measures you will put in place for the database;55.Your strategy for testing, collecting feedback and making future updates;56.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.
Strategy for Implementing and Maintaining a Database: Guidelines and Criteria_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
2012 Basketball Scoring Analysis
|5
|1590
|81

SQL Final Exam
|3
|777
|265

SQL: DDL Create and Alter, DCL Grant and Revoke, Data Manipulation, Database Testing
|13
|2239
|63

Home Inventory Database: Software Tool Description, SQL Section, Security Measures, Testing and Validation Strategies
|7
|800
|134

Instructions for Submission 4 - SQL.
|3
|553
|270

Create a Web Site with Masterpage, Navigation, Contact Page, jQuery and Database Connectivity
|2
|546
|250