Sophia Database
MILESTONE 4 RETAKE GUIDE
Southern New Hampshire University
Actual Questions & Verified Answers with Rationales
100% Guarantee Pass
,6/1/22, 7:21 AM Sophia :: Welcome
Score 16/22
16/22 that's 73%
Retake
16 questions were answered correctly.
6 questions were answered incorrectly.
Milestone Tips
Remember that Milestones are open-book.
Take the Practice Milestone before taking the Milestone.
Take the Milestone at a time and in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Milestone Retake
UNIT
You are4 — one
allowed MILESTONE
retake per Milestone. 4
The retake score will replace your original score.
Make sure you're ready. Review our list of Milestone Tips.
Retake Now Maybe Later
Milestone Retake
Before you begin, please make sure you're in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Begin Retake
Cancel
1. Milestone Retakes
Sophia allows one retake per Milestone. If you ever want to retake a Milestone, click this button.
Got it
1
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14448574 1/16
, 6/1/22, 7:21 AM Sophia :: Welcome
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
What is the best example of a scenario in which a new database should be created to support the business?
An organization has found an application that can be used to manage pet services for pet owners and pet
groomers. Both have to log into the existing site to set up appointments.
A local pet shop would like to offer pet services. They have six pet groomers on staff and use MS Outlook
to help with tracking their appointments. The pet owner receives calls from customers and then schedules
them on the company computer through Outlook.
An organization would like to add pet services as an option to their existing pet store sales database.
Services and products should be able to be paid for at the same time.
An organization would like to create an application to help manage appointments for pet-related services.
The mobile application should allow pet owners to schedule services by viewing the availability of pet
groomers within the app.
RATIONALE
A database ideally should be created if it is a new tool that may need to have multiple types of users access it to
be able to insert, update, delete, and query from. If there is an existing application or database, it's best not to
create a new one but make use of the existing options to avoid data redundancy. New tables can be added as well
in lieu of creating a new database. If there is no third party to store the data or an existing database to add to, a
new database needs to be created.
CONCEPT
Databases in the Real World
Report an issue with this question
Reported. Thanks for your feedback.
2
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
In the context of a database, what do we get when we process data?
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14448574 2/16
MILESTONE 4 RETAKE GUIDE
Southern New Hampshire University
Actual Questions & Verified Answers with Rationales
100% Guarantee Pass
,6/1/22, 7:21 AM Sophia :: Welcome
Score 16/22
16/22 that's 73%
Retake
16 questions were answered correctly.
6 questions were answered incorrectly.
Milestone Tips
Remember that Milestones are open-book.
Take the Practice Milestone before taking the Milestone.
Take the Milestone at a time and in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Milestone Retake
UNIT
You are4 — one
allowed MILESTONE
retake per Milestone. 4
The retake score will replace your original score.
Make sure you're ready. Review our list of Milestone Tips.
Retake Now Maybe Later
Milestone Retake
Before you begin, please make sure you're in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Begin Retake
Cancel
1. Milestone Retakes
Sophia allows one retake per Milestone. If you ever want to retake a Milestone, click this button.
Got it
1
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14448574 1/16
, 6/1/22, 7:21 AM Sophia :: Welcome
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
What is the best example of a scenario in which a new database should be created to support the business?
An organization has found an application that can be used to manage pet services for pet owners and pet
groomers. Both have to log into the existing site to set up appointments.
A local pet shop would like to offer pet services. They have six pet groomers on staff and use MS Outlook
to help with tracking their appointments. The pet owner receives calls from customers and then schedules
them on the company computer through Outlook.
An organization would like to add pet services as an option to their existing pet store sales database.
Services and products should be able to be paid for at the same time.
An organization would like to create an application to help manage appointments for pet-related services.
The mobile application should allow pet owners to schedule services by viewing the availability of pet
groomers within the app.
RATIONALE
A database ideally should be created if it is a new tool that may need to have multiple types of users access it to
be able to insert, update, delete, and query from. If there is an existing application or database, it's best not to
create a new one but make use of the existing options to avoid data redundancy. New tables can be added as well
in lieu of creating a new database. If there is no third party to store the data or an existing database to add to, a
new database needs to be created.
CONCEPT
Databases in the Real World
Report an issue with this question
Reported. Thanks for your feedback.
2
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
In the context of a database, what do we get when we process data?
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14448574 2/16
