Scenario: You have been asked to assist your organization’s marketing department to better understand how consumers make economic decisions.
HotelBranch (hotelBranchNo, hotelName, city) HotelRoom (roomNo, hotelBranchNo, type, price) Reservation (hotelBranchNo, CID, dateFrom, dateTo, roomNo) Customer (CID, customerName, customerAddress) With given schemas above where HotelBranch contains hotel details and hotelBranchNo is the primary key; HotelRoom contains room details for each hotel branch and (roomNo, hotelBranchNo) forms the primary key; Reservations contains details of bookings and (hotelBranchNo, guestNo, dateFrom) form s the primary key; Customer contains guest details and guestNo is the primary key. Roomt Types “D for Double, F for family) Provide the SQL statements for creating the tables above. you may choice each attribute data type as you think is best. You should also maintain the referential integrity constraints in your statements. Provide the SQL statements for each of the following: List full details of all hotels List full details of all hotels in Zavidovic. List the names and addresses of all guests in Tuzla, alphabetically ordered by name. List all double or family rooms with a price below 20.00 KM per night, in ascending order of price. List the bookings for which no dateTo has been specified. How many hotel branches are there? What is the average price of a room? List the average price for rooms for each type in each branch as descending order? What is the total revenue per night from all double rooms? How many different customers have made reservations for June 2016?
Discussion Topic:
Given the state of the economy and the causes of that state—think back to our online discussions a few weeks ago—what should be the appropriate mix of fiscal and monetary policy, from a Keynesian perspective? From a neoclassical perspective? Show each policy mix graphically using the AD/AS model. Which makes the most sense to you? Why?
no plagiarism need done by tonight ASAP DO NOT MESSAGE ME IF U CANT BE DONE BY TONIGHT
Question 2Nicholas Company manufactures a fast-bonding glue, normally producing and selling 44,000litres of the glue each month. This glue, which is known as MJ-7, is used in the wood industryto manufacture plywood. The selling price of MJ-7 is$30 per litre, variable costs are $18 perlitre, fixed manufacturing overhead costs in the plant total $253,000 per month, and the fixedselling costs total $338,000 per month.Strikes in the mills that purchase the bulk of the MJ-7 glue have caused Nicholas Company’ssales to temporarily drop to only 11,000 litres per month. Nicholas Company’s managementestimates that the strikes will last for two months, after which sales of MJ-7 should return tonormal. Due to the current low level of sales, NicholasCompany’s management is thinkingaboutclosing down the plant during the strike. If Nicholas Company does close down the plant, fixed manufacturing overhead costs can bereduced by $66,000 per month and fixed selling costs can be reduced by 10%. Start-up costs atthe end of the shutdown period would total $7,760. Since Nicholas Company uses leanproduction methods, no inventories are on hand.Required:1.Assuming that the strikes continue for two months, compute the increase ordecrease in income fromclosing the plant.Would you recommend that NicholasCompany close its own plant?2.At what level of sales (in litres) for the two-month period should Nicholas Companybe indifferent between closing the plant and keeping it open? (Note: This is a typeofbreak-even analysis, except that the fixed-cost portion of your break-evencomputation should include only those fixed costs that are relevant over the two-month period).
Writing Assignment #1 – Computer Applications
Writing a Business Memo
What You Need to Do:
1. Read chapter on ANALYTICS AND VISUALIZATION
2. For this assignment you are writing a business memo. In Resources you will find a link that discusses business memos: click the link “Writing a Business Memo”.
Specific Instructions for this Paper
Write a business memo. Follow standard business memo format. No slang, no abbreviations. No contractions. Example: “u”, “2”, “r”, “can’t”, etc.
In Resources open and read “WRITING A BUSINESS MEMO”. It can also be found at: http://www.writeexpress.com/business-memo.html
The beginning of a business memo has these sections:
• TO: Address to any name you want. You decide on the name. Any is fine.
• FROM: Type your name.
• DATE: may be any date. You decide on date. Any is fine.
• SUBJECT: Make the subject appropriate to the content of the memo (see below).
Note: The article referenced above shows () after each of the four sections. You should not do that. Do not use () in any of the four sections listed above.
Content: Based on ” ANALYTICS AND VISUALIZATION” chapter in textbook. Memo will contain five paragraphs:
• Opening. Paragraph #1 – Introduction – explain what the memo is about.
• Body. Paragraphs #2, #3, –In each paragraph discuss one of the chapter’s three main points. The order of the main points does not matter. The chapter has three clear sections.
• Closing. Paragraph #5 – Summarize your discussion.
Pay attention to these items which will affect your score:
• Content should be clear, easy to read, to the point.
• Attention will be given not only to content but also to spelling, grammar, sentence structure and punctuation.
• Do not use any slang or informal language.
• Make sure to have a correct beginning and five paragraphs.
Tip:
The broad topic of the memo is ” ANALYTICS AND VISUALIZATION”. The memo is specifically about the “key points” in the chapter on ” ANALYTICS AND VISUALIZATION”. Your memo’s subject is ” ANALYTICS AND VISUALIZATION” and the first paragraph explains that you will summarize the three main points of the chapter.
Tip:
The article “WRITING A BUSINESS MEMO” suggests getting a signature. Do not do that.
Tip:
A good business memo is short, clear, well organized, and to the point. You should write your memo that way.
Tip:
Select a font and font-size that is easy on the eyes. You will not be graded on your selection but the easier you make it for the grader to read the better.
Tip:
Write five paragraphs. Each paragraph should not be too long. Keep each to between three and five well written sentences.
Attachments:
As all the world knows, the North-going Zax always goes northand the South-going Zax always goes south. Assume neither looksanywhere but straight ahead. When roads are built around them, theyremain unflinching. Suppose two gas stations are built,one directly behind the north-going Zax and the other directlybehind the south-going Zax such that each Zax only can see thestation behind the other. Over the course of many days, thenorth-going Zax notices that the price of gas rising at the stationit can see. It also has observed you deliberately choosing to buygas at this station. You buy nothing else, just gas. During a pausein their quarreling, ‘South’ confirms that it has never seen youbuy gas at the station it can see (but it also has noticed theprice of gas rising). Given this scenario, why would you choose tobuy gas at a station which is raising its price of gas? There may be several possible answersbut there is one clear, best answer. . . .
1. Describe the game and related business process in detail?
2. Describe the team experience and how did you segregate the duties?
3. What did you like the most about your game experience today?
4. What did you like the least about your experience today?
5. With your knowledge of the game what could have been done differently? Please
download the data from SAP HANA and analysis using SAP Lumira. You might like
to include visualizations of your analysis. ( 2 % weightage)
6. What did you like the most about your game experience today?
7. What additional knowledge or skills would have helped you play the game today?
This answer should be in the lights of findings from your analysis. This analysis could
be related to different kinds of analysis proposed at page 12 of following document.
Attachments:
Question 1. Write an essay about HPLC (maximum 3 pages). 20 marks
The essay should include discussion about basic principles, basic components of a HPLC
instrument, limitations, methods, gradient elution, application fields, etc.
Question 2. Write an essay about IR spectroscopy (maximum 3 pages). 20 marks
The essay should include discussion about basic principles, basic components of an IR
instrument, type of IR instruments, working principle, measurement techniques, application
fields, etc.
Attachments:
We are a leading academic writing company, which has been providing exclusive writing services for years.
With an exceptional team of professional academic experts in a wide range of subjects, we guarantee high-quality custom-written papers.
Hi there! Click one of our representatives below and we will get back to you as soon as possible.
writing-assig….docx
Supply-Chain-….pdf