Assistance with a Maria DB form

Assessment Instructions

Overview

In this assessment you install MariaDB, import data, run a query, and answer questions on relational vs. non-relational databases.

Preparation

Complete the following preparatory steps for this assessment:

· Download the  Database Assessment Template [DOCX]  and use it to submit this assessment.

· Download and unzip the  restaurant_review_sql_dump.txt.zip  file for use with the database.

Instructions

Part 1 - Installing, Importing Data and Running a Query on MariaDB

Follow one of these OS dependent directions found in the Resources to complete Part 1 of this assessment:

· Directions for Downloading, Installing, Importing Data, and Running a Query in MariaDB [DOCX] .

Step 1 – Install MariaDB.

Step 2 – Import Data.

Step 3 – Run a Query.

Take a screenshot of your query output and paste it into the Database Assessment Template that you will use to submit your assessment. Be sure to add a brief annotation to the screenshot in the assessment template identifying it and briefly explaining what it shows.

Part 2 – Explaining Databases

Include your responses to the following in the assessment template:

· Relational vs Non-Relational databases: MariaDB is an example of a relational database, while others such as MongoDB are examples of non-relational databases. Do the following:

. Identify two appropriate uses for each type of database with a brief explanation of why each is appropriate.

. Explain how each type of database stores and retrieves data.

· Database Best Practices: Perform Internet research on database best practices and address the following, while making sure to support your assertions with citations from professional sources:

. Describe three critical best practices for database maintenance.

Submission Requirements

Submit your completed Database Assessment Template with:

· Part 1 screenshot.

· Part 2 responses.

Make sure to read the scoring rubric to understand what must be included with these screenshots to reach the distinguished level.

Competencies Measured

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

· Competency 1: Describe IT structure within a business environment.

. Describe appropriate uses for relational and non-relational databases.

. Explain how relational and non-relational databases store and retrieve data.

· Competency 2: Apply basic IT principles.

. Run a successful database query as evidenced by a screenshot.

· Competency 3: Explain IT governance principles, standards, and practices.

. Describe critical best practices for database maintenance.

· Competency 6: Communicate effectively and professionally.

. Use a communication style and vocabulary appropriate for the target audience.

Note: Faculty may use the  Writing Feedback Tool  when grading this assessment. The Writing Feedback Tool is designed to provide you with guidance and resources to develop your writing based on five core skills. You will find writing feedback in the Scoring Guide for the assessment, once your work has been evaluated.