CSB Major Components of A Database & Terminology Used in Relational Database Models Part A Micro- Eco Your supervisor has been asked many questions about

CSB Major Components of A Database & Terminology Used in Relational Database Models Part A Micro- Eco

Your supervisor has been asked many questions about how the economy works and why the idea of limited resources is such a major concern in today’s economy. As a result, she has asked you to prepare a report on the topics.

Specifically, your supervisor has asked you to prepare the following:

A circular flow diagram that includes the government sector. For this part of your report, you should include a description of the roles that each participant plays in the economy and how the different sectors interact in the markets.
An illustration of the Production Possibilities model, including a summary of what the model is illustrating and the economic implications for the economy.
An explanation of why or why not trade with other countries is beneficial to an economy and how international trade fits into the circular flow diagram.
An explanation of the difference between micro and macro economics, indicating why the division is necessary.

Deliverables:

Prepare a Microsoft Word document that addresses the above tasks and meets APA standards.
Include a summary section in your report that contains 5-7 bullet points identifying your major findings or conclusions of your paper.
Submit the summary section as your initial post in the Discussion Area by the due date assigned. Include the full report as an attachment to your posting.
All submissions must be original and all resources must be properly acknowledged

Part B (SQL Development)

Database Design Techniques

In this assignment, you will study database design techniques and analyze the differences between data and information.

Using the South University Online Library or the Internet, research the following:

Need for data storage and its uses
Database design techniques

Based on your research and understanding, answer the following questions:

In your opinion, what is metadata and how does it affect the understanding and use of data? Provide an example of how metadata affects the data that you use every day.
According to you, what is data and what is information? Compare data and information.
How do e-commerce websites use database technologies to improve sales and track customer-buying and customer-searching habits? In your discussion, provide at least three examples of e-commerce websites that use databases.
Among the three examples you selected, which database design do you find most impressive? Why?

Additionally, discuss the statement: “Database design can directly affect an application’s ability to provide performance and functionality.” MBA 6400
Case 2
Investment Banking
U.S.-based investment banks have undergone what many would consider substantive changes in the last
eleven years, over the period 2007 to 2018. This period coincides with the Great Recession, which was a
significant driver of changes to investment bank business and characteristics. Such changes include
wider fluctuations in mergers and acquisitions, reduced initial public offering underwriting, reductions in
staffing, and associated impact on investment bank balance sheets.
For this case study, address the following items:
1. Identify one of the top ten investments banks as of 2018.
2. Provide a concise description of the bank’s core competency with examples of recent activities
or transactions. Be sure to provide specific $ data on the magnitude of the bank’s recent
activities.
3. How has the size of your selected investment bank changed in the last decade? Use $ valuations
to illustrate the change. In which investment bank functions did their overall business increase
and/or decrease?
4. Prepare a balance sheet analysis of the bank, comparing 2007 B/S $ values to the most recently
published B/S (either 2017 or 2018). Be sure to include the following items, in Excel
spreadsheet format:
a. % change in total assets, liabilities, and equity positions over this period
b. Past and current leverage position of the investment bank, and % change over this
period
c. Comparison of book to market value of the bank, 2007 to current value
5. Refer to the following short article and address the question in detail:
a. Article: Edelmann, C., & Hunt, P. (2017). How the Great Recession Changed Banking.
Harvard Business Review Digital Articles, 2–9
b. Question: Compare the financial analysis completed in item #3 above to the main points
in the article, including changes in B/S valuation.
Answer the following questions for a fictitious public offering, and show all calculations:
An investment bank offers underwrites an IPO of up to 18.5m shares for ABC Company at a price of
$12.50 per share. Show the $ return to the investment bank under both scenarios:
1. The 18.5m shares sell at $13.25 per share.
2. What happens if the IPO price is overstated and the shares sell for $12.25 per share?
To upload two assignment files to this assignment:
• You may submit multiple files in one submission. Click on “Browse my Computer” and pick
the first file.
• Next, click on “Browse my Computer” again to upload the next file.
• Do not click on “Submit” until you have uploaded all files.
Business-professional quality is expected. Prepare your report as if you are submitting to an
upper-level business director/executive.
Each case will require a qualitative analysis supported by quantitative data.
Prepare each case using Word, and embed your spreadsheet analysis into your case report.
Students will submit two files for each case assignment:
a. One Word file
b. One Excel file
Case Study Rubric
Criteria
Ratings
Pts
Introduction
1.0 to >0 pts
No Marks
10.0 to >1.0 pts
Level of Achievement
Provides a concise introduction (1/2 page) For scenario-
based case the primary issue clearly and concisely defined
(1/2 page)
10.0 pts
Analysis
1.0 to >O pts
No Marks
30.0 to > 1.0 pts
Level of Achievement
Provides thorough analysis of all case characteristics (2
page min)
30.0 pts
Financial
Analysis
1.0 to >O pts
No Marks
30.0 to >1.0 pts
Level of Achievement
Embeds financial analysis throughout the narrative, and
applies pertinent financial and quantitative data to support
research and conclusions
30.0 pts
Conclusion
1.0 to >0 pts
No Marks
10.0 to >1.0 pts
Level of Achievement
Conclusion summarizes/synthesizes key
issue/characteristic of case (1/2 page) Provides
recommendation if requested
10.0 pts
Excel
1.0 to >O pts
No Marks
10.0 to >1.0 pts
Level of Achievement
Provides Excel spreadsheet analysis that supports case and
addresses financial question
10.0 pts
Writing
Style
1.0 to >0 pts
No Marks
10.0 to >1.0 pts
Level of Achievement
Flawless spelling, punctuation, grammar, APA formatting,
concise business-style writing* *mistakes of this nature
repeated throughout the research paper could result in a
greater than 10% deduction
10.0 pts
Total Points: 100.0

Purchase answer to see full
attachment