Design a database using the following information. Using Microsoft Visio 2013, create a complete E-R Diagram in Crow’s Foot notation (including entity names

/in /by

How do I begin to do this:

Design a database using the following information. Using Microsoft Visio 2013, create a complete E-R Diagram in Crow’s Foot notation (including entity names, attributes, primary keys and foreign keys) that can be implemented, and then implement it in Microsoft Access. Your completed assignment will have two files submitted: the Crow’s Foot ER diagram and the Microsoft Access database file (an .accdb file).

My Closet is a small online company that sells dresses. All customer orders to My Closet are ordered from the dressmaker at the time of sale.

  • My Closet can order dresses from multiple dressmakers.
  • Every dressmaker produces one or more different styles of dresses.
  • Every style is produced by only one dressmaker.
  • Every style has one or more colors of dresses.
  • Every dress color made is belongs to only one style.
  • Every dressmaker is identified by a dressmaker code. The dressmaker name, address, email, phone number, and account number are kept for every dressmaker.
  • Every dress style is identified by a style code. The style name and price are kept for every style.
  • Every color is identified by a color code. The color name and the available sizes for that color are kept for every color.

How the reductions will be determined (seniority based system vs. performancebased)?

/in /by

You are the Director of HR for a small (120 employee), family owned company that provides cleaning services to local businesses.

The leaders of this company met to discuss the future state of the organization.  It was disclosed that revenues have been on a steady decline for the past three consecutive quarters.  Business is down and during this time period, it has become common to reduce employee hours and cancel shifts.  This has caused a number of problems with employees, given that the “operations” jobs are hourly.  The owner is concerned because of the large amount of employee fixed costs (i.e. insurance, paid time off, etc) and has come to the conclusion that in order to keep the company operational, the number of staff will need to be reduced by 20%.  This is the first time in the company’s history that this type of action will need to be taken and the owner is looking to you for advise as to how to handle this reduction in force.

Prepare a response that addresses the following:

  • How the reductions will be determined (seniority based system vs. performancebased)?
  • Any type of communication that needs to occur prior, during and after thereduction.
  • Any other procedural items that need to be considered (i.e. severance,outplacement assistance, legal issues, security, etc.)
  • APA style with quoted citations

Specify how these competitors’ offerings differ from each other in terms of strengths, weaknesses, and other characteristics.

/in /by

STAND-ALONE PROJECT

MK640 Marketing and Advertising

Stand-Alone Project: Competitive Market Analysis (200 points)

You should begin working on the Stand-Alone Project early in the course. Each lesson provides a benchmark for completing the Stand-Alone Project in a timely manner while working through the course. You will find this information in the “Stand-Alone Project Benchmark” section of each lesson. (200 points) (A 10-page response is required for the combination of Parts A, B, and C.)

Instructions: The Stand-Alone Project for this course requires you to assume the role of an account planner for an advertising agency assigned to compile a competitive market analysis on a given product.

Scenario: A manufacturer who is thinking seriously about marketing a new product in an industry with which you are familiar has approached your advertising agency and asked that you prepare a competitive analysis of the market for this product. The client will pay for this work on a project basis then decide whether to launch the product and hire your agency to design and execute the campaign.

While this situation is a hypothetical one with respect to your role and the new product, your competitive analysis should be based on reality. Use an outline format with brief descriptive explanations. The product may be for either the consumer or business-to-business markets. The following sections should guide your composition of the competitive market analysis.

This project is much more involved than the writing project in Lesson 4, which is a plan for gathering information that will be analyzed to support a marketing plan and effort. The Stand-Alone Project may be viewed as an extension of the earlier project, “drilling down” and using the methods described there and expanding on them to construct a competitive analysis in detail. In other words, you may use the product from Lesson 4 or create an entirely new one.

Your Stand-Alone Project responses should be both grammatically and mechanically correct, and formatted in the same fashion as the project itself. If there is a Part A, your response should identify a Part A, etc. (200 points) (A 20-page response is required.)

Part AResearch and Analysis:Begin by researching the product about which you will write an analysis.

1.    Describe the product and its associated industry.

2.    Identify this product’s direct competitors.

3.    Specify how these competitors’ offerings differ from each other in terms of strengths, weaknesses, and other characteristics.

4.    Detail how they differ from the proposed product.

5.    Detail how the proposed product is superior and/or inferior to the competitive products.

6.    Identify the target clientele of the competing products.

7.    Identify the segments in the target market.

8.    Describe the market share each competitor has.

9.  Outline the market strategies used by competitors.

Part B       Competitive Environment: In this section you will research and compose a summary of the competitive environment. Compare four (4) competitors in this section. Depending upon the product you have chosen, in this section you may want to describe the areas in which the proposed product is superior and/or inferior to the competitive products, determine the target consumer group of each competitor, and characterize how those target markets are divided. You may also wish to summarize competitive market shares, analyze the competitor’s marketing strategies, and determine who provides products that satisfy the same or similar customer needs. Tables and graphics in support of the text are encouraged.

Part C       Opinion and Recommendations: The final part of your report should be your own personal opinion of the proposed product’s prospects for success and an explanation of the reasoning behind your conclusions. This is the “bottom line” for your client as you see it. Include three (3) recommendations for steps that will improve the product’s chances to succeed.

NOTE: For an industry you are familiar with your own observations can be valuable. Specific supporting information is also available from many secondary research sources, including the following:

1.    Company Web Sites and Literature

2.    Industry Trade Show Observations and Contacts

3.    Online Databases, including ProQuest, DIALOG, Lexis-Nexis, EBSCO, First Source, PROMPT, Trade & Industry, and Investext

4.    TV Networks

5.    Hoover

6.    Investment Houses and Brokers

7.    Dow Jones/Factiva

Grading Rubric

Please refer to the rubric on the following page for the grading criteria for this assignment.

Submit your completed outline for your primary post; please submit as text, not as an attachment, as attachments will not be graded

/in /by

You can use your current speech topic for this assignment and I would strongly suggest that you do so! However, please make sure that you edit and perfect the outline prior to turning it in with your final speaking assignment (SA6).

When you build a house, the first thing you do is plan and create the underlying structure of the house–the part of the house behind and within the walls that may not be noticed if it’s done well, but that will certainly be noticed if it’s done poorly. Speaking in public is similar in some ways to building a house. While audience notice a speaker’s delivery, they may not notice the organization of the speech unless it’s so poorly planned that the speech seems to ramble without a point. Good speaking, in contrast, follows patterns of practical reasoning that the audience can understand and accept, and good speakers tend to organize their speeches in ways that follow such patterns.

  1. In your initial post, use the handout about organizational patterns to help you briefly outline a speech that might employ one of those patterns. You only need to list the main points of the potential topic. Please steer clear of overdone speech topics, such as gun control, abortion, marijuana laws, exercise and dieting, or other popular but contentious social issues. Use the vocabulary from your readings to describe the types of evidence and logical patterns; you may include outside research for additional examples or explanation. Submit your completed outline for your primary post; please submit as text, not as an attachment, as attachments will not be graded. You should select a single outline structure (the category should be appropriate for your topic and outline type) and a single topic and create a basic outline for the discussion board. Cite every outside source you use, including your readings.