30 Jan Discuss the use of joins

Unit 1 discussion

DQ1 First Attempts at Working With the Client and MariaDB

Work through at least some of the SQL commands in Chapter 3 of Dyer’s Learning MySQL and MariaDB (you will need to run all of them for part 1 of the assignment). Discuss your initial experience with working with MariaDB in the command line environment. Summarize what you have tried and describe your experience. Be sure to use terminology from the study assignment correctly. What issues did you run into and what questions do you have at this point?

DQ2 Database System Life Cycle

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.

Submit your response in the discussion area by Thursday evening. For the table, you may either submit a Word document or paste an HTML table into the discussion. Refer to the Discussion Participation Scoring Guide for posting expectations. Use APA format for all references.

Response Guidelines

Were your peers’ explanations of the life cycle clear?

Were there areas you found difficult to understand?

What suggestions do you have for your peers in their explanations?

What are your thoughts about their comparisons? Were their comparisons clear?

Unit 2 Discussion

Data Gathering and Normalization

Assume that you have been hired to develop a database to track volunteers who work and raise funds for a local community organization. Discuss data gathering process for the volunteer organization. Discuss how to approach the design of the tables and normalize the data acquired.

Unit 3 Discussion

Database Backup Policy and Process

Discuss backup policy and backup process. Develop a backup policy for the community organization’s volunteer database and describe the backup process.

Unit 4 Discussion

Using JOIN Queries to Combine Data From DB Tables

Discuss the use of joins and subqueries to produce more complex pictures of the data. Describe at least three JOIN queries that will provide useful reports from the data in the volunteer database.

Unit 5 Discussion

DQ1 Working With SQL Functions

Discuss how you will use some of the SQL functions you have read about in queries to report on the data in the volunteer database.

DQ2 Reflection: Building the Volunteer Database

Reflect on the process of building the volunteer database that you have worked through over the last few weeks. Relate this development to the database life cycle that you investigated for the discussion in Unit 1.