+1 (909) 375-5650
4982 Parkway Street, Los Angeles, CA 90017
support@smartwritingservice.com
800-888

Database Administrator for Department Store

Database Administrator for Department Store

Click the link above to submit your assignment.

Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center.

Instructors, training on how to grade is within the Instructor Center.

Technical Paper: Database Administrator for Department StoreDue Week 10 and worth 200 points

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.

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.
Use at least six (6) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
Include charts or diagrams created in any chart or drawing tool with which you are familiar. The completed diagrams / charts must be imported into the Word document before the paper is submitted.
The specific course learning outcomes associated with this assignment are:

Compose conceptual data modeling techniques that capture information requirements.
Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
Describe the basic mechanisms for accessing relational databases from various types of application development environments.
Use technology and information resources to research issues in the strategic implications and management of database systems.
Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.
Click here to view the grading rubric.

For a custom paper on the above topic or any other topic, place your order now!

What Awaits you:  

  • On-time delivery guarantee
  • Masters and PhD-level writers
  • Automatic plagiarism check
  • 100% Privacy and Confidentiality
  • High Quality custom-written papers

 

A concept analysis

A concept analysis

Select a nursing concept (be sure to use a nursing theory) and then provide a response to each one of the steps included in a concept analysis regarding your selected concept. This information does not have to be comprehensive but provides a foundation to the upcoming assignment. Be sure to include a scholarly reference and be 300 words.

 

Do you want your assignment written by the best essay experts? Then look no further.  Order Now, and enjoy an amazing discount!!

 

 

 

Veterans Affairs (VA)

Veterans Affairs (VA)

Assignment Requirements

Refer to the “Case Study: Veterans Affairs (VA)” text sheet. By now, you have analyzed the case study and have suggested possible mitigating remedies to prevent loss of private information. Write an executive summary that supports your list of suggested remedies.

To begin, summarize your findings in a simple bullet-point list. This will help to prioritize the remedies suggested. Once you have the summary ready, compile your findings in the form of an executive summary. The main points you need to cover are:

§ Analyze the mistakes committed by both the employees and the Department of Veterans Affairs that led to data loss.

§ Ensure that the remedies you suggest prevent the mistakes you analyzed from reoccurring in the future. You can think of using encryption as one of the possible remedies. In this case, describe how encryption can be used.

§ Explain methods that will ensure proper monitoring and enforcement of the existing security policies.

§ Analyze the procedural changes made by the Department of Veterans Affairs as a result of the 2006 data breach. Are the changes sufficient to prevent similar data breaches in the future

Required Resources

Text Sheet: Case Study: Veterans Affairs (VA) (ts_caseveteransaffairs)

Submission Requirements

§ Format: Microsoft Word

§ Font: Arial 10-point size, Double-space

§ Citation Style: Follow your school’s preferred style guide

§ Length: No more than 500 words

 

For a custom paper on the above topic or any other topic, place your order now!

What Awaits you:  

  • On-time delivery guarantee
  • Masters and PhD-level writers
  • Automatic plagiarism check
  • 100% Privacy and Confidentiality
  • High Quality custom-written papers

 

Network Consultation for DesignIT

Network Consultation for DesignIT

The owners of DesignIT, who recently purchased 56’x36′ space for their expanding business, have asked you to place a bid on a consulting job. DesignIT is a graphic arts company that, up until now, had contracted work out to temporary design services. The new space will allow them to hire two (2) full time designers and a receptionist.

Description of space purchased:

4 Cubicles
1 Office
1 Server room
1 Reception desk
1 Conference room
DesignIT plans to relocate three (3) servers already configured as follows:
1 Web Server – Microsoft IIS Server
1 File Server – Microsoft Server 2008
1 Server – Server 2008 Small Business Server
DesignIT has requested that the design include the following:
High speed Internet access
Firewall
Antivirus / malware protection
Six (6) computers
Three (3) color laser printers
Wireless access for portable devices
DesignIT has requested the consideration of all interconnected devices and wiring, along with speeds, for best performance.
Section 1: Network Consultation Proposal(Microsoft Word)

Create a cost analysis, and develop a proposal for the company.

Write an five to seven (5-7) page proposal in which you:
Recommend one (1) suitable network design.
Suggest one (1) network architecture.
Suggest LAN and Wireless LAN (WLAN) wiring considerations.
Recommend hardware options and costs.
Suggest security considerations for:
Firewall
Antivirus software
Recommend software options and costs.
Outline the labor costs, equipment costs, and service costs for your suggested design in table format.
Identify the single point of failure, and recommend potential mitigation strategies.
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Section 1 of your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

Do you want your assignment written by the best essay experts? Then look no further.  Order Now, and enjoy an amazing discount!!

 

The inventory section of two companies using basic comparative analysis

The inventory section of two companies using basic comparative analysis

The purpose of this assignment is to evaluate the inventory section of two companies using basic comparative analysis, and to interpret the data to gain insight about the company’s inventory management.

Assignment Steps

Resources: Appendices D and E located in Financial Accounting: Tools for Business Decision Making

Note: While the data are not from the same year, inferences can be drawn regarding inventory management of the two companies.

Write a 1,050-word comparative analysis using the financial statements of Amazon.com, Inc. presented in Appendix D, and the financial statements for Wal-Mart Stores, Inc., presented in Appendix E, including the following:

Compute the 2014 values for Amazon.com and the 2015 values for Wal-Mart based on the information in the financial statements:
Inventory turnover (Use cost of sales and inventories)
Days of inventory
Conclusions concerning the management of the inventory can you draw from this data.
Show work on Excel® spreadsheet and submit with analysis.

Click the Assignment Files tab to submit your assignment.

 For a custom paper on the above topic or any other topic, place your order now!

What Awaits you:  

  • On-time delivery guarantee
  • Masters and PhD-level writers
  • Automatic plagiarism check
  • 100% Privacy and Confidentiality
  • High Quality custom-written papers

 

Database and Vulnerabilities and Security

Database and Vulnerabilities and Security

Consider the two vulnerabilities: Structured query language (SQL) injection and cross-site scripting. Complete the following:

Research these topics, and find 2 examples of breaches for each.
Provide a brief explanation in your own words for what these vulnerabilities entail.
Summarize the breaches in terms of the damage to the businesses and the specifics of the attacks.
What could have and should have been done to prevent the breaches
What could have and should have been done to mitigate the resulting damage
With APA format references.

Do you want your assignment written by the best essay experts? Then look no further.  Order Now, and enjoy an amazing discount!!

 

 

Using Solver to find the optimal solution to the given integer programming problem.

Using Solver to find the optimal solution to the given integer programming problem.

Consider the same operating room discussed in the Solver example in the chapter. Suppose that instead of maximizing profit from surgeries, our objective is to minimize the cost incurred due to surgeries. As before, we denote the number of major surgeries scheduled in a week using decision variable s1, the number of minor surgeries scheduled in a week using decision variable s2, and the number of elective surgeries scheduled in a week using decision variable s3.

The relevant data for each type of surgery is:

Surgery Type Cost Operating Room Time Labor Hours

Major (s1) $5,500 4 hours 15

Minor (s2) $3,000 0.5 hour 10

Elective (s3) $4,000 2 hours 12

In addition, for this problem we will assume the facility has only one operating room, which is available 60 hours per week, and the facility has a total of 500 labor hours a week that can be devoted to surgeries.

In the process of creating a Muther diagram, what are some key questions to consider Who should be asked these questions

 

For a custom paper on the above topic or any other topic, place your order now!

What Awaits you:  

  • On-time delivery guarantee
  • Masters and PhD-level writers
  • Automatic plagiarism check
  • 100% Privacy and Confidentiality
  • High Quality custom-written papers

 

Developing nations’ human population growth issues.

 Developing nations’ human population growth issues.

Research two developing nations’ human population growth issues.
Address the following in your first posting:
a) Do you think that all of today’s developing nations will complete the demographic transition and come to enjoy a permanent state of low birth and death rates
b) What are some ways in which developed nations can stabilize their population growth in a sustainable manner \
c) Do more affluent nations have responsibility to help under developed nations stabilize their population growth What are some steps that European and North American nations may take to assist the demographic transition of developing nations
d) Provide current research that exemplify and support your analysis into this week’s exploration of population growth and transition issues.

Do you want your assignment written by the best essay experts? Then look no further.  Order Now, and enjoy an amazing discount!!

 

Distinguishing Schools of Jurisprudence

Distinguishing Schools of Jurisprudence

There are five theories or schools of jurisprudence one may choose to follow when applying the law to a case. In this activity you will look at the case presented below and identify and explain the theory of jurisprudence that the judge is following as they make their decision.
CONCEPT REVIEW:
You will need to understand the five different forms of jurisprudence which are:
-Natural Law
-Positive Law
-Historical School
-Sociological Jurisprudence
-Legal Realism
Comprehension Case

Distinguishing Schools of Jurisprudence
Read the case below and answer the questions that follow.
There are five theories or schools of jurisprudence one may choose to follow when applying the law to a case. In this activity you will look at the case presented below and identify and explain the theory of jurisprudence that the judge is following as they make their decision.
Arizona has passed a state statute authorizing law enforcement officers and legal administrative personnel to determine the legality of an individual’s right to be in the United States (citizenship and immigration status) when stopped for a traffic violation or otherwise arrested for a crime. This law was passed in response to an increasing migrating of illegal immigrants entering the state over the past several years. Arizona attributes the influx of illegal immigrants to a rise in crime and an increased unemployment rate amongst residents of the state. Assume that statistics show that the percentage of traffic stops regarding Hispanics and other minorities has risen significantly since the passage of the law. Further assume that the percentage of Caucasian drivers and criminal defendants checked under the law is a significantly lower percentage as compared to Hispanics, Blacks, and other minorities.
Five Hispanic men were stopped for a broken tail light and brought to the local police station while their identities and status to be in America was checked. This took twelve hours and all five men were found to be naturalized citizens. They have sued Arizona alleging false arrest, violation of their constitutional rights, and other various civil and criminal violations. A motion has been made by the state of Arizona to dismiss the case.

Judge Rapinoe has found for the state. She recognizes that the law is questionable with regard to its legality but believes that in contemporary Arizona, laws that infringe on gray areas between legality and illegality should be supported if they effectively address true societal problems that have recently arisen and need to be addressed. Which school of jurisprudence does Judge Rapinoe most clearly adhere to
Justice Solo finds for the state because she believes that it is the state legislatures right and duty to establish state law and policy. She does not believe that anything should supersede the acts of the state government. Which school of jurisprudence does Judge Solo most clearly adhere to
Judge Kreiger finds for the plaintiffs. While she understands the state’s goals in establishing the law in question and recognizes the long established rights to liberty espoused in the Constitution, she bases her decision on the belief that it is immoral to treat people differently simply because they look or act differently than the majority in power and that the law should reflect common and generally understood moral principles. Which school of jurisprudence does Judge Rampone most clearly adhere to

 

For a custom paper on the above topic or any other topic, place your order now!

What Awaits you:  

  • On-time delivery guarantee
  • Masters and PhD-level writers
  • Automatic plagiarism check
  • 100% Privacy and Confidentiality
  • High Quality custom-written papers

 

Current Issues Analysis

Current Issues Analysis

The current issues analysis will give you the opportunity to examine current topics in human resource
management and practice your written communication and critical thinking skills.
Instructions:
• Select ONE article posted under ‘Current Issues Analysis’ on the ‘Content’ page in eCourseware. All
articles were published in HR Magazine from 2015 through 2017 and are available as full-text pdf files
via the UM Library Business Source Premier database. I am posting each article in eCourseware for
your convenience. Skim through each article and pick one that interests you the most. (Note: I will
post a new set of articles for the second assignment due later in the semester).
• Read the article. You may want to print it out first.
• Write a brief summary and analysis of the article. Specifically, discuss the following:
1) What is the purpose of the article
2) What are the key points or ideas in the article
3) How would the information in the article help a practicing manager or business owner
4) What additional information would be helpful on the topic, or what else would you like to
know about this topic beyond what was discussed in the article
WRITE IN YOUR OWN WORDS AS MUCH AS POSSIBLE. ABSOLUTELY DO NOT COPY AND PASTE
OR QUOTE ANYTHING FROM THE ARTICLE. If you simply copy and paste, or quote, what the
author wrote, I promise you will get a very poor grade, possibly a ‘0.’
Writing and Formatting Guidelines:
• Your paper should be no longer than one page, double-spaced, minimum 10 pt font (Arial, Calibri, or
Times New Roman), with 1-inch margins.
• Include the full article reference at the end of your paper. If you omit this, your paper will be returned
with a grade of ‘0.’ Here’s are examples of how to cite an article:
One author:
Lytle, T. (2017, May). Putting mentoring in reverse. HR Magazine, 46-51.
More than one author:
Enelow, W., & Kursmark, L. (2017, June/July). Mastering the HR Resume: 7 ways to showcase your
talents and accomplishments. HR Magazine, 30-32.
• Proofread your paper to ensure that it is well-written and free of errors (spelling, grammar,
punctuation, sentence structure, correct word usage, etc.)
• Submit your paper to the eCourseware Dropbox in a Microsoft Word file. Papers submitted in any
other format will not be accepted. Papers submitted via email will not be accepted without advanced
permission.
You have several weeks to work on this assignment. There is no justification for a deadline extension. Manage
your time carefully and start early!
Grading:
• See grading rubric next page.
MGMT 3215-M50 Current Issues p. 2 of 2
Grading Criteria Maximum
Points
Your
Points
Part 1: Purpose
Purpose of the article clearly stated 10
Part 2: Key Points
Key points in article clearly identified and summarized
15
Part 3: Practical Application
Discussion of how information would help a manager or business owner. 15
Part 3: Additional Information
Identify additional information on the topic that would be helpful.
10
Formatting and Writing:
All formatting and writing guidelines are followed. (Reminder: Paper will
not be graded if full reference not cited at end).

10
Total Points 60

Do you want your assignment written by the best essay experts? Then look no further.  Order Now, and enjoy an amazing discount!!