sql project 1

/in /by

I’ll give more hours if need be.

For this assignment, you will display and modify information from a Microsoft Access database by using SQL commands.

Using the Microsoft Access database Books, write SQL statements for the following tasks. Once complete, copy the SQL statements from Microsoft Access and paste them in a Microsoft Word document that will be submitted along with part II of the assignment.

  • Write an SQL statement to display the publication ID, publication date, cost, and category of each book planned for publication ID number 4.
  • Repeat the previous task but include ID and Date as column aliases for the first two columns.
  • Write an SQL statement to display the least expensive retail price book in each book category.
  • Repeat the previous task but sort the displayed categories in the descending order.
  • Write an SQL statement to display the customer number, city of destination, and shipping date for all shipments with order number above 2. (Hint: Use the Orders table.)
  • Repeat the previous task but further restrict the output to shipping dates after January 1, 2013. (Hint: The date restriction will require a format identical to the one displayed in the previous task, and it must be surrounded by pound signs—#01/01/2013# for example.)
  • Write an SQL statement to display the publication ID, average retail price, and average cost of all books. Group the output by publication ID.
  • Write INSERT statements to add the following data to the Publisher table:
PubID Name Contact Phone
6 READ WITH US John Doe 866-888-9999
7 KNOWLEDGE FOR ALL Jane Doe 800-1212-5555
8 CHEAP PUBLISHING Tom Smith 000-321-4071
9 TEXT AND MORE John Carter 032-100-7777
10 BOOK BUSTER George Stevens 777-555-1212
  • Write a single SELECT statement that will verify the records inserted.
  • Write a DELETE statement to remove only the new BOOK BUSTER record.

Part II—Course Project

Course Project Part 2—Identifying Entities and Attributes

In Week 1, you developed an initial idea to build a database. You followed the systems development life cycle (SDLC) and got an idea to start with. Now, it is time to start building your database.

What next?

The project description developed in W1 Assignment 3 is a first draft, so consider it a rough draft. This means that you should continue to develop your idea.

The next step is to select some nouns in your project description. For example, a project has invoices, invoice distributions, and suppliers as nouns. These nouns are entities, or tables, that would be used to create the E-R model. Then, the adjectives and verbs that describe the nouns would become the attributes, or columns.

Therefore, in the example that we considered, we might have the following entities and attributes:

Invoices Invoice_Distributions Suppliers
# Invoice_id # Invoice_distribution_id # Supplier_id
Invoice_num Invoice_distribution_line_num Name
Invoice_type Line_type Address
Supplier_id Invoice_id

Using your knowledge of selecting entities and attributes, complete the following tasks for this week:

  • Review your project descriptions and come up with five entities and some attributes that describe the entities. Do not identify more than five attributes for each entity.
  • In a Microsoft Excel spreadsheet, define six columns (nouns) from the project description you submitted in W1 Assignment 3 that you consider key to your database. These will be the tables for the database. Then, in the rows for each column, define the attributes (adjectives).

You have taken your creative idea and started to move the nouns and adjectives you identified in a logical model—the E-R model. This will give you a working outline of the tables that will be created in the final script.

Assignment Deliverable

After you complete the lab and course project, collate the information from both in a 3- to 4-page report in a Microsoft Word document.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post sql project 1 appeared first on Top Premier Essays.

“Letter from Birmingham Jail” – Assignment Hub

/in /by

 

Dr. King’s letter is quite lengthy, despite the fact he had to write it on scraps of paper while in prison and smuggle it out with his lawyer. You might want to print it out to highlight or underline key ideas.

 

As you read, pay close attention to how Dr. King addresses the points made by the Alabama clergymen who had criticized his efforts.

 

Fill out the handout

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Position Analysis

/in /by

Makeup the interview as u go along…THE COMPANY WOULD BE  the Federal Reserve bank of New York

oR YOU CAN MAKE UP YOUR OWN COMPANY…

 

NEED IS ASAP

Assignment 2: Market Position Analysis

Throughout this course, you will conduct a strategy audit for a selected company. In Module 1, you selected an organization for your course project activities.

In this assignment, you will assess the product portfolio for your selected business unit by analyzing the value proposition, market position, and competitive advantage of its products and services. You will begin your analysis by identifying the business unit and the product(s) and service(s) you will focus on in this paper.

Complete the following:

  • Conduct at least threeinterviews with your selected mid-level or senior managers. Use the interviews to solicit each manager’s understanding of your business unit’s market position, value proposition, and competitive advantage.
  • Provide either full transcripts or annotated summaries of the interviews. Include them in the appendix of your analysis.

In your analysis, be sure to cover the following:

  • Describe the target customer for the product/service in terms of relevant characteristics that impact the marketing strategy, including location (how it is reached) and buying habits.
  • Identify each customer segment’s specific wants and needs. Explain why they buy your company’s product or service, or a competing product or service.
  • Justify how well your product/service satisfies customer wants and needs. Identify any wants and needs that are not met by your product/service.
  • Analyze your product’s position in relation to the competition. Identify 3–5 main competitors. Explain how your product differs in terms features, function, quality, price, availability, brand image, etc. Explain why this differentiation is important to your customers.
  • Describe the source of competitive advantage for your product. Evaluate sustainability of this source of advantage.
  • Assess the long-term sustainability of the source of differentiation and competitive advantage.
  • Apply the five “P’s” of marketing to your product analysis.
  • Provide a concluding paragraph in your report that recapitulates the findings of your interview.

Click here to download a template to use for comparing your product to that of the competition.

Support your responses giving reasons and examples from scholarly resources. Include the matrix in an appendix and add an extra page for your references.

Write a 3-page paper in Word format and attach the matrix as an appendix. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstInitial_M2_A2.doc. For example, if your name is John Smith, your document will be named SmithJ_M2_A2.doc.

By Wednesday, January 23, 2013, deliver your assignment to the M2: Assignment 2 Dropbox.

Assignment Component
Proficiency
Maximum Points

Described the target customer for the product/service in terms of relevant characteristics that impact the marketing strategy, including location (how reached) and buying habits.

Target customer is clearly and accurately identified. Description includes all relevant characteristics that impact the marketing strategy, including (but not limited to) location and buying habits.
8

Identified each customer segment’s specific wants and needs. Explained why they buy your company’s product or service, or a competing product or service.

Each customer segment’s wants and needs are identified, specific, and appropriate.

Explanation as to why the customer buys the product/service is clear, complete, and provides specific detail to support ideas.
12

Justified how well your product/service satisfies customer wants and needs. Identified any wants and needs that are not met by your product/service.

Justification of how well the product/service satisfies customer wants and needs is clear, complete, and provides sound examples that support stance.

Any wants and needs not met by the product/service are identified and evaluated.
16

Analyzed your product’s position in relation to the competition. Identified the main competitors. Explained how your product differs in terms of features, function, quality, price, availability, brand image, etc. Explained why this differentiation is important to your customers. Explained how the 5 “P’s” of marketing are represented in the analysis.

Analysis of product in relation to competition is clear, complete, and detailed. Where the product resides in the market as a whole is clear and accurate. Main competitors are specified.

Explanation of how product differs from competition is clear and complete. It includes discussion of features, function, quality, price, availability, brand image, and the like.

Explanation of why differentiation is important to customers is clear and supports the justification as to customers’ wants and needs. Explanation links the analysis to the 5 “P’s” of marketing.
16

Described the source of competitive advantage for your product. Evaluated how sustainable this source of advantage is.

Source of competitive advantage for product is clearly and completely described with details to highlight specific ideas.

Evaluation of sustainability of source of advantage is clear and grounded in appropriate examples.
12

Included information from appropriate interviews.

Information from interviews is woven into the assignment and used as support throughout.
8

Wrote using ethical scholarship and proper grammar and mechanics.

Writing is clear, concise, and in an organized manner; demonstrates ethical scholarship in accurate representation and attribution of sources; and displays accurate spelling, grammar, and punctuation.
8
 
 

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post Position Analysis appeared first on My Nursing Experts.

media promotions

/in /by

I want to write a search for media promotions in Saudi Arabia.

Because this will be very wonderful for you and for the class of knowing the Media Promotions in Saudi Arabia.

You can choose or discuss the details in class

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post media promotions appeared first on Essay Writers.