Strategy for Implementing and Maintaining a Database: Guidelines and Criteria
Added on -2019-09-19
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.
| 2 pages
| 535 words
| 354 views
Trusted by 2+ million users, 1000+ happy students everyday
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.
Found this document preview useful?
You are reading a preview Upload your documents to download or Become a Desklib member to get accesss