Use the following information to answer the next Two questions :

Sunny Company had the following comparative balance sheet information for 2018, 2017:
Sunny reported net income for 2018, of $18,000 Depreciation expense in 2018 was $2,000. Not long-term assets were sold during the year.

refer to the innformation above: Under method calculate Sunny's positive or negative Cash flow statement from changes in Accountss payable for 2018.
a. $200
b. $-2000
c. $3000
d. $-3000

Refer to the information above, Under the indirect method , caluclate Sunny positive or negative Cash Flow statement changes Inventory for 2018:
a. $1000
b. $-1000
c. $-2000
d. $2000

Which of the following true regarding the statement of cash flows?
a. The statement summarizes cash flows for a period of time.
b. THe statement explains the changes in the cash flows for a period of time.
c. Both a,b true.
d. Bothe are wrong.

Which of the following would be reported as financing activity on the statement of cash flows?
a. Changes in Long-term liabilites.
b. Changes in Current liabilites.
b. Net income
d. changes in (Gross) Long-term Assets.

US Tax Question

Chuck is single and retired at 65 years old in march of 2018, for the year of 2018 he received the following sources of income:

Salary 14000

interest income 2000

divident income 1000

tax exempt income 1000

social security benefits 5000

net rental income 6000

What is Chucks modified adjusted gross income? what amaount if any, of his social security benefits must he include in his 2018 gross income? what is Chucks taxable income for 2018?

Samos was a greek living about 300 bc. what scientific model did he develop? who developed the same idea nearly 2000 years later? why is this considered a period of non-progressive science.

1. Which of the following is a database client software?

1. Microsoft SQL Server 2017 Developer
2. Microsoft SQL Server Management Studio
3. Microsoft SQL Server Configuration Manager
4. SQL Server Analysis Service

2. Compared to Data Warehousing approach, the following are disadvantages of query-driven data integration approach, EXCEPT: __________.

1. competition with local processing at source
2. delay in query processing
3. waste of storage space
4. inefficient and potentially expensive for frequent queries

3. What does OLAP stand for?

1. Olympic Linear Algebra Problem
2. On-Line Amazon Platform
3. On-Line Analytical Processing
4. One Lazy Associate Professor

4. In order to login to a non-local database server (i.e., use computer A to login to database hosted on computer B), what information is NOT required?

1. username
2. password
3. IP address of the database server
4. Number of tables in the database

5. Which of the following is a WRONG statement?

1. If you stop your t3-medium EC2 instance whenever you don’t use it, you can save money.
2. If you terminate your EC 2 instance, everything inside your instance is also deleted.
3. If you stop your EC2 instance during installation of some software, the installation will fail.
4. If you close your remote desktop connection (or SSH) to EC2 instance, any ongoing process (e.g., installing software, running SQL queries) inside EC2 is interrupted.

6. Which of the following database roles has the highest privileges?

1. db_datareader
2. db_datawriter
3. db_securityadmin
4. db_owner

7. The attribute "Price" in the Sensor table is a/an _________ attribute.

1. int
2. float
3. varchar
4. datetime

Requirements. A television channel has decided to create a simple database to register
payment information about its most successful show ‘TheVoiceLondon’.

In this show, there are contenders that compete to represent the UK in Eurovision.
These contenders are coached by famous artists (namely the coaches). Contenders can
be formed by a group of participants or a single participant. Both coaches and
participants are paid based on the number of shows they attend.

For each coach and participant, the database stores their id, name, surname, date of
birth, phone, gender and daily salary.   

For each contender, the database stores its id, type (group or individual), stage name, its
coach and the participants forming that contender. Each contender should have at least
one participant.

For each show, the database stores its date, start time, end time and a location if the
show does not take place in the television studio.

Finally, the database also registers which coaches and contenders attended each show.

If a coach decides to leave the program, then their personal and attendance information
must be deleted from the database and any contenders they coach need to be assigned a
replacement coach.

The following relational schema contains the database model for this TV show. In the
relational schema below, primary and foreign keys are not given to you.
Implementation
(2.1) Create and implement an ER model in appropriate SQL schema and table creation
queries, including entities, relationships and constraints.
(2.2) Insert appropriate sample data using INSERT queries.
(2.3) Create and output the appropriate SELECT queries.
(2.4) Update data using the appropriate UPDATE query.
(2.5) Remove data using a DELETE query.
2.1 Schema Definition. Based on the both the requirements above, and the keys
you have identified, write the required SQL DDL (Data Definition Language)
statements (i.e. CREATE TABLE…) to create the schema and corresponding
tables.

Ensure that:
• table and attribute names do not conflict with SQL reserved words
• attribute data types are core primitive SQL data types as described in the
lectures (i.e. do not use the ENUM type for example)
• table columns have appropriate key and entity constraints properties
• every table has a primary key specified as it corresponds to your relational
model
• all foreign keys are properly declared, and explicitly describe how they handle
potential referential integrity constraint violations (i.e. it is up to you to decide
the triggered action to the foreign key constraints)
• your schema enforces the domain and semantic constraints stated in the
requirements.

Note that you may not be able to enforce all the semantic domain constraints in
the CREATE TABLE statements and MySQL does not have Assertions in the
manner that we discussed in lecture (i.e. using CREATE ASSERTION). If you are
unable to enforce a semantic domain constraint include a comment in your
schema explaining your constraint and the reason it is not implemented.

Write your schema in the provided template file: schema.sql

Assume that the database schema will already be created for you (i.e. do not
include a CREATE SCHEMA statement in your file, it will result in an error).
Also assume that your script will already be run within your database schema
(i.e. do not include a USE…; statement in your file, it will result in an error).

2.2 Populate Database with data. Time to get creative! Populate your
database with some data that you will come up with on your own. Since you
only require a small test sample of data, you will use SQL INSERT statements
to populate your database.

More precisely:
• Pick at least 3 of your favourite celebrities to include as Coaches. Make
up their personal data. If you don’t really care for celebrity culture, then
pick 3 random people to include as Coaches.
• Create at least 10 participants.
• Create at least 5 contenders and assign them participants, so that there
is one group contender.
• Assign these contenders to the different coaches, making sure that
there is at least one coach without contenders.
• Create shows taking place all Saturdays and Sundays in March and
April 2019. The shows can start at any time you want but must have a
duration of 2 hours. Note that not all shows can have the same start and
end times.
• For each show create at least 3 attendances of contenders and 2
attendances of coaches.

Write INSERT statements in the provided template file: insert.sql

You may only use the DML (Data Manipulation Language) commands
covered in lecture to help you populate your database.

All data must be contained within the insert.sql file, do not load the data
from separate data files (i.e. using a CSV file).

Do not use other SQL statements, such as FUNCTIONs, PROCEDURESs or
other programmatic MySQL-specific commands.

Assume that your script will already be run within your database schema (i.e.
do not include a USE…; statement in your file, it will result in an error).

2.3 Query the Data. Write the SELECT statements that to obtain the following
queries:

• Average Female Salary. TheVoiceLondon would like to know the
average daily salary for female participants. Write a SELECT query that
gives the average daily salary for female participants. Have your result
return a single scalar value (i.e. in total GBP).

• Coaching Report. For each coach, list the total number of contenders
they are coaching. In the listing, include the information about the
coaches without any contender.

• Coach Monthly Attendance Report. For each coach, list the total number
of shows attended in each month.   

• Most Expensive Contender. TheVoiceLondon would like to know which
contender has the highest total daily salary (i.e., sum of the daily salaries
of the participants forming that contender). Write a SELECT query that
lists the stage name of the contender with the highest total daily salary.

• March Payment Report. Create an itemized payment report for March
corresponding to the shows attended by each coach and participant in
March. Write a SELECT statement(s) that retrieves:

• For each coach, show their name, the number of shows attended in
March, their daily salary and their total salary for March
(calculated as the number of shows attended multiplied by their
daily salary).
• For each participant, show their name, the number of shows
attended in March, their daily salary and their total salary for
March.
• The last line of the report should just contain the total amount to
be paid in March.
  • Well Formed Groups! Note group contenders should be formed by more
than one participant (otherwise they are individual contenders).

Since MySQL does not support an assertion to check this constraint, write
a SELECT statement that returns only a scalar Boolean value (i.e. either
True or False). It should return True if there are no violations in the
database of this regulation. If there is a violation, then the SELECT
statement should return False.

There is a violation if there is a group contender formed by less than 2
participants.   

Show that your SELECT statement works by creating a group contender
that violates this rule and then running your SELECT statement.

Write all of these SELECT statements in the above order in the provided
template file: select.sql

Assume that your script will already be run within your database schema (i.e.
do not include a USE…; statement in your file, it will result in an error).

2.4 One more thing… To avoid that coaches and contenders arrive late to the
shows, TheVoiceLondon has decided to change to hourly payments instead of
daily payments:

1. Update the coach and participant information to only contain the hourly
payment. Given that the shows have a duration of 2 hours and that
coaches and participants were required to arrive one hour before the
show and to leave one hour after the show, the hourly payment should be
calculated as the daily payment divided by 4.
2. Add new fields to the attendance table to register when coaches and
contenders arrive to and leave the shows.
3. UPDATE the attendance information to include the arrival and departure
times for the past shows. Your query should set the arrival time to one
hour before the show started and the departure time to one hour after the
end time.

Write all these statements in the provided template file: update.sql

Assume that your script will already be run within your database schema (i.e.
do not include a USE…; statement in your file, it will result in an error).

2.5 Fair payment! The contender with the lower total salary became upset and
wants to leave TheVoiceLondon. The participants forming that contender
have demanded to have all their contender and personal data removed
from TheVoiceLondon database.   

Using this contender stage name as its identifying attribute in the query,
write the DELETE statement(s) that removes this contender and all their
related data from the database. To avoid any future embarrassment in case
of a data leak, make sure you also remove all trace of the participants forming
that contender from the database.

Write all of these DELETE statements in the provided template file:
delete.sql

Assume that your script will already be run within your database schema (i.e.
do not include a USE…; statement in your file, it will result in an error).

PROGRAM LANGUAGE IN C NOT C# or C++

KEEP IT SIMPLE EVEN IF IT IS REDUNDANT PLEASE.

Problem: Driving

Function driving():

Write a function driving(), that updates the odometer and fuel gauge of a car. The function will take in a reference to the variables storing the odometer and fuel gauge readings, along with a double representing the miles per gallon (mpg) the car gets and the number of miles the driver intends to go. The function should update the odometer and fuel gauge readings, accordingly. If the number of miles is greater than the user can go with the fuel he has left, then simply have the car drive until empty and update the odometer accordingly. The prototype for the function is below:

void driving(double* odomPtr, double* fuelPtr, double mpg, double distance);

Note that, you are not allowed to change the prototype of the function.

The return type of the function has to be void.

Also, there should not be any printf() in the the driving function.

main function:

In the main function, at first take the odometer reading, fuel gauge reading, and miles per gallon (mpg) as input.

Then keep taking distance to drive as input until the fuel gauge indicates 0 fuel. After taking the distance to drive, call the driving function with the proper parameters to get update about odometer and fuel and display the update. Display them up to two decimal places.

At the end display the message "No more fuel!"

Sample Input/Output 1:

Enter odometer reading, fuel gauge reading and mpg: 8000 13.5 25

Enter the distance you want to drive: 200

Current reading Odometer = 8200.00, fuel = 5.50

Enter the distance you want to drive: 100

Current reading Odometer = 8300.00, fuel = 1.50

Enter the distance you want to drive: 500

Current reading Odometer = 8337.50, fuel = 0.00

No more fuel!

Sample Input/output 2:

Enter odometer reading, fuel gauge reading and mpg: 90000 2.5 13.5

Enter the distance you want to drive: 500

Current reading Odometer = 90033.75, fuel = 0.00

No more fuel!

Rubric: 3 points

Writing the function with the specification: 1.5 points [changing the specification will result in 0]

Writing the main function with the specification: 1.5 points

Penalty:

Not passing each test case: -0.75 (total -1.5 for 2 test cases)

Bad indented code: -0.75

Explain what is meant by the phrase “the genetic code is redundant and nearly universal,” and state its significance to evolutionary biology.

Brief Exercise 10-15           PPE disposal

Stellar Corporation owns machinery that cost $28,400 when purchased on July 1, 2014. Depreciation has been recorded at a rate of $3,408 per year. The machinery is sold on September 30, 2019 for $7,384.

Prepare journal entries to (a) update depreciation for 2018 and (b) record the sale.

Ice cream and coins. This problem tests your understanding of the multiplication rule. Round these answers to 5 decimal places.
The Acme Company manufactures widgets. The distribution of widget weights is bell-shaped. The widget weights have a mean of 65 ounces and a standard deviation of 11 ounces.

Use the Empirical Rule, also known as the 68-95-99.7 Rule. Do not use Tables or Technology to avoid rounding errors.

Suggestion: sketch the distribution in order to answer these questions.

The following data give the average price received by fishermen for several species of fish in 2000 and 2010. The price is in cents per pound.

1. Create a regression equation for the data.
   
   ˆy=y^= Round to 2 decimal places.
   
2. What is the correlation coefficient between the 2000 and 2010 prices.
   
   Round to 2 decimal places.
   
3. If a type of fish was 41.3 cents per pound in 2000, how much would you expect to pay for it in 2010?
   
   ¢/lbs Round to 1 decimal places.

In Brazil, the reference base period for the CPI is 2000.

By 2016, prices had risen by 187 percent since the base period. The inflation rate in Brazil in 2017 was 3.4 percent, and in 2018, the inflation rate was 3.7 percent.

Calculate the CPI in Brazil in 2017 and 2018. Brazil's CPI in 2019 was 318. Did Brazil's cost of living increase or decrease in 2019?

The CPI in Brazil for 2017 is __.

The CPI in Brazil for 2018 is __.

Did Brazil's cost of living increase or decrease.