Question 1

A Japanese firm manufactures cars in the US. Assume that each car sells for $20,000 to a consumer in the US. Also assume that on each car the Japanese manufacturer earns $2000 in profits and remits those to the holding company in Japan. Assume that the car is manufactured with US made parts only.

What is the contribution of each car to the US GNP?

1. $ 18,000
2. $20,000
3. $22,000
4. $2,000

Question 2

A Japanese firm manufactures cars in the US. Assume that each car sells for $20,000 to a consumer in the US. Also assume that on each car the Japanese manufacturer earns $2000 in profits and remits those to the holding company in Japan. Assume that the car is manufactured with US made parts only.

What is the contribution of each car to the US GDP?

1. $20,000
2. $18,000
3. $22,000

Question 3

A nation that has been a net receipient of foreing investment is likely to have its GDP exceed its GNP.

1. True
2. False

Question 4

How would the following activity get counted in the GDP?

I purchase a used car from another individual (the car's current owner) for $2000. There are no other parties involved.

1. Since I am a consumer, the entire $2000 will count in the consumption spending of the GDP.
2. Since a car is a good that can be used for several years, the entire $2000 will count in the consumption spending component of the GDP
3. Since a car is an investment, the entire $2000 will count in the investment component of the GDP
4. Since this is a used car, none of the $2000 will count in the GDP.

Question 5

Consider the following scenario:

I purchase a used car from a used car dealer. The car's price is $2000. Out of that $2000, $400 constitutes the profits of the dealer. How would this trade enter the GDP?

1. The entire $2000 gets included in the consumption spending of the GDP.
2. Only the $400 dollar profit of the dealer will enter the GDP in the consumption account.
3. Only the $1600 difference will enter the GDP, the consumption account.
4. Nothing will enter into the GDP

Question 1: In the NCBI database, retrieve the nucleotide sequences NG011676. Report:

1. Gene name, database name.

2. Number of exons and its position (the start and the end of each exon).

3. The start and the end of coding region (CDS)

4. Accession number of protein from this gene and the length of polypeptide.

Question 2: Use NG011676 to run GenScan. Report the results and compare the results with information of this gene from Question 1.
Question 3: Use NG011676 to run FGENESH with selecting of Homo sapiens as organism specific gene-finding parameters. Report the results and compare the results with information of this gene from Question 1.

Consider the following database schema for a BOOKSTORE database:

• Books (bookid, title, author, year)
• Customers (customerid, name, email)
• Purchases (customerid, bookid, year)
• Reviews (customerid, bookid, rating)
• Pricing (bookid, format, price)

The Books relation stores information about books sold by the bookstore. Note that bookid is the primary key. An example tuple is as follows:

(105, 'JAVA PROGRAMMING', 'JOHN DOE', 2001)

The Customers relation stores information about the customers of the bookstore. Note that customerid is the primary key. An example tuple is as follows:

(210, 'JOHN SMITH', '[email protected]')

The Purchases relation stores information about the customer purchases of books. Note that customerid and bookid form the primary key. An example tuple is as follows:

(210, 105, 2002), indicating that 'JOHN SMITH' with customerid 210 purchased the 'JAVA PROGRAMMING' book with bookid 105 in the year 2002.

The Reviews relation stores information about the customer reviews/ratings of the books. The ratings field refers to the number of "stars" given to the book. Note that customerid and bookid form the primary key. An example tuple is as follows:

(210, 105, 3), indicating that 'JOHN SMITH' with customerid 210 gave a 3-star rating to the 'JAVA PROGRAMMING' book with bookid 105.

The Pricing relation stores information about the price of the various books sold by the bookstore. Note that the same book can be available in multiple formats at possibly different prices. The price field refers to the number of dollars. For instance a $25 purchase will have a price field of 25. Note that the bookid and format fields form the primary key for the relation. An example tuple is as follows:

(105, 'AUDIO', 25), indicating that the 'JAVA PROGRAMMING' book with bookid 105 is available in the audio format for $25.

Given the above schema, write queries for the following:

1. Find books (show their titles) written by 'EDMUND MORGAN' since year 1990.
2. Find books (show their titles, authors and prices) that are on 'CIVIL WAR' (i.e., the title field contains 'CIVIL WAR'), available in 'AUDIO' format.
3. For each year, 'JOHN CHAMBERS' purchased at least one book, find the number of books purchased. That is, the output should be a set of tuples, each indicating a year and the number of books purchased by 'JOHN CHAMBERS' in that year.
4. Find customers (show their names and email addresses) who purchased more than one book in year 2003.
5. Find the ratings information (show titles, authors and average ratings) for books on 'CIVIL WAR' (i.e., title contains 'CIVIL WAR').

mySQL database question.. I have a database that has the following tables:

User (Id, Name, Gender) Primary key = Id

Friends (Id1, Id2, Startdate) Primary key = (Id1, Id2) Foreign keys are also Id1, Id2 pointing to User(Id)

Comments (CommentId, Poster, Recipient, Text, PostDate) Primary key = (CommentId) Foreign Keys are Poster, Recipient pointing to User(Id)

I need to answer the following queries:

5. List Users who have posted comments to all female users

6. List User(s) who have received comments from the most number of users

When finding users, all I need to list is the Id of the user.

What were the major causes of U.S. mortality in the last 100 years, and what public health measures most contributed to improvements in the health of the nation? Include at least two source citations from the readings and/or additional sources to support your answer.

*Industrial economics* Select a firm or industry (AMAZON) and use the theory of market structure to carry out an analysis of the strategic behavior of that firm or industry. As part of the answer, consider the strengths and weaknesses of the theory used. - *WORD COUNT - 650* - *INCLUDE REFERENCES AND CITATIONS*

What were the major causes of U.S. mortality in the last 100 years, and what public health measures most contributed to improvements in the health of the nation? Include at least two source citations from the readings and/or additional sources to support your answer.

RESEARCH LITERATURE REVIEW.

1. THE EFFECTS OF TAX EVASION ON ECONOMIC GROWTH IN NAMIBIA.

NB. PLEASE PROVIDE A COMPREHENSIVE LITERATURE REVIEW BASED ON THE ABOVE TOPIC, ONE FULL PAGE REVIEW WITH REFERENCE INCLUDING CITATIONS AS PER THE APA REFERNCE STYLE.