Description
Please research and explore an idea from the 2 grey boxes. All web resources must be cited APA format. short essay form 150-200 words. wikipedia is allowed. no plagiarism
Unformatted Attachment Preview
The term "bug" predates the
invention of the computer.
Thomas Edison called the "little
faults and difficulties" with his
inventions "bugs" in 1878.
The first real computer bug
was a moth, which got caught
between the relays of the Harvard
Mark II clectromechanical
computer in 1947. It was found
by Grace Hopper, who logged
the incident, along with the moth
itself and the comment "first
actual case of bug being found."
GOL
Source: Notebook entry
courtesy Naval Historical
Center, US Navy; photo No.
NII 96566-KN)
Some tools also call the
module to be tested the unit
under test (UUT).
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Attached.
Running Head: BUGS
Bugs
Student Name:
Institution Affiliation:
Date:
BUGS
2
Computer bugs generally occur in both hardware and software system components, they
lead to unexpected errors. In software, they are caused by coding errors which were not anticipated
by the pro...
Completion Status:
100%
Review
Review
Anonymous
Really useful study material!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
EEL 3705 Fundamental of Digital Circuit Homework
I need some one who really knows Fundamental of Digital Circuit to do this home work. You can do it by hand written and sc ...
EEL 3705 Fundamental of Digital Circuit Homework
I need some one who really knows Fundamental of Digital Circuit to do this home work. You can do it by hand written and scan it, or do it by computer.
pleas answer below
posts must be a minimum of 250 words. 1) Using your book and the Internet, please explain Router Attacks Be sure to cit ...
pleas answer below
posts must be a minimum of 250 words. 1) Using your book and the Internet, please explain Router Attacks Be sure to cite your sources, the post must contain at least three sources (one can be your textbook). Forum Grading Rubric (100 Points) Synthesis of Concepts 55 Clear Citations using APA Format 10 Writing Standards 10 Timeliness 10 Peer Reviews (minimum of 2) 15
23 pages
Phase 4 With Toc
What is the IT project to achieve, create, or deliver? Constraints that restrict the ability to achieve the IT project obj ...
Phase 4 With Toc
What is the IT project to achieve, create, or deliver? Constraints that restrict the ability to achieve the IT project objectives?
DAD 220 Southern New Hampshire University SQL Database Documentation Worksheet
Competencies
In this project, you will demonstrate your mastery of the following competencies:
Create a structured data ...
DAD 220 Southern New Hampshire University SQL Database Documentation Worksheet
Competencies
In this project, you will demonstrate your mastery of the following competencies:
Create a structured database through the use of relational concepts
Implement basic processing functionalities to create new structured database environments
Step One Scenario
You are working as a database administrator for Quantigration, a networking equipment manufacturer. The company has grown quickly and is still evolving its internal business processes to handle the rapid growth. Customer return merchandise authorizations (RMAs), used to track shipments for defective or incorrect parts, are a specific area that has been identified as problematic.
Your supervisor at Quantigration has asked you, as part of their development team, to create a database for a new software application that will be used for processing RMAs. Because there are several locations where merchandise can be taken in, the application will also need to record where items are received. This system will also capture where the equipment is going next—repair, scrap, or refurbishing and resale. The warehouse shipping and receiving employees at your company will be the people using this application and are considered your “end users” for the application. Part of their job is to process customer return shipments. This involves the following:
Assessing the quality of the items being returned for defects
Identifying missing parts
Identifying signs of obvious wear and tear (such as dents or scratches to the equipment)
Step One Directions
Create a Database
The data architect on your DevOps team has come to you with a logical database diagram referred to as an entity relationship diagram (ERD). This is a documentation of the tables, their relationships to each other, their attributes, and any primary or foreign keys on those attributes. These elements are required to create the new database. To create your three tables named customers, orders, and rma in the QuantigrationUpdates database based on the example you have been given, complete the following steps, and place your work in the provided Database Documentation Template:
Prior to beginning, review the example entity relationship diagram (ERD) in the Quantigration RMA Diagram document. A text version of this diagram is available: Quantigration RMA Diagram Text Version.
Navigate to your online integrated development environment (IDE). Here, you will need to write the proper SQL commands in command line to create tables that demonstrate relationships based on the entity relationship diagram.
Create a database schema called QuantigrationUpdates and list it out to the screen.
Using the ERD as a reference, create the following tables with the appropriate attributes and keys:
A table to store customer information with a primary key of Customer ID
A table to store order information with a primary key of Order ID
A table to store RMA information with a primary key of RMA ID
Due to a new company branding initiative, you’ve been asked to change the name of the “Customer” to “Collaborator.” Update your existing table using SQL based on this change in requirements. Copy and paste the SQL you write to do the following:
Rename all instances of “Customer” to “Collaborator.”
STOP: Make sure to save your work before moving on to Step Two of this process. You will continue to work in Codio and use the documentation you started in Step One.
Step Two Scenario
Now it’s time to populate the database with records and run some basic queries against those tables. You will be using the QuantigrationUpdates database and three tables that were created in Step One to import data from the CSV data files into the tables, perform queries against those tables, and create an output listing to the screen of the query results. Your goal is to track shipments for defective or incorrect parts.
The shipping and receiving team that you are working with has been keeping records of their RMAs in spreadsheets, while your team has been creating its database in MySQL. The information that they have is detailed and won’t need cleaning. The data in the tables can be exported to CSV files. The data should also align with the columns and data types in your tables.
Step Two Directions
Load and Query the Data
In Step One, you created a customer return merchandise authorization (RMA) database using SQL to create tables and placed your work in the database documentation template. To complete your objectives in this step, continue to place your work in the database documentation template and follow these directions:
Please note before you begin that the three data files being used for this project are preloaded into Codio:
rma.csv
customers.csv
orders.csv
Import the data from each file into tables.
Use the QuantigrationUpdates database, the three tables you created, and the three CSV files preloaded into Codio.
Use the import utility of your database program to load the data from each file into the table of the same name. You will perform this step three times, once for each table.
Write basic queries against imported tables to organize and analyze targeted data. For each query, include a screenshot of the query and its output. You should also include a brief, 1- to 3-sentence description of the output.
Write an SQL query that returns the count of orders for customers located only in the city of Framingham, Massachusetts.
This query will use a table join between the customers and orders tables. The query will also use a where clause.
How many records were returned?
Write an SQL query to select all of the customers located in the state of Massachusetts.
Use a WHERE clause to limit the number of records in the customers table to only those who are located in Massachusetts.
Record an answer to the following question: How many records were returned?
Write an SQL query to insert four new records into the orders and customers tables using the following data:Customers TableCustomerIDFirstNameLastNameStreetAddressCityStateZipCodeTelephone100004LukeSkywalker15 Maiden LaneNew YorkNY10222212-555-1234100005WinstonSmith123 Sycamore StreetGreensboroNC27401919-555-6623100006MaryAnneJenkins1 Coconut WayJupiterFL33458321-555-8907100007JanetWilliams55 Redondo Beach BlvdTorrenceCA90501310-555-5678Orders TableOrderIDCustomerIDSKUDescription1204305100004ADV-24-10CAdvanced Switch 10GigE Copper 24 port1204306100005ADV-48-10FAdvanced Switch 10 GigE Copper/Fiber 44 port copper 4 port fiber1204307100006ENT-24-10FEnterprise Switch 10GigE SFP+ 24 Port1204308100007ENT-48-10FEnterprise Switch 10GigE SFP+ 48 port
In the customers table, perform a query to count all records where the city is Woonsocket, Rhode Island.
How many records are in the customers table where the field “city” equals “Woonsocket”?
In the rma database, update a customer’s records.
Write an SQL statement to select the current fields of status and step for the record in the rma table with an orderid value of “5175.”
What are the current status and step?
Write an SQL statement to update the status and step for the orderid, 5175 to status = “Complete” and step = “Credit Customer Account.”
What are the updated status and step values for this record? Provide a screenshot of your work.
Delete rma records.
Write an SQL statement to delete all records with a reason of “Rejected.”
How many records were deleted? Provide a screenshot of your work.
Create an output file of the required query results. Write an SQL statement to list the contents of the orders table and send the output to a file that has a .csv extension.
SWE 481 Colorado Technical University Customer Relationship Management Essay
Software Development Plan Document
This course is comprised of a series of individual project assignments that will also c ...
SWE 481 Colorado Technical University Customer Relationship Management Essay
Software Development Plan Document
This course is comprised of a series of individual project assignments that will also contribute to a group project due at the end of the course. Each week, you will complete a part of a software development plan, and you will share your results with your assigned group after your individual project has been graded. The group will integrate the projects into a group-developed version of the software development plan.
Your team will select a software engineering project that will cover the development process from conception to deployment. You are expected to perform the following tasks:
Select a development methodology to plan a real-life application.
Perform a trade-off analysis covering quality, features, cost, and time for rapid development.
Conduct requirements elicitation and documentation for the application.
Prepare a systems component design.
Organize a schedule that covers build, integration, and test of the application.
Conduct a risk assessment for the project.
Throughout this course, you will be working on a software development plan for the project that your team selects. You will not be developing the software, but you will work extensively with the concepts of good system-engineering practices during the creation of the plan. Additional information and the deliverables for each individual project will be provided in the assignment description for the project. The final deliverable is also known as the Final Key Assignment.
Project Selection
The first step will be to select a project as the target for your team’s software development plan. This project will be used as the basis for each of the individual project assignments throughout the course and should conform to the following guidelines:
Nontrivial: The selected project should be large enough to allow reasonable exercise of the software development planning processes.
Domain Knowledge: Students in the team should be familiar enough with the organization or software category to allow focus on the planning tasks without significant time required for domain education.
Accessibility: Students in the team should have good access to the people and other information related to the organization or system because this will be an important part of the process.
After your instructor has assigned team members, your team should select a software development project that fits these requirements and submit a proposal to the instructor before proceeding further with the assignments in the course. Approval should be sought within the first several days of the course. Your instructor will tell you how to submit this proposal and what notification will be given for project approval.
Assignment
For the assignments in this course, your team will not be implementing the actual development project, but rather, you will be developing a comprehensive software development plan document. Your team’s first task in this process will be to select a project to use as the basis of your plan. You will also create the shell document for the final project deliverable that you will be working on during each unit. As your team proceeds through each project week, you will individually and collectively add content to each section of the final document to gradually complete the final project delivery. Appropriate research should be conducted to support the analysis in your team’s plan, and assumptions may be made when necessary.
Note: To be clear, each individual will be creating a software development plan in fulfillment of the individual project assignments, and the team will also create a software development plan in fulfillment of the group project due at the end of the course.
Team Project Deliverables
Submit a project proposal to the instructor for approval.
After the individual projects are graded, team members should share their results with the team. The team should then integrate the results into the team’s version of the software development plan document. There is no submission for this part of the assignment until the end of the course.
Individual Project Deliverables
Software development plan document shell
Use Word
Title page
Course number and name
Project name
Student name
Date
Table of contents
Auto-generated TOC
Separate page
Maximum of 3 levels deep
Fields of TOC should be up-to-date before submitting
Section headings (create each heading on a new page with TBD as content, except for sections listed under new content below)
Project Outline
Development Methodology
Requirements
Design
Development and Testing
Project Schedule
Risk Analysis
New content
Project Outline
Brief description of the project
List of major issues to consider in the development of the application
Material taken from approved proposal submitted to instructor
Project must be approved by instructor
Development Methodology
Describe methodology that will be used for software development
Include justification of selected methodology and why it suits project well
10 pages
Term Paper
Electric vehicle technology has been highlighted as a critical component of future emissions and energy consumption reduct ...
Term Paper
Electric vehicle technology has been highlighted as a critical component of future emissions and energy consumption reductions in the transportation ...
Similar Content
SQU Viable Options to Replace the University Shuttle System Proposal Paper
I need ideas to replace the shuttle in the university campus.
Problem.
-The road in the picture will be closed...
University of South Florida Frontiers of Biotechnology Online Talk Summary
Watch: https://youtu.be/Xxe4D8u6sVEsummarize it in 2 paragraph and should be in this format:ECH4936 Online Talk SummaryStu...
“Strain Gages lab” technical writing to complete a professional Control lab report
Remember before u handle this work, this work is so important to me, so i will revise it many times before i turn it in an...
University of Kentucky Importance of Change in An Organization Discussion
Prior to reading this DQ, please read the PA2 assignment and understand what the assignment is asking you to complete. Onc...
Paraphrasing
Hello I want full paraphrasing for these pages I need plagiarism less than 5% thank you...
solidworks simulation
need images for step by step for both problems. files are problems and needed info. step by step and include files on here...
Risk Models
Risk Modelling Model risk is a sort of risk that occurs whenever a financial model is utilized to measure quantitative dat...
Report Beam Revision 2
Figure 4 Point Loads P1 and P2 applied in simply supported beam .............................................. 5 Figure 5 ...
Business Analytics
Figure 8.1 shows business analysis architecture. The data elements in the business analysis architecture need to be secure...
Related Tags
Book Guides
Dr Jekyll And Mr Hyde
by Robert Louis Stevenson
Dandelion Wine
by Ray Bradbury
The Red Badge of Courage
by Stephen Crane
Epic of Gilgamesh
by Unknown
Hidden Figures
by Margot Lee Shetterly
Principles - Life and Work
by Ray Dalio
The Color Purple
by Alice Walker
Pachinko
by Min Jin Lee
Persuasion
by Jane Austen
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
EEL 3705 Fundamental of Digital Circuit Homework
I need some one who really knows Fundamental of Digital Circuit to do this home work. You can do it by hand written and sc ...
EEL 3705 Fundamental of Digital Circuit Homework
I need some one who really knows Fundamental of Digital Circuit to do this home work. You can do it by hand written and scan it, or do it by computer.
pleas answer below
posts must be a minimum of 250 words. 1) Using your book and the Internet, please explain Router Attacks Be sure to cit ...
pleas answer below
posts must be a minimum of 250 words. 1) Using your book and the Internet, please explain Router Attacks Be sure to cite your sources, the post must contain at least three sources (one can be your textbook). Forum Grading Rubric (100 Points) Synthesis of Concepts 55 Clear Citations using APA Format 10 Writing Standards 10 Timeliness 10 Peer Reviews (minimum of 2) 15
23 pages
Phase 4 With Toc
What is the IT project to achieve, create, or deliver? Constraints that restrict the ability to achieve the IT project obj ...
Phase 4 With Toc
What is the IT project to achieve, create, or deliver? Constraints that restrict the ability to achieve the IT project objectives?
DAD 220 Southern New Hampshire University SQL Database Documentation Worksheet
Competencies
In this project, you will demonstrate your mastery of the following competencies:
Create a structured data ...
DAD 220 Southern New Hampshire University SQL Database Documentation Worksheet
Competencies
In this project, you will demonstrate your mastery of the following competencies:
Create a structured database through the use of relational concepts
Implement basic processing functionalities to create new structured database environments
Step One Scenario
You are working as a database administrator for Quantigration, a networking equipment manufacturer. The company has grown quickly and is still evolving its internal business processes to handle the rapid growth. Customer return merchandise authorizations (RMAs), used to track shipments for defective or incorrect parts, are a specific area that has been identified as problematic.
Your supervisor at Quantigration has asked you, as part of their development team, to create a database for a new software application that will be used for processing RMAs. Because there are several locations where merchandise can be taken in, the application will also need to record where items are received. This system will also capture where the equipment is going next—repair, scrap, or refurbishing and resale. The warehouse shipping and receiving employees at your company will be the people using this application and are considered your “end users” for the application. Part of their job is to process customer return shipments. This involves the following:
Assessing the quality of the items being returned for defects
Identifying missing parts
Identifying signs of obvious wear and tear (such as dents or scratches to the equipment)
Step One Directions
Create a Database
The data architect on your DevOps team has come to you with a logical database diagram referred to as an entity relationship diagram (ERD). This is a documentation of the tables, their relationships to each other, their attributes, and any primary or foreign keys on those attributes. These elements are required to create the new database. To create your three tables named customers, orders, and rma in the QuantigrationUpdates database based on the example you have been given, complete the following steps, and place your work in the provided Database Documentation Template:
Prior to beginning, review the example entity relationship diagram (ERD) in the Quantigration RMA Diagram document. A text version of this diagram is available: Quantigration RMA Diagram Text Version.
Navigate to your online integrated development environment (IDE). Here, you will need to write the proper SQL commands in command line to create tables that demonstrate relationships based on the entity relationship diagram.
Create a database schema called QuantigrationUpdates and list it out to the screen.
Using the ERD as a reference, create the following tables with the appropriate attributes and keys:
A table to store customer information with a primary key of Customer ID
A table to store order information with a primary key of Order ID
A table to store RMA information with a primary key of RMA ID
Due to a new company branding initiative, you’ve been asked to change the name of the “Customer” to “Collaborator.” Update your existing table using SQL based on this change in requirements. Copy and paste the SQL you write to do the following:
Rename all instances of “Customer” to “Collaborator.”
STOP: Make sure to save your work before moving on to Step Two of this process. You will continue to work in Codio and use the documentation you started in Step One.
Step Two Scenario
Now it’s time to populate the database with records and run some basic queries against those tables. You will be using the QuantigrationUpdates database and three tables that were created in Step One to import data from the CSV data files into the tables, perform queries against those tables, and create an output listing to the screen of the query results. Your goal is to track shipments for defective or incorrect parts.
The shipping and receiving team that you are working with has been keeping records of their RMAs in spreadsheets, while your team has been creating its database in MySQL. The information that they have is detailed and won’t need cleaning. The data in the tables can be exported to CSV files. The data should also align with the columns and data types in your tables.
Step Two Directions
Load and Query the Data
In Step One, you created a customer return merchandise authorization (RMA) database using SQL to create tables and placed your work in the database documentation template. To complete your objectives in this step, continue to place your work in the database documentation template and follow these directions:
Please note before you begin that the three data files being used for this project are preloaded into Codio:
rma.csv
customers.csv
orders.csv
Import the data from each file into tables.
Use the QuantigrationUpdates database, the three tables you created, and the three CSV files preloaded into Codio.
Use the import utility of your database program to load the data from each file into the table of the same name. You will perform this step three times, once for each table.
Write basic queries against imported tables to organize and analyze targeted data. For each query, include a screenshot of the query and its output. You should also include a brief, 1- to 3-sentence description of the output.
Write an SQL query that returns the count of orders for customers located only in the city of Framingham, Massachusetts.
This query will use a table join between the customers and orders tables. The query will also use a where clause.
How many records were returned?
Write an SQL query to select all of the customers located in the state of Massachusetts.
Use a WHERE clause to limit the number of records in the customers table to only those who are located in Massachusetts.
Record an answer to the following question: How many records were returned?
Write an SQL query to insert four new records into the orders and customers tables using the following data:Customers TableCustomerIDFirstNameLastNameStreetAddressCityStateZipCodeTelephone100004LukeSkywalker15 Maiden LaneNew YorkNY10222212-555-1234100005WinstonSmith123 Sycamore StreetGreensboroNC27401919-555-6623100006MaryAnneJenkins1 Coconut WayJupiterFL33458321-555-8907100007JanetWilliams55 Redondo Beach BlvdTorrenceCA90501310-555-5678Orders TableOrderIDCustomerIDSKUDescription1204305100004ADV-24-10CAdvanced Switch 10GigE Copper 24 port1204306100005ADV-48-10FAdvanced Switch 10 GigE Copper/Fiber 44 port copper 4 port fiber1204307100006ENT-24-10FEnterprise Switch 10GigE SFP+ 24 Port1204308100007ENT-48-10FEnterprise Switch 10GigE SFP+ 48 port
In the customers table, perform a query to count all records where the city is Woonsocket, Rhode Island.
How many records are in the customers table where the field “city” equals “Woonsocket”?
In the rma database, update a customer’s records.
Write an SQL statement to select the current fields of status and step for the record in the rma table with an orderid value of “5175.”
What are the current status and step?
Write an SQL statement to update the status and step for the orderid, 5175 to status = “Complete” and step = “Credit Customer Account.”
What are the updated status and step values for this record? Provide a screenshot of your work.
Delete rma records.
Write an SQL statement to delete all records with a reason of “Rejected.”
How many records were deleted? Provide a screenshot of your work.
Create an output file of the required query results. Write an SQL statement to list the contents of the orders table and send the output to a file that has a .csv extension.
SWE 481 Colorado Technical University Customer Relationship Management Essay
Software Development Plan Document
This course is comprised of a series of individual project assignments that will also c ...
SWE 481 Colorado Technical University Customer Relationship Management Essay
Software Development Plan Document
This course is comprised of a series of individual project assignments that will also contribute to a group project due at the end of the course. Each week, you will complete a part of a software development plan, and you will share your results with your assigned group after your individual project has been graded. The group will integrate the projects into a group-developed version of the software development plan.
Your team will select a software engineering project that will cover the development process from conception to deployment. You are expected to perform the following tasks:
Select a development methodology to plan a real-life application.
Perform a trade-off analysis covering quality, features, cost, and time for rapid development.
Conduct requirements elicitation and documentation for the application.
Prepare a systems component design.
Organize a schedule that covers build, integration, and test of the application.
Conduct a risk assessment for the project.
Throughout this course, you will be working on a software development plan for the project that your team selects. You will not be developing the software, but you will work extensively with the concepts of good system-engineering practices during the creation of the plan. Additional information and the deliverables for each individual project will be provided in the assignment description for the project. The final deliverable is also known as the Final Key Assignment.
Project Selection
The first step will be to select a project as the target for your team’s software development plan. This project will be used as the basis for each of the individual project assignments throughout the course and should conform to the following guidelines:
Nontrivial: The selected project should be large enough to allow reasonable exercise of the software development planning processes.
Domain Knowledge: Students in the team should be familiar enough with the organization or software category to allow focus on the planning tasks without significant time required for domain education.
Accessibility: Students in the team should have good access to the people and other information related to the organization or system because this will be an important part of the process.
After your instructor has assigned team members, your team should select a software development project that fits these requirements and submit a proposal to the instructor before proceeding further with the assignments in the course. Approval should be sought within the first several days of the course. Your instructor will tell you how to submit this proposal and what notification will be given for project approval.
Assignment
For the assignments in this course, your team will not be implementing the actual development project, but rather, you will be developing a comprehensive software development plan document. Your team’s first task in this process will be to select a project to use as the basis of your plan. You will also create the shell document for the final project deliverable that you will be working on during each unit. As your team proceeds through each project week, you will individually and collectively add content to each section of the final document to gradually complete the final project delivery. Appropriate research should be conducted to support the analysis in your team’s plan, and assumptions may be made when necessary.
Note: To be clear, each individual will be creating a software development plan in fulfillment of the individual project assignments, and the team will also create a software development plan in fulfillment of the group project due at the end of the course.
Team Project Deliverables
Submit a project proposal to the instructor for approval.
After the individual projects are graded, team members should share their results with the team. The team should then integrate the results into the team’s version of the software development plan document. There is no submission for this part of the assignment until the end of the course.
Individual Project Deliverables
Software development plan document shell
Use Word
Title page
Course number and name
Project name
Student name
Date
Table of contents
Auto-generated TOC
Separate page
Maximum of 3 levels deep
Fields of TOC should be up-to-date before submitting
Section headings (create each heading on a new page with TBD as content, except for sections listed under new content below)
Project Outline
Development Methodology
Requirements
Design
Development and Testing
Project Schedule
Risk Analysis
New content
Project Outline
Brief description of the project
List of major issues to consider in the development of the application
Material taken from approved proposal submitted to instructor
Project must be approved by instructor
Development Methodology
Describe methodology that will be used for software development
Include justification of selected methodology and why it suits project well
10 pages
Term Paper
Electric vehicle technology has been highlighted as a critical component of future emissions and energy consumption reduct ...
Term Paper
Electric vehicle technology has been highlighted as a critical component of future emissions and energy consumption reductions in the transportation ...
Earn money selling
your Study Documents