Give example of this query using sql instruction and explain about it.

The final project may covers, as much as possible, the following:
1. Basic overview of the data processing of your DBMS systems
2. dbase model: metadata, dbase structure, E-R diagram
3. few data in the DBase,
4. please use MS-Access at least with 3 tables and relationship link
5. Output Information to be generated by your dbase
6. Example of data processing and information search/query on your dbase
7. include input form to be used to enter, edit and delete record.
8. create Query to show certain data processing / filtering
9. give example of this query using SQL instruction and explain about it.
10. also create (output) report, and VBA programs if possible in your database.
11. add YOUR-NAME in the 1st RECORD in the dbase
(e.g. in customer table & show it in your Query). (my name: PENG Tzu Ting)
12. The report is around 500 words.

You will need to research and explain why you would select this option over the others available (advantages and disadvantages) options.

Proposed Architecture: The Proposed Architecture plan will include information regarding many aspects of the infrastructure of this project that you would build if this was a real system. You will need to research and explain why you would select this option over the others available (advantages and disadvantages) options.

Provide an interpretation for each of the i) p-value of the estimated slope coefficient, ii) slope coefficient and iii) r-squared

TASK
IN THIS ASSIGNMENT, YOU WILL WORK ON A PROJECT WHICH INCLUDES THE FOLLOWING:
Running a regression of stock returns against changes in exchange rates
Interpret the findings of the regression analysis
Estimate the degree of economic exposure based on the results from the regression analysis
You will do all of the above twice, first using some made-up data provided below; and a second time using an actual MNC you will select.
INSTRUCTIONSTIONS
Download the spreadsheet “Economic Exposure”. The file contains the following data over a 61month interval (these are data I made up for Part 1): Economic_Exposure.xls
Download Economic_Exposure.xls
the stock price of a multinational company,
the value of the European Currency Unit (ECU), quoted $/ECU.
PART 1
Step 1: Use the price series for the company to calculate monthly returns. Note that 61 months of price data will generate 60 months of returns. Similarly, use the ECU series to calculate the monthly percentage changes in the dollar value of the ECU. Show the two series of changes in two separate columns next to the original prices and exchange rates.
Step 2: Regress the return on the company against the percentage changes in the ECU. Stated differently, the return on the company is the dependent (y-axis) variable and the change in the value of the ECU is the independent (x-axis) variable. Report the slope coefficient and its p-value, and the R-squared of the regression. The regression output should be shown in the Excel file.
Step 3: In one Word page, interpret the results as follows:
Provide an interpretation for each of the i) p-value of the estimated slope coefficient, ii) slope coefficient and iii) R-squared
How does the value of the company change when the dollar depreciates?
How much economic exposure does the company have? Here you reach a conclusion based on your answers to 1 and 2 above.
You will submit one Excel file with the regression data and results and one Word file with the interpretation. However, you may choose to provide your interpretation in the Excel file and submit just one Excel file and no Word file if you prefer. This is Part 1 of the assignment.
PART 2
Now select a Multinational Company that has a least 60 monthly return observations available at finance.yahoo.com and estimate the firm’s level of economic exposure using regression analysis, as in Part 1. Exchange rate information is available at, for example Historical rates
Links to an external site.
As part of your answer, provide the following information:
Identify the Multinational Company
Assess qualitatively the firm’s exposure to exchange rate risk after examination of the firm’s revenue information by geographical segment (for example, from SEC 10-K filings at U.S. SECURITIES AND EXCHANGE COMMISSION Links to an external site. and then “Filings”). Use this to briefly explain your choice of currencies to use in the regression analysis.
Provide and interpret the results of your regression analysis as you did in Part 1. Assess quantitatively the level of economic exposure of the firm relative to movements in the currency or currencies you selected. In your interpretation, follow the structure of Part 1.
Important: Make sure the dates for exchange rates and stock prices match when you put them both in the same Excel file as in Part 1. Use “adjusted prices” if you get your monthly stock prices from Yahoo FinanceLinks to an external site. (i.e., stock prices adjusted for stock splits)
You will submit one Excel file with the regression data and results and one Word file with the interpretation. However, you may choose to provide your interpretation in the Excel file and submit just one Excel file and no Word file.
The most difficult but also the most important aspect of the assignment is the interpretation. To help you get started, I have some basic ideas here: Regression Analysis get started answe

What are the major components that should be taken in consideration when a company want to use targeted marketing?

What are the advantages of a database management approach to the file processing approach? Give example to illustrate your answer?
What are the major components that should be taken in consideration when a company want to use targeted marketing? Give one example for each component?
What are the basic domains of Artificial Intelligence (Al) Applications? Give one real-world example illustrating how each domain can help businesses.

Do not include the questions.

Hello,

Please answer the following database tasks in separate word documents

Exercise 2
Submit your answers to the exercise questions at the end of chapter 2 in the free text book in a single Word document. Do not include the questions. Use your own words.
( textbook attached below ) ( https://opentextbc.ca/dbdesign01/ )
SQLZoo 2
Submit screenshots of your successful completion of SELECT from World and SELECT from Nobel and quizzes.
( https://sqlzoo.net/wiki/SQL_Tutorial )
Banas, revisited ( code attached below )
Now that you have succeeded in replicating the infamous Banas database example, I need you to refactor your work into three scripts so that:
1.) There is one script that only creates the database and inserts the tables. (Pick a good name for this, e.g., “buildBanasDatabas.sql”.
2.) There is a second script that loads data into the tables. (Pick a good name, e.g.,, “loadDataIntoBanasDatabase.sql”.)
3.) There is a third and final script that reads the data. (Pick a good name e.g., “readDataFromBanasDatase.sql”.)
You will submit three SQL scripts.
Each one must start with a meaningful comment block that indicates who you are, when you did your work, the CRN number of your course, etc.
Be sure that your scripts actually run.
Designing a database – Songbook
Using what you have learned from the Banas database create a songbook database. Each book has 10 songs. It has a publication date and a name. Each song has a name, a publication date, a genre and an author. Each author may have multiple songs but each song has a single author. Each genre will have multiple songs but each song has only one genre. Create and use foreign keys to connect the books and songs, the songs and their author, and the songs and their genre. Submit two scripts – one to create the database and one to populate the database. Do your own work. type it out yourself so that you contineu to learn the syntax.
Week 2 Self Study Lab – John’s T-shirts
Create a retail database for John’s T-Shirts
Tables: product, customer, Sales Person, Transaction
Reverse engineer and ER diagram using Workbench
Submit a Word document with the database code in screenshots. each screenshot should have a timestamp from your computer.

Which materials did you order?

Today, your customer, Windy City Bikes in Chicago, made an order to purchase 10 Deluxe Touring Bikes (Silver) (DXTR2078). It should be delivered within 2 weeks. After getting the sales order, you realized that there is no stock for the Deluxe Touring Bike (Silver). (Q1. Capture the screen in Figure 1) So, you contacted the vendor, Dallas Bikes Basics, and ordered only the materials (Qty: 500) that you have less than 50 stocks. If you have more than 50 stocks, you should not order the materials. (Q2. Which materials did you order? Q3. Show the inventory level of the materials that you ordered. Capture the screen in Figure 2) As soon as they are delivered, you paid to the vendor. (Q4. Capture the screen in Figure 3). Now you produce 20 Deluxe Touring Bikes (Silver) (DXTR2078). (Q5. Capture the screen in Figure 4) Among 20 bikes, you delivered 10 to the customers. (Q6. Capture the screen in Figure 5) Now, you need to capture the screen to show how much you got revenue from the customer. (Q7. Capture the screen in Figure 6). Lastly, capture the document flow from Sales and Distribution (Q8. Figure 7)

Which materials did you order?

Today, your customer, Windy City Bikes in Chicago, made an order to purchase 10 Deluxe Touring Bikes (Silver) (DXTR2078). It should be delivered within 2 weeks. After getting the sales order, you realized that there is no stock for the Deluxe Touring Bike (Silver). (Q1. Capture the screen in Figure 1) So, you contacted the vendor, Dallas Bikes Basics, and ordered only the materials (Qty: 500) that you have less than 50 stocks. If you have more than 50 stocks, you should not order the materials. (Q2. Which materials did you order? Q3. Show the inventory level of the materials that you ordered. Capture the screen in Figure 2) As soon as they are delivered, you paid to the vendor. (Q4. Capture the screen in Figure 3). Now you produce 20 Deluxe Touring Bikes (Silver) (DXTR2078). (Q5. Capture the screen in Figure 4) Among 20 bikes, you delivered 10 to the customers. (Q6. Capture the screen in Figure 5) Now, you need to capture the screen to show how much you got revenue from the customer. (Q7. Capture the screen in Figure 6). Lastly, capture the document flow from Sales and Distribution (Q8. Figure 7)

Why or why not?

Read Case #10 – “BLOCKCHAIN IS DISRUPTING THE SUPPLY CHAIN, then answer the following question: Page #183
What are the pros and cons of using blockchain technologies to manage the supply chain?
Given the choice, would you implement a blockchain technology to manage your supply chain? Why or why not?
Your submission should be a Word document of at least 400 words, with proper grammar, spelling and punctuation, including APA formatted references and in-text citations.
All case studies are found at the end of the chapter in your textbook.