Blog

Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, finance, marketing, sales, and operations. The sales department is the only department where employees are paid a commission in addition to their yearly salary and benefits. All other departments compensate their employees with a yearly salary and benefits only. Commission is paid by multiplying the employee’s commission rate by the total amount of product units sold. You have access to the following data sets:

i will other information to complete task

 

Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, finance, marketing, sales, and operations. The sales department is the only department where employees are paid a commission in addition to their yearly salary and benefits. All other departments compensate their employees with a yearly salary and benefits only. Commission is paid by multiplying the employee’s commission rate by the total amount of product units sold. You have access to the following data sets:

  • Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID)
  • Invoice (InvNumber, InvDate, EmpNumber,  InvAmount)

InvoiceLine (InvLineNumber, InvNumber,  ProductNumber, Quantity)

  • Product (ProductNumber, ProductDescription, ProductCost)
  • Department (DepartmentID, DepartmentDescription)
  • Job (JobID, JobDescription)

Write a two to three (2-3) page paper in which you:

  1. Design a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December. Note: You will need to generate the tables described above (Employee, Invoice, InvoiceLine, Product, Department, and Job) in order to compare and validate your code. Validated query code must be part of your paper.
  2. Compare the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.
  3. Determine and explain the factors necessary to ensure referential integrity.
  4. Create an object-oriented model to show how the tables are interrelated through the use of graphical tools. Make sure that you are able to show the relationship types such as 1:M, 1:1, or M:1. Additionally, remember to include the determined factors from the previous assignment requirement. Note: The graphically depicted solution is not included in the required page length.
  5. Identify which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools. Note: The graphically depicted solution is not included in the required page length.
  6. Describe how Big Data could be used to assist in the productivity and forecasting of the organization’s products and 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 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.

The specific course learning outcomes associated with this assignment are:

  • Describe the role of databases and database management systems in managing organizational data and information.
  • Design and implement a database solution to solve a proposed business problem.
  • 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.

 

Points: 90

Assignment 2: Database Systems and Database Models 
Criteria Unacceptable

Below 70% F

Fair

70-79% C

Proficient

80-89% B

Exemplary

90-100% A

1. Design a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December.

Weight: 15%

Did not submit or incompletely designed a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December. Partially designed a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December. Satisfactorily designed a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December. Thoroughly designed a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December.
2. Compare the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.

Weight: 10%

Did not submit or incompletely compared the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month. Partially compared the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month. Satisfactorily compared the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month. Thoroughly compared the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.
3. Determine and explain the factors necessary to ensure referential integrity.

Weight: 10%

Did not submit or incompletely determined and explained the factors necessary to ensure referential integrity. Partially determined and explained the factors necessary to ensure referential integrity. Satisfactorily determined and explained the factors necessary to ensure referential integrity. Thoroughly determined and explained the factors necessary to ensure referential integrity.
4. Create an object-oriented model to show how the tables are interrelated through the use of graphical tools.

Weight: 20%

Did not submit or incompletely created an object-oriented model to show how the tables are interrelated through the use of graphical tools. Partially created an object-oriented model to show how the tables are interrelated through the use of graphical tools. Satisfactorily created an object-oriented model to show how the tables are interrelated through the use of graphical tools. Thoroughly created an object-oriented model to show how the tables are interrelated through the use of graphical tools.
5. Identify which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools.

Weight: 20%

Did not submit or incompletely identified which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools. Partially identified which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools. Satisfactorily identified which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools. Thoroughly identified which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools.
6. Describe how Big Data could be used to assist in the productivity and forecasting of the organization’s products and resources.

Weight: 15%

Did not submit or incompletely described how Big Data could be used to assist in the productivity and forecasting of the organization’s products and resources. Partially described how Big Data could be used to assist in the productivity and forecasting of the organization’s products and resources. Satisfactorily described how Big Data could be used to assist in the productivity and forecasting of the organization’s products and resources. Thoroughly described how Big Data could be used to assist in the productivity and forecasting of the organization’s products and resources.
7. Clarity, writing mechanics, and formatting requirements

Weight: 10%

More than 6 errors present 5-6 errors present 3-4 errors present 0-2 errors present

Locate and evaluate a periodical or newspaper article in print or online (e.g,, Wall Street Journal, New York Times, Time magazine, The Economist, Forbes) that details an economic issue on the local, state, or federal level. Make sure that the article is dated no longer than six months ago and the article is relevant to a topic covered in the course.

Locate and evaluate a periodical or newspaper article in print or online (e.g,, Wall Street Journal, New York Times, Time magazine, The Economist, Forbes) that details an economic issue on the local, state, or federal level. Make sure that the article is dated no longer than six months ago and the article is relevant to a topic covered in the course.

Upon reading the appropriate article, write a 1000-1500 word analysis, making sure to clearly answer and include the following:

 Write a summary of the article in your own words with limited quotes or paraphrasing. All quotes and paraphrasing must have proper APA citations.

 Discuss changes that you would make to your local, state, or national budget based on the economic issue addressed in this article.

 If you feel no changes are necessary, explain how the current budget influences the circumstances in the article.

 Include your views (pro/con) on a possible amendment to the Constitution requiring a balanced federal budget.

 Identify and analyze an historical event comparable to your article’s economic issue and how that incident impacted the daily life (work, home, and recreation) of the time.

 Once you have evaluated the impact of this issue, discuss how the economic issue in your chosen article applies to your own daily life (work, home and recreation).

Your paper should be written using proper APA format. You should also have proper APA formatted in-text citations and ending references.

As a safety professional, you have been asked to create a handbook explaining the various types of biological agents employees may have contact with in the workplace. In addition, you have been asked to include information regarding the basic exposure mechanisms for biological agents, methods of evaluation and control for biological agents, and methods of sampling for biological agents

As a safety professional, you have been asked to create a handbook explaining the various types of biological agents employees may have contact with in the workplace. In addition, you have been asked to include information regarding the basic exposure mechanisms for biological agents, methods of evaluation and control for biological agents, and methods of sampling for biological agents. You may use the training topics discussed on pages 128-129 of your textbook as a guide. Also, please feel free to use the CSU online library to locate additional information that you feel should be included in your handbook. This assignment should consist of no less than three pages, and any outside sources, including your textbook, should be referenced and cited using proper APA formatting.

 

Training Topics: Aseptic techniques, Laboratory and personnel hygiene, Laboratory safety practices, Personal protective equipment (PPE), Containment levels, Decontamination, disinfection and sterilization, Signage, noteces, entrance criteria, and postings, Prudent management of biologicallinfectious wastes, Operation and use of biological safety, and Emergency action, spill response, needle sticks, and self-inoculation.

 

What did you learn from your classmate’s posting? What additional questions do you have after reading the posting? What clarification do you need regarding the posting?

Develop the detailed documents required to engage potential investors in their entrepreneurial ventures, incorporating them into their business plans

Primary Discussion Response is due by Friday (11:59:59pm Central), Peer Responses are due by Tuesday (11:59:59pm Central).

Primary Task Response: Within the Discussion Board area, write 400–600 words (no more than 1,200 words) that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.

Write up to 3 paragraphs responding to the following questions with your thoughts, ideas, and comments. Because this will serve as a foundation to for future discussions, be substantive and clear. Use examples to reinforce your ideas.

Introduce your business concept or venture idea. Focus on the following in your discussion:

Articulate and explain your venture’s start-up costs.
Articulate and explain your projected sales figures.
These figures should be listed in an informal format, and they should be as comprehensive as possible.

Responses to Other Students: Respond to at least 2 of your fellow classmates with at least a 100-word reply about their Primary Task Response regarding items you found to be compelling and enlightening. To help you with your discussion, please consider the following questions:

What did you learn from your classmate’s posting?
What additional questions do you have after reading the posting?
What clarification do you need regarding the posting?
What differences or similarities do you see between your posting and other classmates’ postings?
For assistance with your assignment, please use your text, Web resources, and all course materials.

Write a 700- to 1,050-word explication of the poem’s meaning and effect on the reader, focusing on the relationship between the form of the poem and the content. Remember that form refers to all aspects of how a poem is written. This might be as general as the length of a poem, or as specific as word choice and sound.

Review “Versification” (pp. 2027–2052) from The Norton Anthology of Poetry.

Select a poem from the readings for this week.

Write a 700- to 1,050-word explication of the poem’s meaning and effect on the reader, focusing on the relationship between the form of the poem and the content. Remember that form refers to all aspects of how a poem is written. This might be as general as the length of a poem, or as specific as word choice and sound.

Support your interpretation by referring to the contents of the “Versification” section in The Norton Anthology.

Integrate the period’s expectations of what a poem is and should be; consider what this poem means in the context of medieval or 16th-century society.

Format your paper consistent with APA guidelines unless you are an English major; then use MLA. Remember to use third person when writing this essay.

 

 

Selected Poem (please use)

They Flee From Me

Related Poem Content Details

They flee from me that sometime did me seek
With naked foot, stalking in my chamber.
I have seen them gentle, tame, and meek,
That now are wild and do not remember
That sometime they put themself in danger
To take bread at my hand; and now they range,
Busily seeking with a continual change.
Thanked be fortune it hath been otherwise
Twenty times better; but once in special,
In thin array after a pleasant guise,
When her loose gown from her shoulders did fall,
And she me caught in her arms long and small;
Therewithall sweetly did me kiss
And softly said, “Dear heart, how like you this?”
It was no dream: I lay broad waking.
But all is turned thorough my gentleness
Into a strange fashion of forsaking;
And I have leave to go of her goodness,
And she also, to use newfangleness.
But since that I so kindly am served
I would fain know what she hath deserved.

Emotional interaction is a behavioral reaction that is reflected by an individual’s feeling when interacting with technology. Examine the affect that the visceral design of a laptop has on an individual’s behavioral response compared to the affect that the visceral design of a smartphone has

Interacting and communicating with other people is part of daily life. This includes face-to-face conversations, conversations over the phone or other mobile devices, and conversations through social media. Read the article titled, “Is social media ruining our kids’ social skills?” Provide your opinion on the effect that texting and social media (i.e., Twitter, Snap Chat, Facebook, etc.) are having on individuals’ abilities to articulate a face-to-face conversation. Support your opinion with one (1) example from your personal experience or an incident in the media.

Emotional interaction is a behavioral reaction that is reflected by an individual’s feeling when interacting with technology. Examine the affect that the visceral design of a laptop has on an individual’s behavioral response compared to the affect that the visceral design of a smartphone has

Design and develop the below queries using professional principles and standards: A set of SQL Statements that returns all rows and all data for each table in your database. Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause.

The following assignment is based on the database environment created in the Week Four Individual Assignment.

Design and develop the below queries using professional principles and standards:

  • A set of SQL Statements that returns all rows and all data for each table in your database.
  • Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause.
  • Two SQL Statements that join two or more tables in one query.  Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries.

Submit an .sql file with the scripts needed to create the required queries and submit the file using the Assignment Files tab.

Your plan is to aggressively go after the consumer and business market creating dual revenue streams. Your marketing strategy, research marketing mix and customer relationship marketing will be different for both groups.

Scenario Marketing:

 

 

As the marketing manager of a major franchise, your job will be to perform the daily tasks of a marketing manager.

Select one of the franchise companies below for which you would like to be Marketing Manager.

Edible Arrangements® – Edible fruit baskets – Creates fresh fruit arrangements and gourmet chocolate dipped fruit to order.

Cartridge World® – Cartridge Company – carries a complete line of both inkjet and toner printer cartridges. Offers both remanufactured and Original Brand (OEM) ink and toner cartridges for nearly all brands of printers, copiers, fax and postage machines.

Liberty Tax Service® – Taxes – provides tax service to both consumers and businesses.

Assumptions

  • Your plan is to aggressively go after the consumer and business market creating dual revenue streams. Your marketing strategy, research marketing mix and customer relationship marketing will be different for both groups.

In this scenario, you will be responsible for conducting the following tasks:

  • Observing and analyzing market trends
  • Examining competitors’ products and services
  • Investigating ways of improving existing products and services, and increasing profitability
  • Identifying target markets and developing strategies to communicate with them

Assignment

There are two parts to this Assignment so be sure to complete both parts.

Part 1: The Consumer and Business Market

Write a brief paragraph that answers the following questions. (This should not be in Question/Answer format).

  • Which company did you choose as your focus in this Marketing Management Assignment?
  • Where are the company’s headquarters located?
  • What is the mission statement of the company you chose to study?
  • The previous marketing manager developed an advertising campaign before the marketing strategy. How could this advertising campaign potentially create problems for the product?

Part 2: Marketing Strategy Planning

In preparation for your first presentation to the CEO of the organization, you will create a 3–5 page paper.

You will examine how the 3 C’s (customer targets, competitors, customer value proposition) and 4 P’s (Product, Price, Place, and Promotion) of marketing strategy influence marketing decisions about how you can increase purchases to consumers and increase purchases for business-to-business.

Your goal is to complete the consumer and business-to-business marketing strategy planning document. Using the bolded words as subheadings for each response as seen in the PDF of this Assignment, answer the following:

  1. SMART Goals: Using the SMART acronym, list several objectives you wish to accomplish.
  2. The 3 C’s of marketing strategy:Customer Targets: Discuss the customer targets (target market), you should have at least two. Provide for the CEO a more specific description of which customers you (the marketing manager) want to persuade to buy the product or service.

    Competitors: For each customer target, identify a competitor (brand or company) that may be able to provide the customer target a like product that would appeal to them.

    Value Proposition: What do you see as the value proposition? What are reasons for customers to purchase your brand/product. Summarize into a single paragraph.

  3. The 4 P’s of marketing strategy: Marketing Mix for the Consumer Market: Describe each of the 4 P’s as it applies to consumers that would purchase your product
    1. Product
    2. Price
    3. Place
    4. Promotion
  4. Marketing Mix: Business-to-Business Market: Describe each of the 4 P’s as it applies to business that would purchase your product
    1. Product
    2. Price
    3. Place
    4. Promotion
  5. Competitive Advantage:Using one (or more) of the competitive advantages below, describe the components of this advantage and why customers will perceive them as an advantage for your product or service over its competitors’.
    1. Cost-based advantage
    2. Price-based advantage
    3. Quality-based advantage
    4. Differentiation advantage
    5. Perceived quality advantage
    6. Brand-based advantage
  6. Product Life Cycle: Discuss the company’s products in The Product Life Cycle (PLC). Why do you think they are in that stage? Do you think there is any possibility of changing the current stage of the Product Life Cycle? For instance, if current products are in the maturity stage, what can the company do to have products in the Introduction or Growth stage?
  7. Increase Purchases: Consumers: Thinking of your consumer target market, how can you get current customers of the product or service to buy more?
  8. Increase Purchases: Business-to-Business: Thinking of your business-to-business target market, how can you get current customers of the product or service to buy more?

Provide a 3–5 page (APA formatted) marketing strategy plan paper with at least three supporting references that addresses this Assignment.

Your paper should be in APA format and cite all references used.

What, according to H. Gene Blocker, are the most important historical sources for our contemporary conception of human rights?

Our class’s final essay assignment requires you to reflect on the contemporary relevance of ancient codes, documents, and artifacts that contributed to the evolution of our modern conception of human rights. Your essay should answer these questions:

  1. What, according to H. Gene Blocker, are the most important historical sources for our contemporary conception of human rights?
  2. To what extent, if at all, can you identify in contemporary culture and government specific legacies of any of the ancient codes, documents, and artifacts we studied this week?

Please ensure that your essay addresses each component of both assigned questions and that your answer is well-organized, uses excellent, college-level prose, and makes judicious use of textual evidence. Your essay should be 600-900 words long.