Requesting assistance with a template that requires MariaDB
Kfreela7
Assesment1instructions.docx· Overview
Use a provided template to practice basic SQL statements using MariaDB and the MySQLcommand line client.
Databases are a critical part of the world we work and live in. They facilitate the transformation and organization of oceans of raw data into information with a meaning that allows us to understand the facts and act upon them. The database system stores both the user's data and the metadata (data about data) that allow the storage and manipulation of that data. The database management system (DBMS) is a collection of programs and utilities that manage the structure of the data and control access to it. This assessment will allow you to get initial hands-on experience with a database (MariaDB) and the Structured Query Language (SQL) that allows you to interact with it.
By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:
· Competency 2: Describe the database system life cycle.
1. Summarize the steps and explain the Database System Life Cycle.
. Competency 3: Develop a simple relational database.
2. Create a new table to store data in a test database.
. Competency 4: Perform simple database manipulations.
3. Add records to a table.
3. Run Simple SQL queries.
. Competency 5: Communicate effectively.
4. Write with few spelling, grammatical, or mechanical errors.
Competency Map
CHECK YOUR PROGRESS Use this online tool to track your performance and progress through your course.
·
Context
A database is a repository of data. It is a collection of numbers, letters, and figures that must be processed in order to extract meaning. Only when this information is made available, through processing, can we proceed to draw conclusions. Data is random by itself; it must be processed in order to convey any useful information.
The structure of a database is made up of fields grouped into records and pulled together into files. The smallest unit of a database is called an entity. A field is made up of data entities—the letters, numbers, and figures. Examples of a field may be:
. A first name.
. A last name.
. Someone's age.
. A street name.
. A state.
When fields are placed together, they produce a record. An example of a record about you may be your first, middle, and last name along with your age, address, and phone number.
Compiling related records together produces a file. An example of a file may be a series of records on your classmates—one record for each classmate. From these records, we can begin to find useful patterns of data and information.
Databases are used in our lives every day. For example:
. A doctor maintains records about a patient's health and medications in a database.
. An insurance company maintains a database about a customer's property.
. The grocery store keeps database records of what consumers buy and when they buy it.
Most businesses today depend on databases. If a company were suddenly unable to use databases, it would most likely be out of business in a very short time. Think about the databases that you use. Do you use a checkbook, file tax returns, and keep track of expenses? These are all forms of databases.
Databases and database management systems support our lives personally, professionally, and publicly.
·
Resources
Required Resources
The following resources are required to complete the assessment.
. Download and install MariaDB on your computer.
. The Weekly Solutions Submission Template is required to complete the assessment.
Suggested Resources
The resources provided here are optional and support the assessment. They provide helpful information about the topics. You may use other resources of your choice to prepare for this assessment; however, you will need to ensure that they are appropriate, credible, and valid. The Database Development Library Guide can help direct your research. The Supplemental Resources and Research Resources, both linked from the navigation menu in your courseroom, provide additional resources to help support you.
Terms and Definitions
Become familiar with the following MariaDB and SQL vocabulary.
. MariaDB – an open source relational database management system built by the original developers of MySQL.
. MySQL – an open source relational database management system.
. MySQL Client – a program that interfaces with the database server.
. Open Source – a program whose source code is available for modification and redistribution at no cost to users and developers.
. Relational Database – a database that stores data in a structured format, using columns and rows.
. SQL – (Structured Query Language); a language used to manipulate and access a database.
. Tee – a MySQL command that sends database output to both your monitor and a text file.
Maria DB
Read the following course materials to introduce you to the database basics of MariaDB.
. MariaDB Foundation . (n.d.). Retrieved from http://mariadb.org/
. MariaDB Foundation. (n.d.). Library . Retrieved from https://mariadb.com/kb/en/library/
. MariaDB Foundation. (n.d.). Table basics . Retrieved from www.sqlcourse.com/table.html
. Dyer, R. J. T. (2015). Learning MySQL and MariaDB: Heading in the right direction with MySQL and MariaDB. Sebastopol, CA: O'Reilly Media. Available in the courseroom via the VitalSource Bookshelf link.
13. Forward (Explains origins and relationship between SQL and MariaDB).
13. Chapter 1, "Introduction."
13. Chapter 2, "Installing MySQL and MariaDB."
13. Chapter 3, "The Basics and the MySQL Client."
4. For Assessment 1, you may review and practice the SQL commands presented in Chapter 3.
SQL
The following materials provide you with the fundamental concepts of SQL.
· MariaDB Foundation. (2019). Mysql command-line client . Retrieved from https://mariadb.com/kb/en/library/mysql-command-line-client/
· SQLCourse.com. (n.d.). What is SQL? Retrieved from http://www.sqlcourse.com/intro.html
·
Asssessment Instructions
Overview
In this assessment, you will have the opportunity to practice basic SQL statements and understand concepts by introducing you to MariaDB and the MySQL command line client.
This assessment introduces to MariaDB and the Structured Query Language (SQL). Begin by downloading and installing MariaDB on your computer and then get some hands-on experience with the MySQL command line client by running some basic SQL commands provided in the file in the assessment resources (refer to "Assessment 1 Instructions").
Instructions
Your assessment will be scored using the following criteria. Use the Assessment 1 Instructions document to help you complete this assessment and use the Weekly Solutions Submission Template to submit your assessment.
Using the Capella library or the Internet, research the Database System Life Cycle. Find at least two references to it. Note that the names and wording in the steps of the life cycle may superficially vary between different sources. Focus on understanding the concepts presented, rather than the language.
· Using the MySQL command line client, log in to MariaDB and complete the SQL commands provided in Assessment 1 Instructions and compare your results to those shown in the document. 
· Save the SQL statements and results to a text file using the MySQL tee command.
· Take screenshots of your SQL statements and results for each exercise to be included in the Weekly Solutions Submission Template.
· Reflecting on this assessment, summarize the steps taken to complete the assessment and any issues you encountered.
· The Database System Life Cycle, otherwise known as the System Development Life Cycle (SDLC), consists of five important steps:
· Investigation.
· System Design.
· Development.
· Execution.
· Maintenance.
· Summarize each Database System Life Cycle step and describe how they work together.
· Explain how you have used, or can use, the Life Cycle in another context. For example, how can these steps be used when buying a car or planning a trip?
· Use a table to show parallels between developing a database and performing the task you chose.
· Use the Weekly Solutions Submission Template in the Resources. Your writing should be generally free from spelling, grammatical, or other mechanical errors.
Submit your completed document in the assessment area.
