Assignment 5: Tour Operator Agency Database

Assignment 5: Tour Operator Agency Database
Due Week 6 and worth 90 points

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.

A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six months and the agency requires an enhanced data management strategy to sustain their business operations. Their existing data repository for its reservation processing system is limited in business intelligence and reporting functionalities. The tour operator seeks a database management specialist to assist them in leveraging their data sources to enable them to forecast and project tour sales appropriately.

Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics:

  • A table that stores all the salespersons. The table holds their employee id, first name, last name and “Tours sold” field. The “Tours sold” field is updated manually.
  • A table that stores tour customer data and tours sold. The table holds customer name, address, city, state, zip code, tour(s) selected, number of persons in tour, and total amount paid. The current structure will show the customer more than once, if the customer books multiple tours.
  • A tour table that is used as a tour rate sheet which holds the tours offered and the cost per person. Tour rates vary every three (3) months depending on the tourist season.

Write a three to four (3-4) page paper in which you propose an enhanced database management strategy. Your proposal should include the following:

  1. Design a data model that will conform to the following criteria:
    1. Propose an efficient data structure that may hold the tour operator’s data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure.
    2. Create naming conventions for each entity and attributes.
    3. Conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables. You may make use of graphical tools with which you are familiar. Note: The graphically depicted solution is not included in the required page length.
  2. Construct a query that can be used on a report for determining how many days the customer’s invoice will require payment if total amount due is within 45 days. Provide a copy of your working code as part of the paper.
  3. Using the salesperson table described in the summary above, complete the following:
    1. Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one (1).
    2. Create a query that can produce results that show the quantity of customers each salesperson has sold tours to. 
  4. Support the reasoning behind using stored procedures within the database as an optimization process for the database transactions.

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 any chart or drawing tool with which you are familiar. 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:

  • Explain the fundamentals of how data is physically stored and accessed.
  • Compose conceptual data modeling techniques that capture information requirements.
  • Design a relational database so that it is at least in 3NF.
  • Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
  • 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.
 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Writing Project:Joining A Conversation You’ve Researched (5–6 Pages)

Write a researched argument about an issue affecting your future career field or your major field(major:Elecrical Engineering). This paper is your own argument, but you should take into account what you’ve learned during this course:  begin by showing the conversation your paper is responding to (“they say,” which should include clear positions on the topic), have a clear statement of your own argument about the issue (“I say”), include quotes and incorporate them smoothly (both in the “they say” and “I say” paragraphs), point out possible objections to your argument, use appropriate transitions, and explain why the issue matters (so what? who cares?).  You must use at least 5 sources and at least 2 must be from academic peer reviewed journals.  You should also give your argument a clear title at the beginning of your essay.
No plagiarism: Review the definitions of plagiarism, and remember that plagiarism also includes submitting a paper from another class for this class.

Recommended structure:  For this paper you have 5-6 pages to work with and you need to include, in effect, five major parts:

  1. Introduction: includes an overview of the conversation (names of key authors and the issues you’re bringing up), a brief statement of your argument (or thesis statement), and a brief explanation of why your argument matters
  2. summary of 2 or 3 authors or arguments, with quotes as evidence
  3. summary of how they agree/disagree; provide quotes if necessary
  4. your own opinion and your reasons for your opinion (which includes at least one naysayer); provide quotes as evidence
  5. Conclusion: includes a return sentence, a restatement of your argument, and a developed explanation of why your argument matters

Note that these are five parts, not paragraphs (exceptions: the introduction and the conclusion are usually one paragraph each).  What could this look like?  Here’s an example:  After the brief introductory paragraph (where you introduce your topic, an overview of the conversation you’re entering, a sense of your argument and briefly why your argument matters), you might have a summary of one author (1 paragraph), then a summary of the second author (1 paragraph), and a summary of another author or position (1 paragraph).  Then you might have one paragraph that explains how they agree or disagree (though you can already allude to that in the summary paragraphs through phrases like “Unlike X, Y asserts that…”).  Note that the paragraph that explains how the authors or arguments agree or disagree is still “they say,” since you’re not yet putting forward your own opinion on the issues.  At that point you’ll have written about 3 pages.  Then you write your own argument (“I say”) in relation to the conversation you’ve set up (about two pages).  At that point you’ve written about 5 pages.  Then you end with a concluding paragraph, where you wrap it up with a return sentence and again explain why it matters. 

Keep in mind that this way of structuring your argument is only a suggestion; it doesn’t have to be exactly like that.  But hopefully this gives you an idea of what this kind of paper could look like.

I need to get three documents in the end:

1. Argumentative Paper Topic Proposals 

  • Do a little research and see what scholars or stakeholders are saying about a topic relevant to your field, your major, your community, or an issue covered in the readings for this class.  Keep in mind that you are looking for ongoing conversations (that is, arguments), not just facts, so you want to choose a topic that has some kind of debate surrounding it.  Skim a few articles (no need to read in-depth at this point, but you might want to save your sources for later use).  Once you’ve read the articles, use the They Say, I Say format to write a paper proposal (length:  one paragraph, meaning at least three sentences).  Attach this document as a Microsoft Word document.
  • Here is the structure for this assignment:
  • X says___________________whereas Y says________________________.   I will argue ___________________.
  • Note: Your paragraph should have enough detail to show you’ve read something.  Use specific details.  Also note that you are writing for academic purposes, so your tone will be more formal than conversational.
  • Here is an example (Note that the topic here is “writing” and the “I say” part of the argument reflects this emphasis.  Your topic probably will not be about “writing” and therefore should have quite a different “I Say” section):
  • Scholars such as Kenneth Burke and April Brannon have discussed the role of listening in writing.  Burke believes all writing is an act of listening in which the writer situates himself in the “conversation of mankind” while Brannon calls for increased attention to listening, as opposed to voice-claiming, in composition classes.  I intend to investigate the role of listening in writing.  I believe this is a worthy topic because no writing exists in a vacuum, and it is important to acknowledge ongoing conversations and to respond to them in a rhetorically sophisticated way.
  • After the paragraph, list your sources using the appropriate format (MLA or APA).

2. Find two academic articles and create a mini annotated bibliography. 

  • Below are two examples from an annotated bibliography.  (Note that Titanium has messed up the formatting, particularly indentations.  Make sure your assignment is properly formatted).
  • Graff, Gerald. Birkenstein, Cathy. “They Say, I Say”: The Moves that Matter in Academic Writing.  New York: Norton & Company, 2006.
  • Summary: Graff and Birkenstein seek to make academic writing more accessible by providing templates that allow writers to think critically about texts.  [P] While the authors acknowledge that the templates seem formulaic, perhaps something like the cousin of the five paragraph essay, they argue that their approach is actually an antidote to formulaic writing because it helps writers think critically and creatively about topics. Moreover, they believe their method is inherently democratic and argue, [Q] “This approach to writing therefore has an ethical dimension, since it asks writers not simply to keep proving and reasserting what they already believe but to stretch what they believe by putting it up against beliefs that differ, sometimes radically, from their own” (xxvi).
  •             Comparison:  Written for a general audience, this book is not marred by jargon and is easily accessible.  Like LaMott’s book, this book functions as a how-to for writing.  However, unlike LaMott’s book, the authors present a philosophical discussion of academic writing that helps them assert that this type of writing is highly significant. 
  • LaMott, Anne. Bird by Bird. New York: Random House, 1994.
  • Summary: Using a funny and down-to-earth voice, Lamott offers advice on how to be a writer.  She organizes her book into five sections: writing, the writing frame of mind, help along the way, publication and other reasons to write, and the last class.   Each section consists of short chapters that deal with various aspects or issues surrounding writing such as getting started, drafting, and revising.  [P] LaMott’s work provides a discussion of the internal struggle that often occurs when writing and describes the struggle as something akin to having “voices” in your mind that try to distract you (7).  Her book is by no means a “research” report on writing, and her claims are not factual.  However, she does present some very real issues surrounding writing in an eloquent and engaging way; her book is aimed at the general reader and indeed was a NYTimes best seller).  [Q] She states, “Writing can give you what having a baby can give you; it can get you to start paying attention, can help you soften, can wake you up” (7).
  • Comparison:  Unlike Graff and Birkenstein, LaMott does not discuss secondary sources.  Her more general aim is a personal appreciation of writing, not a philosophical consideration of the topic.  

3. The final draft of the paper.

  • Grading Guide:  
  • Introduction (10 points)
  • Includes an overview of the conversation (names of key authors and the issues you’re bringing up), clear “I say” statement (thesis) placed in relation to authors, and a brief explanation of why your argument matters
  • “They say” (20 points):  Shows conversation paper is responding to
  • Summary includes basic information about authors as well as the full title of essays; summaries do not agree or disagree with authors (summaries inhabit worldview); summaries use sophisticated signal verbs to summarize authors’ points; no listing or “closest cliché” (pp. 31, 35, 33)
  • Quoting (20 points): Uses quotes correctly and appropriately
  • Quotes used to present “proof of evidence” (p. 42) in summary of authors’ arguments — Quotes should not be “orphans” (p. 43) — Quotes should be framed appropriately (“quotation sandwich”) (p. 46) — Quotes should be Introduced with appropriate verb (p. 47) — Quotes should present “proof of evidence” (p. 42) — Indicates page number of quote (p. 48)
  • “I Say” (20 points):  Clear statement of your own argument
  • Clearly distinguishes “they say” from “I say” – Clearly signals who is saying what: Uses at least one template from pp. 72-75 — “I say” includes clear reasons for argument that are not simply summaries of authors’ arguments – Clearly plants naysayer to support “I say” argument (use at least one template from pp. 82, 83,84-85, 89).
  • Conclusion (10 points)
  • Includes at least one “return sentence” in the conclusion to remind reader of what “they say” (p. 27); includes a restatement of thesis or “I say”; includes a developed explanation of why your argument matters (uses templates from pp. 95-96, 98-99).
  • Bibliography or Works Cited (10 points)
  • Includes proper bibliographic form — no annotations included here — includes 5 sources; 2 must be peer-reviewed
  • Editing and tone (10 points)
  • No editing errors (spelling, grammar, punctuation, and formatting); Uses proper tone (formal where appropriate, informal where appropriate)

The file is the book we learnt in this class and the quatation styles.

 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

advanced digital system

301SE – ADVANCED DIGITAL SYSTEM

ASSIGNMENT – JAN 2019

1. Download the file “Q1_256gray.bmp” into a folder accessible by MATLAB. Write a

MATLAB program to implement the histogram equalization algorithm. Comments

must be included to explain the algorithm clearly. Do not use standard built-in

function such as histeq().

Plot the images and their histograms before and after the equalization.

(15 marks)

2.

a. Find and simplify the mathematical expression for the convolution of

ℎ��� ⨂ ���� for

���� = ��

����; ℎ��� = ��

����. (5 marks)

b. Write a MATLAB program to implement convolution function given by

���� = ℎ��� ⊗ ���� = ∑ ℎ������ − ������ .

Comments must be included for explanatory purpose. Do not use built-in

function conv().

Use MATLAB function written to compute the convolution over the range

0 ≤ � ≤ 20 and plot the result. (15 marks)

3. In this Problem you are to perform spectral analysis on the audio signals provided.

You are given a short piano piece “piano_sequence.wav” of duration 3 measures.

The second musical note and first chord (combination of notes) are given separately

in “piano_single_note.wav” and “piano_chord.wav” respectively.

Write a MATLAB program to perform the followings:

a. Read “piano_single_note.wav” into a vector x.

b. Determine the sampling rate and number of samples in x.

c. Use MATLAB built-in function to perform DFT on x, and save the result in X.

d. Create an array freq (in Hz) that represents the actual frequencies

corresponding to the indices of X.

e. Plot the |X(f)| vs freq from 0Hz to 3kHz.

f. From the spectrum, determine the fundamental frequency and its harmonics.

(10 marks)

g. Repeat the same spectra analysis for “piano_chord.wav”, including plotting

|X(f)| vs freq.

h. From the spectrum of “piano_chord”, determine the number of musical

notes in the chord. What are the fundamental frequencies of these notes?

(5 marks)

4. Filter design using Filter Design and Analysis Tool.

a. A low pass filter has the following specifications

i. Sampling frequency 48kHz

ii. Passband attenuation (Apass) = 1 dB

iii. Stopband attenuation (Astop) = 60 dB

iv. Passband edge (fpass) = 6kHz

v. Stopband edge (fstop) = 8kHz

Design a low pass IIR Butterworth filter with minimum order to meet the

above specifications

What is the order of the filter? What are the filter coefficients? Plot the

magnitude response and the phase response for this filter. Also, show the

pole-zero plot.

(8 marks)

b. Design an IIR, Chebyshev type 2 filter for the same specifications in (a). What

is the order of the filter? What are the filter coefficients? Plot the magnitude

response and the phase response for this filter. Show the pole-zero plot for

the filter.

(8 marks)

c. Compare the results of part (a) with the results of part (b).

(4 marks)

5. Exporting your filter designs in 4(a) and 4(b) to SIMULINK.

In SIMULINK, create two signals � ���, ����� supposition with a band limited white noise as follow:

�� = 0.000021 “#$ noise power: 0.0000021

� ��� = sin(2)* ���+ + noise, * = 3012 ����� = sin(2)*����+ + noise, *� = 12012

Inject the signals to the filters, and plot the input and output signals in the time-

domain before and after the filters, for all 4 three cases (2 signals x 2 filters). From

the filter design frequency response, estimate the attenuation expect at 3kHz and

12kHz. Comment on the waveforms.

(15 marks)

6. Write a structural VHDL code to implement a simple full adder circuit using basic

and-, or-, xor- gates. Comments must be included for explanatory purpose. Write a

small test bench code to perform simulation and verification. (15 marks)

END

 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Numerical Technics In Engineering

Here is a typical steady-state heat 

ow problem. Consider a thin steel plate to be a

10 20 (cm)2 rectangle. If one side of the 10 cm edge is held at 1000C and the other

three edges are held at 00C, what are the steady-state temperature at interior points?

We can state the problem mathematically in this way if we assume that heat 

ows

only in the x and y directions:

Find u(x; y) (temperature) such that

@2u

@x2 +

@2u

@y2 = 0 (3)

with boundary conditions

u(x; 0) = 0

u(x; 10) = 0

u(0; y) = 0

u(20; y) = 100

We replace the dierential equation by a dierence equation

1

h2 [ui+1;j + ui????1;j + ui;j+1 + ui;j????1 ???? 4ui;j ] = 0 (4)

5

which relates the temperature at the point (xi; yj) to the temperature at four neigh-

bouring points, each the distance h away from (xi; yj ). An approximation of Equation

(3) results when we select a set of such points (these are often called as nodes) and

nd the solution to the set of dierence equations that result.

(a) If we choose h = 5 cm , nd the temperature at interior points.

(b) Write a program to calculate the temperature distribution on interior points with

h = 2:5, h = 0:25, h = 0:025 and h = 0:0025 cm. Discuss your solutions and

examine the eect of grid size h.

(c) Modied the dierence equation (4) so that it permits to solve the equation

@2u

@x2 +

@2u

@y2 = xy(x ???? 2)(y ???? 2)

on the region

0 x 2; 0 y 2

with boundary condition u = 0 on all boundaries except for y = 0, where u = 1:0.

Write and run the program with dierent grid sizes h and discuss your numerical

results.

  • Posted: A Day Ago
  • Due: 13/01/2019
  • Budget: $10
 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"