IT-FPX2230_LastFirst_Assessment4-Attempt1

docx

School

Capella University *

*We aren’t endorsed by this school

Course

2230

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

6

Uploaded by aralph1993

Report
IT-FPX2230: Introduction to Database Systems Weekly Solutions Submission Template Name : Angela Ralph Date : 2/4/24 Course : IT-FPX2230 – Introduction to Database Systems Assessment : 3 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): - use volunteers; Database changed - CREATE TABLE hours ( -> volunteerId int, -> amountOfFunds int); - DROP TABLE hours; - CREATE TABLE hours ( -> volunteerId int, -> hoursWorked int); - CREATE TABLE funds ( -> volunteerId int, -> amountOfFunds int); - INSERT INTO funds VALUES (1, 100); - INSERT INTO funds VALUES (2, 432); - INSERT INTO funds VALUES (3, 28463); - INSERT INTO funds VALUES (4, 284); - INSERT INTO funds VALUES (5, 32847); - INSERT INTO funds VALUES (6, 2384); - INSERT INTO funds VALUES (7, 283); - INSERT INTO funds VALUES (8, 28); - INSERT INTO funds VALUES (9, 108); - INSERT INTO funds VALUES (10, 2837); - INSERT INTO hours VALUES (1, 10); - INSERT INTO hours VALUES (2, 13); - INSERT INTO hours VALUES (3, 5); - INSERT INTO hours VALUES (4, 20); - INSERT INTO hours VALUES (5, 23); - INSERT INTO hours VALUES (6, 18); - INSERT INTO hours VALUES (7, 16); - INSERT INTO hours VALUES (8, 10); - INSERT INTO hours VALUES (9, 10); - INSERT INTO hours VALUES (10, 25); - SELECT * FROM hours; 1
- SELECT * FROM funds; - SELECT hours.volunteerId, hours.hoursWorked -> FROM funds -> JOIN hours ON funds.volunteerId = hours.volunteerId; - SELECT amountOfFunds, hoursWorked -> FROM funds -> JOIN hours ON funds.volunteerId = hours.volunteerId -> WHERE hoursWorked = 10; - SELECT amountOfFunds, hoursWorked -> FROM funds -> JOIN hours USING (volunteerId); Insert screenshot(s) showing the result running your SQL statements here: 2
3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
4
Reflecting on this assignment, summarize the steps taken to complete the assignment and any issues you encountered: For this week’s assignment I created two new tables, hours and funds, and INSERTED data into each table. After creating each table, I queried both to ensure that the data was input correctly. After confirming the tables were set up correctly, I completed a few JOINS queries and was able to retrieve different data from each table using different combinations. I enjoyed this assignment and look forward to the next. 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: 1. Investigation. 2. System Design. 3. Development. 4. Execution. 5. 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 5
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. 6
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

CYB 230 Module Three Lab Worksheet finished.docx
JAV745-Project - Who Wants to be a Millionaire (CLI)- fall 2023.docx
Karla_Britton_GRA200_Milestone6 (1).docx
COP3353_HW03.docx
COP3353_HW02.docx
COP3353_HW04.docx
Ch 1 writing assignment.docx
ModuleOneCS405.docx
t3.pdf
Ass01.docx
t2.pdf
Ass03 (1).docx
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS