Requesting assistance with a template that requires MariaDB

Name:

Date:

Course: IT-FP2230 – Introduction to Database Systems

Assessment:

Insert here a copy of your tee log file(s) of all of your SQL statements so that they could be unzipped, loaded, and run in MySQL command line client:

Insert here a copy of SQL statements text that you used here (copy and paste SQL statements here):

Insert screenshot(s) showing the result running your SQL statements here:

Reflecting on this assignment, summarize the steps taken to complete the assignment and any issues you encountered:

For Unit 1, Unit 2, and Unit 5 Assessments Only

u01a1: First Steps With SQL

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.

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.

· Summarize each step and describe how they work together.

· Explain how you have used, or can use, the 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.

u02a1: Creating the Initial Table for the Volunteer Database

Think about the design of the table to hold a volunteer's ID number, name, mailing address, phone number, email address, and three more fields of your choice. Briefly summarize (2–3 paragraphs) your design for this table. Explain your decisions about the structure of the table and data types used. Discuss how you would go about gathering and normalizing the information that you need for putting the volunteer database together and how that fits into the database life cycle.

u05a1: SQL Functions

Looking back at all of the work you have completed this quarter, briefly summarize (2–3 paragraphs) the key components of the volunteer database and discuss how the database life cycle has progressed through the phases of investigation, system design, development, execution, and maintenance.

1

2