What is the word length effect? include references and in text citations.

literature review on emotional intelligence and life satisfaction with citations and references

I am having trouble writing these queries in MYSQL. Using the schema listed below, please write the following queries in MYSQL:

1) Find the Content and the Reviewer Name for each comment, about “ACADEMY DINOSAUR” only if the same reviewer has commented about “ACE GOLDFINGER” too.

2) Retrieve the title of all the Movies in Japanese without any comment, ordered alphabetically.

3) Find all the movie titles where an actor called “TOM” or an actor called “BEN" acted, where there was another actor called “MARY” acting too.

Schema:

Consider a movie relational database schema description provided below which is used to manage a movie database, where:

A movie can have 0 or more actors

A movie can have 1 or more categories

A movie has 1 and only one language

Rating is one of these values: 'G','PG','PG-13','R','NC-17'

People can comment about the movies on a webpage, and the comments are stored in the comments table. The reviewer_name is introduced by the person on each comment, so we don't have a table with “reviewers”. A reviewer can create any number of comments about a movie. The comments will have a score about the movie with values from 0 to 100.

Note, the last update fields are going to be stored as a “timestamp”.

IMPORTANT: 2 entries in the same relation can have the same lastupdate, so, for example, 2 movies can have the same lastupdate value.

The relations are:

ACTOR (actor_id, first_name, last_name, last_update)

LANGUAGE (language_id, name, last_update)

CATEGORY (category_id, name, last_update)

FILM (film_id, title, description, release_year, language_id, length, rating, last_update)

FILM_ACTOR(actor_id, film_id, last_update)

FILM_CATEGORY (film_id, category_id, last_update)

COMMENTS (review_id, film_id, reviewer_name, comment, score, last_update)

Suppose that a software development team released an update to one of their mobile applications after receiving complaints about the previous version from 9.4% of their customers. A few weeks after the update was released, the development team wanted to know if fewer customers had complaints. The team selected a random sample of 325 customers and found that 21 of them submitted complaints about the application after the update was released.

The team wants to use a one‑sample  z ‑test for a population proportion to see if the proportion of customers with complaints,  p, has decreased since they released the update. For this test, they plan to use a significance level of  α=0.05 .

Determine the value of the z ‑test statistic. Give your answer precise to at least three decimal places

z =

Determine the critical value, Zα , for this test. Give your answer precise to at least three decimal places

Za =

Graham manufactures and sells hiking and camping equipment. The business started trading on 1 January 2018 and purchased the following assets: Plant and machinery €80,000 Motor vehicles €24,000 Graham decides to depreciate plant and machinery on the straight-line basis, expecting it to have a useful life of five years and a residual value of €5,000 at the end of that time. Motor vehicles will be depreciated on the reducing-balance basis at the rate of 30% per annum.

1. What is the depreciation expense shown in the statement of profit or loss for the year ended 31 December 2018:

Depreciation expense: Plant and machinery? Motor vehicles? Total depreciation expense?

2. What is the total net book value of non-current assets in the statement of financial position as at 31 December 2018?

1.Create a Database in Access with the information

The database must include:

Database name: Monaco Enterprise  Mark Johnson #87451

Table name: Contacts

Delete the Primary key.

Fields name and data type are (remember to choose the data type):

2.Go to the “Datasheet View” and enter the data. * Remember to save the table.

3.Move the last name field after the employee name.

4.The (data) records are:

Employee ID: 1235

Rivera, Elena

No Work

Employee ID: 2230

Santiago, Paola

Yes Work

Employee ID: 1080

Cintrón, Carlos

No work

Employee ID: 2654

Santos, Roberto

Yes Work

Employee ID: 1274

Torres, Leonela

Yes Work

Employee ID: 6952

Burgos, Catalina

No Work

Employee ID: 2410

González, Yarelis

No Work

Employee ID: 4239

Pagán, Anahí

Yes Work

Employee ID: 2290

García, Luisa

No Work

Employee ID: 0063

Johnson, Mark

No Work

QUESTION 1 40 MARKS

PCA Ltd declared bankruptcy in June 2020 soon after publishing the financial statements for the year ended December 2019. PCA Ltd’s financial information for 2016 through 2018 are presented below.

A 9.106 gram sample of an organic compound containing C, H and O is analyzed by combustion analysis and 18.19 grams of CO₂ and 7.449 grams of H₂O are produced.

In a separate experiment, the molar mass is found to be 88.11 g/mol. Determine the empirical formula and the molecular formula of the organic compound.
What is the empirical formula?

When 5.895 grams of a hydrocarbon, C_xH_y, were burned in a combustion analysis apparatus, 18.50 grams of CO₂and 7.574 grams of H₂O were produced.

In a separate experiment, the molar mass of the compound was found to be 42.08 g/mol. Determine the empirical formula and the molecular formula of the hydrocarbon.

Empirical formula?

Molecular formula?

In you own words explain what relationship database is. Discuss the benefits of using relationship database for improving workflow and efficiency of business decision-making processes.