Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

Homework
This answer was rated:

Can I get the answer to this? You have answered before. Thanks!Imagi

Can I get the answer...
Can I get the answer to this? You have answered before. Thanks!

Imagine that you have been hired as the database administrator for a local department store. The department store has recently expanded by opening five (5) stores within your local region. They have also launched a series of marketing campaigns to attract new customers and increase sales. For your hired role, you will be responsible for creating and maintaining an enterprise-wide database system that will hold the sales and inventory data for the organization. The designed database will help operations in supporting its new business marketing strategy. Using the concepts presented throughout the course, you will develop a plan to create this database and establish a design that aligns with the product sales initiatives of the organization.
Write a twelve to fifteen (12-15) page paper in which you:
Identify the potential sales and department store transactions that can be stored within the database.
Design a database solution and the potential business rules that could be used to house the sales transactions of the department store.
Evaluate all relationships of each entity within your database solution using the Crow’s Foot notation. Include all data elements, entities, relationships (such as 1:M, 1:1, M:N), and cardinalities for the department store database in your diagram. Note: The graphically depicted solution is not included in the required page length.
Research the Internet for best practices of how retail stores use databases for retaining customers and increasing sales and complete the following:
Justify how Big Data tools could be used for forecasting sales and inventory of the department store.
Propose two (2) SQL Stored Procedures that use SQL functions to help sales associates perform explanatory or predictive analytics.
Give your opinion on which of the two (2) ways you proposed in Question four (4) b provide greater value to expanding their business within the region.
Provide a copy of your working SQL code as part of the paper.
Research the Internet for database vendors that provide cloud computing services and complete the following:
Estimate the types of costs involved or the pricing structure required when implementing a cloud-hosted solution for a database.
Analyze security considerations and pricing of the different cloud implementation types.
Rank the cloud services options of Software as a Service, Platform as a Service and Infrastructure as a Service in terms of functionality, mobility, and ability to provide distributed transaction concurrency. Compare how these cloud-based services fit within an environment where users are mobile. Determine the technical provisions that would be required to ensure data integrity.
Evaluate whether the use of a distributed DBMS structure is appropriate and identify the optimization techniques that should be factored in to enhance the operations of the database in your design.
Provide at least two (2) examples of how lost updates and uncommitted data may occur, keeping in mind that five (5) stores will be generating transactions.
Determine the concurrency control factors that can be used to ensure valid execution of transactions within the current multiuser environment.
Research the Internet for backup and restoration recovery solutions and database security threats that could be applicable to the department store. Upon your research, complete the following:
Suggest at least two (2) options that could be made available to provide disaster management functions for the database system within the retail environment.
Assess the types of security threats that may exist when managing the department store database and suggest measure(s) that can be performed to minimize these threats that are particular to retail.
Show More
Show Less
Ask Your Own Homework Question
Answered in 4 minutes by:
9/8/2013
Steve Herrod
Steve Herrod, Masters Degree
Category: Homework
Satisfied Customers: 3,326
Experience: BA (Hons) & MA Qualifications
Verified

Steve Herrod :

Yes I will send that through in a couple of hours when back in front of my laptop

Customer:

Ok, great. I need it for today, I know kind of short notice. I really appreciate the help.

Steve Herrod :

No problem, as soon as I can will send you the link

Steve Herrod :

Uploading now

Steve Herrod :

Cheers

Steve Herrod :

Steve

Customer:

thank you

Steve Herrod :

No problem

Steve Herrod :

Let me know if it was OK

Steve Herrod :

Cheers

Steve Herrod :

Steve

Customer:

It was great, thanks a lot for the help!

Steve Herrod :

No problem, let me know if you need anything and if you are happy with the service please rate the answer so we know how we are doing

Steve Herrod
Steve Herrod, Masters Degree
Category: Homework
Satisfied Customers: 3,326
Experience: BA (Hons) & MA Qualifications
Verified
Steve Herrod and 87 other Homework Specialists are ready to help you
Ask your own question now
Ask Steve Herrod Your Own Question
Steve Herrod
Steve Herrod
Steve Herrod, Masters Degree
Category: Homework
Satisfied Customers: 3,326
3,326 Satisfied Customers
Experience: BA (Hons) & MA Qualifications

Steve Herrod is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

LogicPro

LogicPro

Engineer

5,672 satisfied customers

Expert in Java C++ C C# VB Javascript Design SQL HTML

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,549 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

Chris M.

M.S.W. Social Work

2,635 satisfied customers

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

F. Naz

F. Naz

Chartered Accountant

2,158 satisfied customers

Experience with chartered accountancy

Bizhelp

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Seanna

Tutor

1,781 satisfied customers

3,000+ satisfied customers, all topics, A+ work

< Previous | Next >

Related Homework Questions
I asked a question and will pay but the site asks me to
hi i asked a question and will pay but the site asks me to verify an ammount below 200 usd which i want to but it does not give me the option to do so, please help… read more
GLENN
GLENN
Master of Mathematics
329 satisfied customers
Which if the following is not included unpaid-in capital?
which if the following is not included unpaid-in capital? common stock pain-in capital-donations stock dividend distributable appropriation per loan agreement … read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,158 satisfied customers
This question is just for Dr. Kakonge. This purpose is to
Hello. This question is just for Dr. Donna Kakonge.This purpose is to pay the payment to Dr. Donna Kakonge on 06/16/2017 again because of something wrong about payment on 06/16/2017.The question on 06… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
On Excel contour map want to: 1) rotate series 180 degrees
On Excel contour map want to: 1) rotate series 180 degrees but not category 2) edit series name for all 3) edit legend 4) fill in colour boxes 5) change colour boxes to meet colorirmetric convention.… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
A rifle with a longer barrel can fire bullets with a larger
A rifle with a longer barrel can fire bullets with a larger velocity than a rifle with a shorter barrel. A. Explain this using the impulse momentum theorem B. Explain this using the work energy theore… read more
GLENN
GLENN
Master of Mathematics
329 satisfied customers
I need to get an answer of the case Conveyor Belt Project.
I need to get an answer of the case Conveyor Belt Project … read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
Where is the status bar? Im so sorry to be in a rush but if
where is the status bar? Im so sorry to be in a rush but if i fail my exam i have to redo my year … read more
The-PC-Guy
The-PC-Guy
Bachelor\u0027s Degree
628 satisfied customers
A recent survey found that 73% of all adults over 50 wear
A recent survey found that 73% of all adults over 50 wear sunglasses for driving. In a random sample of 20 adults over 50, what is the mean and standard deviation of those that wear sunglasses?… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
Is anyone familiar with Excel??? The link below will take
Is anyone familiar with Excel??? The link below will take you to my question. It is due 02/14/10 Sunday night , but the sooner the better. You will see "1: Five-Year Sales Projections" that is what I … read more
Stephen, MBA
Stephen, MBA
Master's Degree
166 satisfied customers
160 Word min.: Consider the internal control process
160 Word min.: Consider the internal control process required by the Sarbanes-Oxley Act. Do you think the expenses of implementing better internal controls are offset by the benefits of having the con… read more
Jane T(LLC)
Jane T(LLC)
Master's Degree
18 satisfied customers
I would ask this in homework but I think this is out of
Hi,I would ask this in homework but I think this is out of their area of expertise. How much to answer these 40 electrician trade school questions from Penn foster. This is their NEC graded project wh… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
I have questions on teh fundamental accounting principles
I have questions on teh fundamental accounting principles book nineteenth edition. chapter 11. if you do hit me up… read more
Brittany
Brittany
Bachelor\u0027s Degree
102 satisfied customers
I see you have already done this project but i dont see the
hello i see you have already done this project but i dont see the essay part of it or the brainstorm page it needed done,i am in need of these asap,if you can contact me that would be great,thnx “Evil… read more
O. Adames
O. Adames
Bachelor\u0027s Degree
77 satisfied customers
I need help on how to figure out this problem, I am having
Hello, I need help on how to figure out this problem … read more
GLENN
GLENN
Master of Mathematics
329 satisfied customers
How many words per minute does the average person think? How
Good afternoon, how many words per minute does the average person think? … read more
GLENN
GLENN
Master of Mathematics
329 satisfied customers
Section 1 – Objectives: Provide a brief summary of the
Section 1 – Objectives: Provide a brief summary of the project. • Section 2 – Task 1: Basic Web Tracking Mechanism: Summarize your efforts to investigate web tracking, including the screenshots you to… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
I need help implementing expectation maximization algorithm
I need help implementing expectation maximization algorithm in python … read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
I have 3 more if you want them, i have to pick a heroine,
i have 3 more if you want them, i have to pick a heroine, and do these assignments, let me know, and let me know what its worth, when this one is done, i will send you the other two, and pay seperatel… read more
O. Adames
O. Adames
Bachelor\u0027s Degree
77 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x