Database Administrator for Department Store

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:

  1. Identify the potential sales and department store transactions that can be stored within the database.
  2. Design a database solution and the potential business rules that could be used to house the sales transactions of the department store.
  3. 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.
  4. Research the Internet for best practices of how retail stores use databases for retaining customers and increasing sales and complete the following:
    1. Justify how Big Data tools could be used for forecasting sales and inventory of the department store.
    2. Propose two (2) SQL Stored Procedures that use SQL functions to help sales associates perform explanatory or predictive analytics.
    3. 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.
    4. Provide a copy of your working SQL code as part of the paper.
  5. Research the Internet for database vendors that provide cloud computing services and complete the following:
    1. Estimate the types of costs involved or the pricing structure required when implementing a cloud-hosted solution for a database.
    2. Analyze security considerations and pricing of the different cloud implementation types.
    3. 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.
  1. 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.
  2. 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.
  3. Determine the concurrency control factors that can be used to ensure valid execution of transactions within the current multiuser environment.
  4. 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:
    1. Suggest at least two (2) options that could be made available to provide disaster management functions for the database system within the retail environment.
    2. 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.
  1. Use at least seven (7) 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; references must follow APA format.
  • Must have introduction and conclusion.
  • At least one in-text citation in each paragraph.
  • All paragraphs must be labeled.
  • 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 page length.

Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.



Java- Data Structures and Analysis

Employs Modularity (including proper use of parameters, use of local variables etc.) most of the time


Employs correct & appropriate use of programming structures (loops, conditionals, classes etc.) most of the time


Efficient algorithms used most of the time


Excellent use of object-oriented design


Functionality (20 points):


Program fulfills all functionality


All requirements were fulfilled


Extra effort was apparent


Test Plan (20 points):


Comprehensive test plan.


Documentation (20 points):


Excellent comments


Comprehensive lessons learned


Excellent possible improvements included


Excellent approach discussion and references

Internship Assignment

Internship Assignment should follow these formatting guidelines: Use of three sources, 1–2 pages (not including cover page or bibliography section), double spacing, 12-point Times New Roman font, one-inch margins, and citations in APA format.

Harrison Kirby runs a local golf course with a shop of around 150 products. He wants to have a website that will facilitate e-business for his golf course. He wants online scheduling of tee times (including coordination of group play), online shopping, and social network integration. One difficulty of moving a small business from a traditional retail store to an online store is channel complications. Everything must be reconsidered. For example, how will he communicate with his customers? How will they find product information? How will he accept orders? How will he manage payments and shipping? These questions and many more have kept Kirby from making the e-commerce plunge. Below you will find a letter from Kirby explaining what he would like you to do:

Dear Intern,

 I have an interesting project for you. I am interested in an online presence for my golf shop. Specifically, I want to offer a few (less than 150) products online for in-store pickup or delivery. I would also like online scheduling of tee times. I want you to research the web for companies that provide this type of product. Ultimately, you may recommend a combination of providers to accomplish all that I am trying to do. For example, your final recommendation may include a web hosting solution, logistics provider, and a CRM (Customer Relationship Management) tool. Or, perhaps you will find a product that can be customized to provide all the functionality in one piece. Keep in mind that my shop is a small business, and I do not have resources to manage a complicated system. I need something that is fairly easy to implement, use, and manage. I have heard of online, cloud, as-a-service platforms that do not require local hardware. I think that this type of setup would be most useful to me, but I have no idea what type of software I should use to support my business.

After you complete your research, as the first step in this process, please send me a report with the following critical elements:

  1. Overview of the companies you learned about
  2. Profile of your selections and the reasons you chose them
  3. Summary of why you believe this will help me accomplish my goals

I am very excited to see your work!


Harrison Kirby

Note: You should incorporate at least three sources into your report; one source should be the textbook. Use paraphrasing and direct quotations to help demonstrate the concepts and support your perspectives.



Writing Tips:

  • In the body, use headings and sub-headings. Do not jump from subject to subject without providing some type of heading beforehand.
  • Use correct grammar and punctuation.
  • Make the presentation as professional as possible. Sloppy papers may have correct answers, but the message will be lost if the paper is not professional.
  • Make sure you understand how to cite reference material within the text of your submission (e.g., according to John Doe, “citing in text is a key concept in this course” (2013)).

Example APA-style citation:


Rainer, R. K., Prince, B., & Cegielski, C. G. (2014). Introduction to information systems: supporting and transforming business (5 th ed.). Hoboken, NJ: Wiley & Sons.

Coulomb’s Law

Review textbook Chapter 16 which involves the vector nature of electric forces. In this simulation, the green, red, and blue charges are originally (i.e., at t = 0) at the vertices of an isosceles triangle. The green and blue are fixed in space and the red charge is allowed to move. Find the net Coulomb force (magnitude and direction) on the red object due to the green and blue charged objects after 1.00 s has elapsed.

  • This simulation can be downloaded from within your course under “PH221.Simulations”; its file name is “Net Coulomb Force.ip”.
  • Fill in the blanks in the Lab Answer Sheet at the end of this lab.
  • Submit this Lab Answer Sheet when all of the labs are completed.
    • These can be scanned and sent as pdf or picture files (e.g. tif, gif, etc.) or by any other method of your choice as long as the Answer Sheets are legible and translatable by Grantham University.

Run the simulation. You will use the data from the “Time” and “Position” measurement tables (red, green, and blue) to help in calculating individual electrostatic (Coulomb) forces and directions.

Finally, calculate the net Coulomb force, Fc and direction, on the red object after 1.00 s; fill in the blanks on the Lab Answer Sheet to be handed in at the end of this week.