Part 1Write a narrative that describes what information you will store in a database. Be as descriptive as you can be.

Part 2Create an E-R diagram that corresponds to yournarrative. If you have fewer than three entities in your E-R diagram, revise your narrative!Remember that foreign key values should not be in your entities.Make sure that you include maximum and minimum cardinalities for your relationships.You can use a tool to create the E-R diagram or draw it by hand and photograph it.You can use any style of E-R diagram that you like.

Part 3Convert your E-R diagram into a set of tables. All tables should be 3NF.

Part 4Write an SQLscript to create this database. Your table definitions should contain primary key and foreign key constraints. There shouldbe at least one CHECK constraint.There should be at least one index defined.Your script should include enough INSERT commandsso thatat least one table has at least 20 records, and all tables have at least 3 records.

Part 5Create 10 queries for your database. Show both the query and the result of the query. Write an English language description of each query. Make sure that your tables contain enough records to show the result of your query. Your queries should include:

•2 examples of GROUP BY

•3 queries with INNERJOINs, one of which has at least three tables joined together

•1 query with a LEFT JOIN

•2nested queries

•1 example of a nested query that includes a NOT IN

•1 example of a query with an aggregate function

Create three MySQL database tables and write SQL scripts to read, insert, and delete data. The first database table will contain the names of at least four movies. The second table will be a list of actors who appear in the movies. The third table will be an associative table that describes the relationship between the actors and their movies (which actors appear in which movies). Actors and movies have a “many-to-many relationship,” meaning an actor can be in multiple movies and a movie can have multiple actors.

• Use the MySQL Database Instructions to create the three tables.
• Once the three tables are completed, create a “join” statement that joins data from all three tables. Remember that field names used in more than one table (ASIN, ActorID) must be fully qualified (i.e., dvdtitle, ASIN).
• The previous SQL query returns a separate record for each actor. Provide a way to group results from several records into a single row.

General guidelines for this interactive assignment:

• String values in SQL statements are always enclosed within single quotes. ASIN and Title are both strings and require single quotes. For instance, your insert statement will look something like this:
  $sql = “Insert into dvdtitles (asin, title, price) VALUES (‘$asin’, ‘$title’, $price)”;
• SQL debugging tip: check your SQL statement before you execute it. Put the following line of code immediately before the mysql_query($strSQL) statement.
• When retrieving ASIN from the querystring, remember that ASIN is a string, not a number.

• Explain in detail the process on how to group results from several records into a single row.

You are asked to design a database to support a Instant Recruitment System of casual staff for a school. The major business requirements are summarised below in the Mini Case: An Instant Recruitment System. You are asked to develop a detailed Entity-Relationship model for this mini case. Your ER model should consist of a detailed ER diagram integrated with itemised discussions on the features of the entities and relationships and all the assumptions you made where applicable. The ER diagram and the accompanying document should identify keys, constraints, entity types, relationship types, specialisation/generalisation if any, etc. You must use the same notation scheme for the ER diagram as the textbook (use UML notations as shown in the last page of the textbook, and don't use Crew Foot notations), and the ER diagram should be strictly in the way the textbook uses for.

1. The ER diagram should include, among others, representative attributes for all entity types, proper subclassing if any, and correct participation multiplicities for the relationship types. It should be meaningfully and well designed, and should also include all relevant and necessary aspects, and indicate any supplementary business rules if you decide to introduce.
2. Map the above ER diagram into a global relation diagram (GRD) All the attributes should be kept there too. Include in the diagram all the primary keys, foreign keys, and the multiplicity constraints. (
3. Please note that an ERD is the artefact of the conceptual database design phase, while a GRD is the artfact of the logical database design phase which relates to the relational models. As such, a good ERD should be conceptually more concise and the relationships there should in general remain so rather than becoming extra entities as in a relational model.

use below data:

You plan to use an exponential smoothing method to forecast demand.

Find the MSE if you the exponential smoothing with alpha of 0.15

and the MSE if you use the exponential smoothing with alpha of 0.47.

Which of the above models is relatively more accurate according to

the value of MSE? Give a brief explanation.

Use the data above:

How does a 1% change in the exchange rate for the Brazilian real affect the price of the stock?

Is the relationship between the changes in the value of the real and returns on the stock statistically significant? Explain how you determine this

If an investor owning stock in the company were to hedge the real related risk of the stock perfectly, how much lower would the risk of the investment be? (That is, how much lower would the volatility of the stock be after hedging real related risk?

When the value of the real increases, how does the stock price change?

This is the third time I've posted this... please answer it.

1. Use the data from the file economic risk attached to answer the following:

a. How does a 1% change in the exchange rate for the Brazilian real affect the price of the stock?

b. Is the relationship between the changes in the value of the real and returns on the stock statistically significant? Explain how you determine this.

c. If an investor owning stock in the company were to hedge the real related risk of the stock perfectly, how much lower would the risk of the investment be? (That is, how much lower would the volatility of the stock be after hedging real related risk?)

d. When the value of the real increases, how does the stock price change?

Here is the info you need to answer the quetions:

20]

The annual financial statements of Hunter Ltd for the financial years ended 31 December2018 and 2019 are presented below.

Hunter Limited

Statement of profit or loss and other comprehensive income for the year ended 31 December 2019

Hunter Limited

Statement of changes in equity for the year ended 31 December 2019

Hunter Limited

Statement of financial position as at 31 December 2019  

R R     

Additional Information and Notes:

(1) All purchases and sales are made on credit terms.

(2) Trade debtors at 31 December 2017 amounted to R140 000.

Required:

Using the information provided above evaluate the company’s performance and position using financial ratio analysis.

A random survey of 2000 people is made & 900 responded affirmatively (so p = 0.45). Build & interpret a 95% confidence interval.

Falling Oil Prices and their Long-term and Short-term Impact on the Ordinary Investor

write a report at least 2000-2500 words.