Category: Essays

Task
Apple recently hired you to build a new database system for their iTunes store. The product manager gives you the following business requirements
? Each artist is assigned a unique ID in our iTunes database. The ID is a positive integer number and the database is interested in tracking their name, an artist’s genre and their age.
? Each artist can have multiple genre and each genre has multiple artists.
? An artist owns an album, where each album can be uniquely identified by an album ID and an album name. For simplicity, an album can only be owned by a single artist.
? Each album has a number of songs, where again each song has its own unique song ID. The iTunes database is also interested in tracking the song’s name, the order which it is listed in the album, the pricing of an album and length of the song. Each song is assumed to below to only one album.
? An album has a release date, genre and the region that it was released in. Each album can be released in multiple regions. There are ten different regions in the iTunes database. These regions follow the DVD coding that is given in http://en.wikipedia.org/wiki/DVD_region_code.
? The database should also support region-specific pricing of an album. That is, each album can be priced differently in different regions.

The product manager also tells you that the database must be capable of producing the following reports for the CEO every month. This includes a report that
1. lists all albums that has a song length greater than 5minutes
2. lists all albums released in a given period, e.g., 1 January 2013 and 31 January 2013
3. lists all albums that were above a certain pricing for each region code
Example: If album X in region A, B, C sells for $11, $8, $12 respectively, then the SQL query for pricing above $10 will list the rows as output
Album
Region
Price
X
A
$11
X
C
$12
4. lists all artists who has albums in a given set of region code, e.g., albums in region code 0 and 5
5. lists all artists who share the same genre
Example: If artist A has genre ‘rock’ and ‘classic’, artist B has genre ‘classic’ and ‘pop’, and artist C has genre ‘pop’, then the output should be
Acceptable output 1
First Artist Second Artist Shared Genre
A B Classic
B A Classic
B C Pop
C B Pop
Acceptable output 2 (better but harder)
First Artist Second Artist Shared Genre
A B Classic
B C Pop
6. lists all artists who produced an album that is not in the genre listed for that artist
Example: If artist X has genre ‘pop’ and ‘rock’ registered but produce an album Y with genre ‘classic’,
then the artist, (and optionally, album and that genre) should be listed.
7. lists all artists who has never produced an album that contains more than 10 songs in each album
As your product manager is in a rush, he asks you to start with this initial requirements. He wants you to
write a report containing
? the ER modelling that you have developed;
? the SQL statements that you think will produce each of the report requested, and a short discussion
of how your SQL statement will achieve the outputs desired;
? Since you haven’t got an opportunity to clarify the requirements, the list of assumptions that you
made in order to capture the above data and to produce the reports requested.
Hints
? You will have to refine your ER diagram as you look at each report requested so don’t expect to get
the ER diagram completed the first time.
? As you rework the ER diagram to support a report, make sure your ER diagram continues to support
the other reports, i.e., your SQL statements for the other reports still work.
? Before submission, check your ER diagram and all your SQL statements – your SQL statements should
be able to logically execute over the tables that your ER diagram will ultimately produce.
? Make assumptions that are logical – it is often easier for the marker to appreciate your design and
though process to be able to award marks.
? If you are unable to provide the “perfect” SQL statement, don’t panic. Write what you can as SQL
and then explain them to your marker as if you are the analyst and the marker is the database
administrator who will ultimately be responsible for producing the actual report.

request:
a clearly drawn and complete ER diagram

a list of assumptions (in point form is fine)

one SQL statement to each question

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

After reading chapters 1, 2 and 7 in Essentials of Risk Management, you should have a basic understanding of what is involved in managing risks within a corporation. I would like you to focus on the operational considerations that were mentioned in chapter 7 (a list can be found on page 155). Most of these considerations involve the employees in some way. I would like you to find an example of a company that failed to use risk management properly and explain how it could have helped them to avoid their problems.
The best way to begin this paper is to think of companies that you have heard of in the headlines in a negative way, or companies that have gone out of business in the last several years. Once you decide on a company, you should be able provide an explanation of the problem as well as your thoughts on how this could have been avoided using risk management. Another alternative is to use a company that you currently or previously worked for. If you choose the latter, please make sure that you can provide the required details.

This paper should include 3-5 pages of content with an additional cover and reference page. This is a total of 5-7 pages.

Your paper should be written in proper APA format.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Consider the short-term and long-term implications of cancer and drug treatments associated with men’s health, as well as appropriate preventive services.

To prepare:

* Locate and review articles examining prostate cancer in men.

* Review the U.S. Preventive Services Task Force article in the Learning Resources. Think about available preventive services that providers might recommend for patients at risk of this type of cancer.
U.S. Preventive Services Task Force. (2012). Recommendations for adults. Retrieved from http://www.uspreventiveservicestaskforce.org/adultrec.htm

* Select two of the following factors: genetics, gender, ethnicity, age, or behavior. Reflect on how these factors might impact decisions related to preventive services.

* Consider drug treatment options for patients diagnosed with prostate cancer, including short-term and long-term implications of the treatments.

Write a 2- to 3- page paper that addresses the following:
* Describe available preventive services that providers might recommend for patients at risk of prostate cancer.

* Explain how the factors you selected might impact decisions related to preventive services.

* Describe drug treatment options for patients diagnosed with prostate cancer. Explain the short-term and long-term implications of these treatments.

Use current resources not written or updated greater than five years. Make mention of generic drug names in paper.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Mahito’s cultural experience in the U.S. and Orlando’s?

While from different cultural backgrounds, what similarities do you observe between Mahito’s cultural experience in the U.S. and Orlando’s? What differences do you note? Include at least 1 similarity or difference that is unique. Include pertinent aspects of the assigned reading and/or material in your observations.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Search using individual internet research and write a report that investigates a cultural group in your desired field. Describe what the group is like in your own words.

Part 2

Select and interview a professional person in your field of interest. Ask questions about this person’s group that will allow you to gain insights into aspects of the culture that he/she is a member of. Integrate the insights gained from the interview responses and your impressions into your written report.

Assignment Format

•Cover page that includes your name, course and section number, date, and the Assignment title.
•Five pages clearly typewritten in college-level American English text (3 pages background text, 2 pages describing what you learned from the interview).
•One reference page listing sources you discovered in your background research and used to support your descriptive writing in Part 1 (use APA citation).
•Attach your interview questions and notes as an appendix.

Save your project in Word format and submit it in the Dropbox for Unit 7 Assignment. When you are ready to submit it, go to the Dropbox and complete the steps below:

•Click the link that says Submit an Assignment
•In the Submit to Basket menu, select Unit 7: Dropbox
•Click the Add Attachments button
•Follow the steps listed to attach your document
•To view your graded work, come back to the Dropbox or go to the Gradebook after your instructor has evaluated it

 

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Discussion of Results :
This is a major part of your report and will vary in scope, length and complexity according to the nature
of the investigation. Basically, the discussion evaluates the results, interprets them and investigates their
significance. It is the bridge that leads from the results, (tables, graphs, etc.) to the conclusions. The
statement of general conclusions and recommendations is reserved for the Conclusion and
Recommendation section.

Use tables and graphs to highlight significant results. If the results are not extensive, they may be
placed within the discussion text. All graphs and tables should be referred to in the text of the
discussion.

The discussion should include:
1. Major inconsistencies.
2. Your interpretation of the tabular and graphical results.
3. Error sources and possible corrections.
4. Comparison of results with published values.
5. Equipment failures.
6. An accounting for unexpected results.
7. Comparison of test with standard tests.

 

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Portfolio Project: A Relocation Project
You currently work at Brookhaven National Laboratory in Upton, NY and you have been promoted to an overseas post in Taipei, Taiwan.
This promotion requires you (and family) to move to Taiwan in 6?months’ time.
Part 1 – Project Scheduling
1. Explain and describe (in writing) the number of tasks/activities you have outlined and the order in which you have placed the tasks/activities for project completion.
• Using MS Excel, create a Gantt chart by entering the project dates and events into a table
• Next create a bar chart depicting the events based on the Gantt chart that you created.
• For assistance on creating a Gantt chart in excel visit the MS office help files online and search:
“Creating a Gant chart in Excel.” You may also visit:
http://office.microsoft.com/en-us/excel-help/create-a-gantt-chart-in-excel-HA001034605.aspx?CTT=1
http://www.brighthubpm.com/templates-forms/3418-using-excel-to-create-a-gantt-chart/
Part 2 – Monitor, Organize, Analyze
1. Develop an estimation chart showing each activity, the preceding activity required, and associated costs, with a 3 month, 4.5 month, and 6 month scenario.
2. Compare the costs of crashing the project from a 6?month time line into a 4.5?month timeline and then:
a. Explain and defend (in writing) the pros/cons of crashing the project schedule.
b. What is the impact on personnel and resources to crashing the project?
c. What are the associated risks of crashing the project and how will you manage the risks?
Part 3 – Project Control and Closeout
1. Explain and defend the processes and procedures you suggest for closing the project. Include the handoffs, benefits, and lag required to begin operation at your new location.
2. Your assessment should be well structured. Make good use of bulleted lists, numbered lists, and tables to further provide structure and clearly communicate information.

Papers are will be 5 to 7 pages.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Suppose that you have been alerted of a potential incident involving a suspected worm spreading via buffer overflow techniques, compromising Microsoft IIS Web servers. As the IR Team leader, it is your responsibility to determine the next steps.

Write a two (2) page paper in which you:

Explain in detail the initial steps that would need to be made by you and the IR team in order to respond to this potential incident.

Construct a process-flow diagram that illustrates the process of determining the incident containment strategy that would be used in this scenario, and identify which containment strategy would be appropriate in this case, through the use of graphical tools in Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.

Construct a process flow diagram to illustrate the process(es) for determining if / when notification of the incident should be relayed to upper management, and explain how those communications should be structured and relayed through the use of graphical tools in Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.

Detail the incident recovery processes for the resolution of this incident.

Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

 

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

REFLECTION: CONNECTIONS WITH THEORIES OF TRANSLATION (MINIMUM 3 PAGES)
– connect the use of the program of translation Swordfish to these articles of theories of translation
1) Paz: “Traducción: Literatura y literalidad” (.pdf)
2) Guix y Wilkonson: “El papel del traductor” (Manual de traducción 17-28)
3) Shulte: “What is Translation” (Translation Review 1-4)
4) Rabassa: “No Two Snowflakes Are Alike” (The Craft of Translation 1-12)
5) Kratz, Hatfield (Translation Review 5-11)
6) Biguenet, Lowe (Translation Review 12-20)
7) Kelly and Zetzsche (Found in Translation 199-232)
7) Kelly and Zetzsche (Found in Translation 199-232)
8) Haywood, Thompson y Hervey (Thinking Spanish Translation 68-82)
9) Lowe y Fitz: Translation and the Rise of Inter-American Literature (1-24)
10) Lowe y Fitz: Translation and the Rise of Inter-American Literature (25-61)

not all the articles have connections but some definitely do. sources must be scholars and pages stated

 

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

The paper will consist of 5 main sections:

1) Introduction (Stating objective, describing the problem, etc).

2) Body, which consists of at least 3 parts: explanation of the solution, Matlab code description, and discussion about results and error. You can add other parts when they are needed.

3) Summary of the journal article (One page at least).

4) Real-life application (Point out an application that can utilize the method used in this project other than the one mentioned in the article. One page at least).

5) Conclusion.

 

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]