Pixie, Inc. began 2018 with the following balances in deferred tax accounts:Deferred Tax AssetsDTA -Valuation AllowanceDeferred Tax Liabilities$180,000 (DR)$10,000 (CR)$120,000 (CR)The deferred tax asset resulted from $600,000 of unearned revenue that was received in 2017, but will be earned for financial reporting purposes evenly across the next three years (2018, 2019, and 2020). The deferred tax liability resulted from the financial accounting bases of depreciable assets exceeding the tax bases of depreciable assets by $400,000 due to excess MACRS depreciation over straight-line in previous years. Pre-tax accounting income in 2018and 2019is $280,000 and $300,000, respectively and includes non-taxable municipal bond interest of $80,000 in both 2018and 2019. During 2018MACRS (tax) depreciation exceeded straight-line (financial) depreciation by $110,000. In2019, the timing difference related to depreciation began to reverse in that MACRS depreciation was $70,000 less than straight-line depreciation. In2018, Pixie recognized $80,000 in installment revenue as part of pretax financial accounting income, but the money will not be received and taxable until 2019. Pixie also incurred a $40,000 fine in 2018for an EPA violation which was recognized as an expense for financial reporting purposes. At the end of 2018, management estimated that the DTA –Valuation Allowance account should have a balance of 10% of the Deferred Tax Asset balance. Pixie management decided that at the end of 2019, the valuation allowance should be 5% of the Deferred Tax Asset balance.The tax rate was 30% for 2017and 2018, but during 2018Congress changed the applicable tax rate to 21% for 2019and all subsequent years. In the event of a net operating loss, use the new tax rule under the TCJA related to NOLs: NOL carry forward and 80% limitation.
Required:
(a)Calculate taxable income for 2018and 2019.
(b)Calculate the balances in Deferred Tax Asset, Deferred Tax Liabilities, and DTA -Valuation Allowance as of 12/31/18and 12/31/19.
(c)Determine Income Tax Expense or Benefit for 2018and 2019.
(d)Record the journal entries for income tax recognition that would be made as of the end of 2018and 2019.
(e)Calculate the effective tax rates for 2018and 2019.
(f)Prepare the bottom of the income statement for Pixie just for 2018, beginning with ‘Income before Income Taxes’ –you do not need to separate income tax expense or benefit into current and non-current portions.

. The Balance sheet reveals the firm's assets, liabilities and owners' equity (net worth). But the cash position of the company also forms a very prominent position in order to know the liquidity of the company. The balance sheet items (in OMR) are taken from Magrib Ltd. for the years 2018 and 2019 respectively:

Additional Information

Interest paid on long term loan was RO1950 during the year

Depreciation on the non-current Asset was RO 7440

Building with a book value of RO11,580 was sold for a loss of RO1400 during the year

1. From the above Balance sheet items, you are required to calculate: a) Profit before Interest and Tax and prepare b) Cash flow statement for the year 2019
2. In Cash flow statement, certain items are added and certain items are deducted. From the Cash flow statement, you have prepared, comment on the reasons for adding or deducting those items.

QUESTION

Lemonade Bhd , a manufacturing company was incorporated two years ago. The following is the statement of financial position of the company as at 31 December 2018.

Lemonade Bhd

Statement of financial position as at 31 December 2018

During the year ended, the company resolved the following matters

1. Bonus issue of one ordinary shares for every ten-share held were given to the shareholder.

2. On 1^st February the company issued 30,000,000 Ordinary shares at RM1.80. The application received were oversubscribed by 5,000,000 units. The applications monies in respect of the unsuccessful applications were returned to the applicants.

3. The company also issued additional 2,000,000 unit of 7% Preference shares at RM 4 each. The shares undersubscribed by half.

4. On 1^st April 2019, 8% Debentures RM500,000 were issued . The effective interest rate is 9% and the issuance cost incurred is RM10, 000. The company decided to use amortised cost method in recognising the debentures.

5. Investment costing RM600, 000 was sold at a gain of RM15, 000.

Required:

1. Show journal entries to record the above transactions.

2. Prepare updated statement of financial position as at 31 December 2019.

Lemonade Bhd , a manufacturing company was incorporated two years ago. The following is the statement of financial position of the company as at 31 December 2018.

Lemonade Bhd

Statement of financial position as at 31 December 2018

During the year ended, the company resolved the following matters

1. Bonus issue of one ordinary shares for every ten-share held were given to the shareholder.
2. On 1^st February the company issued 30,000,000 Ordinary shares at RM1.80. The application received were oversubscribed by 5,000,000 units. The applications monies in respect of the unsuccessful applications were returned to the applicants.
3. The company also issued additional 2,000,000 unit of 7% Preference shares at RM 4 each. The shares undersubscribed by half.
4. On 1^st April 2019, 8% Debentures RM500,000 were issued . The effective interest rate is 9% and the issuance cost incurred is RM10, 000. The company decided to use amortised cost method in recognising the debentures.
5. Investment costing RM600, 000 was sold at a gain of RM15, 000.

Required:

1. Show journal entries to record the above transactions.
2. Prepare updated statement of financial position as at 31 December 2019.

Data Structures

Use good style. Make sure that you properly separate code into .h/.cpp files. Make sure that you add preprocessor guards to the .h files to allow multiple #includes.

Overview

You will be writing the classes Grade and GradeCollection. You will be writing testing code for the Grade and GradeCollection classes.

Part 1 – Create a Grade Class

Write a class named Grade to store grade information.

Grade Class Specifications

1. Include member variables for name (string), score (double).
2. Write a default constructor.
3. Write a constructor that takes values for all member variables as parameters.
4. Write a copy constructor.
5. Implement Get/Set methods for all member variables.
6. Add a member overload for the assignment operator.
7. Add a non-member operator<< overload. Prints the values of all member variables on the given ostream.  

Part 2 – Create a GradeCollection Class

Write a class that will store a collection of Grade. This class will be used to keep track of data for multiple grades. You MUST implement ALL of the specifications below.

GradeCollection Class Specifications

1. Create a private member variable that is an array of Grade. The size of the array can be whatever you want it to be.
2. Your class must implement all of the following functions (use the given function prototypes):
   1. Create a default constructor that will initialize all elements of the array to default values.
   2. void Set(int index, Grade g) – Sets the value at the given index to the given Grade. You should test the index to make sure that it is valid. If the index is not valid then do not set the value.
   3. Grade Get(int index) – Return the Grade located at element index of the array.
   4. int GradeCount(double lowerBound, double upperBound) – Returns the count of the number of grades in the given range. For example, assume the following scores: 60, 70, 65, 75, 80, 90

If lowerBound is 70 and upperBound is 80 then the returned value should be 3. Any values that fall on the boundaries should be included in the count.

5. Grade LowestGrade() – Returns the grade with the lowest score in the array.
6. bool FindGrade(string name, Grade &g) – Returns true if the grade with the given name is in the array and false otherwise. If the grade is in the array you should copy it into the Grade reference parameter.
7. double GradeAverage() – Returns the average of all the grades in the collection
8. int Size() – Returns the size of the array.
9. void Initialize() – Initializes all of the elements of the array to reasonable default values.
10. string GetAuthor() – Returns your name. Just hard code your name into the function.

Part 3 – Main Function

In main you should create instances of the Grade and GradeCollection classes and demonstrate that ALL functions work properly on both classes. You can write unit testing code if you want but you are not required to. Make sure you call ALL functions.

Part 4 – Comments

In addition to the normal comments, EVERY function that gets updated because of the required changes should have an update comment added to the function commenting header. The update comment should have your name, the date of the change, and a short description of the change. For example:

//****************************************************

// Function: SetName

//

// Purpose: Sets the name of the grade.

//

// Update Information

// ------------------

//

// Name:

// Date: 9/20/2016

// Description: mName member variable was changed to a

//              pointer. Updated code so that it works //              with a pointer.

//

//****************************************************

Part 5 – Updated Grade and GradeCollection Classes

Grade Class Updates

The Grade class should implement all the specifications from the first assignment plus the updates and features listed below.

1. Change all member variables to pointers. You will need to update code in any functions that use these member variables. Do NOT change any function signatures for this class. For example, assume the get/set functions have the following signatures:

std::string GetName(); void SetName(std::string name);

These signatures should remain exactly the same. The same goes for any other functions that use these member variables. Only the internal implementation of the functions will change to accommodate the use of pointers.

2. Update the constructors. The constructors should allocate memory for the pointer member variables.
3. Add a destructor. The destructor should deallocate memory for the pointer member variables.
4. Update operator= and copy constructor. The operator= and copy constructor should be updated to perform deep copies.
5. Add a non-member operator>> overload. The >> operator is used for input. Reads the values of all member variables from the given istream.

GradeCollection Class Updates

The GradeCollection class should implement all the specifications from the first assignment plus the updates and features listed below.

1. Dynamic array. Change the internal implementation of the array so that the array is dynamically allocated.
2. Add a size member variable to the class. This member variable should ALWAYS contain the number of elements in the array (size of the array). Some functions may cause the size of the array to change so make sure that this member variable is updated to reflect the new size.
3. Update all the necessary code in the class so that it is usable with a dynamic array. One example of this is to change the ending condition of loops that visit all elements of the array should not be hard coded. They should use the new size variable as the ending condition.
4. Add a one parameter constructor that takes a size. This constructor should dynamically allocate an array of the given size. It should also set the size member variable to reflect the size.
5. Add a copy constructor. This function should make a deep copy of the passed in instance.
6. Add a destructor. This function should perform any necessary cleanup.
7. Add a member overload of operator= (assignment operator). This method should perform a deep copy of the passed in instance. After this function ends the size of the current instance’s array should be the same as the other instance’s array and all the data from the other instance should be copied into the current instance’s array. Hint: C++ arrays have a fixed size. You may need to delete and then reallocate memory for the current instance’s array in order to make the current instance’s array the same size as the other instance’s array. Be careful for memory leaks.
8. Add a non-member operator<< overload. Prints the values of all elements of the array on the given ostream.
9. Add a Resize function. Here is the function signature: void Resize(int newSize);

This function should create a new array that has the passed in size. You MUST retain any values that were previously in the array. The new array size can be larger or smaller. If the new array size is SMALLER just retain as many elements from the previous array that can fit.

Hint: C++ arrays have a fixed size. You may need to delete and then reallocate memory. Be careful for memory leaks.

10. Add a function named Clone with the following signature:

GradeCollection *Clone();

This function should allocate a new dynamic instance of GradeCollection that is a deep copy of the current instance. This method should return a pointer to the new instance.

Hint: Any function that calls Clone is responsible for releasing the returned memory address.

Part 6 – Main Function

In main you should create instances of the updated Grade and GradeCollection classes and demonstrate that ALL functions work properly. You can write unit testing code if you want but you are not required to. Make sure you call ALL functions.

You program should not have memory leaks.

Two aeroplanes with the same specification each that has an engine rotates at 2000 rpm with the moment of inertia for all rotating parts is 420 (kg)(m^2). The engine rotates anti-clockwise when viewed from the front. One of the aeroplanes turn to the left and the other turn to the right. Compare the magnitude and effect of the gyroscopic action resulting on the plane if the turning radius is 2000 m at a speed of 2000 km/h.

A. Project 1 case: DDL’s and Business Rules - The SQL queries for this project are based on the business rules from PROJECT 1. Thus, the SQL queries will run against the tables from Project 1 (see section B below). The following is a list of the business rules derived from the Project 1 assignment:

- A university is identified by its name and located in a particular city.

- A university has many researchers, each of whom can only be associated with only one university.

- A researcher is identified by an identification number, and has a name, phone, and email address.

- A researcher can attend many conferences.

- A conference is identified by an identification number; it also has a name, a location, and a date.

- For each conference, a researcher may or may not present a scientific research paper.

- For each conference, one university is in-charge of its logistic, while another university is in-charge of its marketing.

- A university can be involved in either role with any conference.

B. Run the following DDL’s and add your own data rows to the tables

CREATE TABLE `university` (

`UNIVERSITY_ID` int(11) NOT NULL,

`UNIVERSITY_NAME` varchar(45) DEFAULT NULL,

`UNIVERSITY_CITY` varchar(45) DEFAULT NULL,

`UNIVERSITY_STATE` varchar(2) DEFAULT NULL,

PRIMARY KEY (`UNIVERSITY_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `conference` (

`CONFERENCE_ID` int(11) NOT NULL,

`CONFERENCE_NAME` varchar(45) DEFAULT NULL,

`CONFERENCE_CITY` varchar(45) DEFAULT NULL,

`CONFERENCE_DATE` date DEFAULT NULL,

`UNIVERSITY_ID_LOGISTICS` int(11) NOT NULL,

`UNIVERSITY_ID_MARKETING` int(11) NOT NULL,

`CONFERENCE_STATE` varchar(2) DEFAULT NULL,

PRIMARY KEY (`CONFERENCE_ID`,`UNIVERSITY_ID_LOGISTICS`,`UNIVERSITY_ID_MARKETING`),

KEY `fk_CONFERENCE_UNIVERSITY1_idx` (`UNIVERSITY_ID_LOGISTICS`),

KEY `fk_CONFERENCE_UNIVERSITY2_idx` (`UNIVERSITY_ID_MARKETING`),

CONSTRAINT `fk_CONFERENCE_UNIVERSITY1` FOREIGN KEY (`UNIVERSITY_ID_LOGISTICS`) REFERENCES `university` (`UNIVERSITY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `fk_CONFERENCE_UNIVERSITY2` FOREIGN KEY (`UNIVERSITY_ID_MARKETING`) REFERENCES `university` (`UNIVERSITY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `researcher` (

`researcher_id` int(11) NOT NULL,

`res_lname` varchar(45) DEFAULT NULL,

`res_fname` varchar(45) DEFAULT NULL,

`res_title` varchar(45) DEFAULT NULL,

`university_UNIVERSITY_ID` int(11) NOT NULL,

PRIMARY KEY (`researcher_id`,`university_UNIVERSITY_ID`),

KEY `fk_researcher_university1_idx` (`university_UNIVERSITY_ID`),

CONSTRAINT `fk_researcher_university1` FOREIGN KEY (`university_UNIVERSITY_ID`) REFERENCES `university` (`UNIVERSITY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `conference_has_researcher` (

`CONFERENCE_CONFERENCE_ID` int(11) NOT NULL,

`RESEARCHER_RESEARCHER_ID` int(11) NOT NULL,

PRIMARY KEY (`CONFERENCE_CONFERENCE_ID`,`RESEARCHER_RESEARCHER_ID`),

KEY `fk_CONFERENCE_has_RESEARCHER_RESEARCHER1_idx` (`RESEARCHER_RESEARCHER_ID`),

KEY `fk_CONFERENCE_has_RESEARCHER_CONFERENCE_idx` (`CONFERENCE_CONFERENCE_ID`),

CONSTRAINT `fk_CONFERENCE_has_RESEARCHER_CONFERENCE` FOREIGN KEY (`CONFERENCE_CONFERENCE_ID`) REFERENCES `conference` (`CONFERENCE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `fk_CONFERENCE_has_RESEARCHER_RESEARCHER1` FOREIGN KEY (`RESEARCHER_RESEARCHER_ID`) REFERENCES `researcher` (`researcher_id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

C. Data Queries   “Good questions to ask of your data” – The business rules from section A above were used to derive the following 10 query descriptions below. Read each description and write the equivalent SQL query.

1. List the universities sorted by city.

2. List the Researchers sorted by last name.

3. List the researchers and their corresponding universities sorted by the university city. You must use an INNER JOIN with RESEARCHER and UNIVERSITY tables.

4. List the university and “count” of researchers at each university sorted by the university name.

You CANNOT use an inner join. You must use a subquery with RESEARCHER.

5. List the university and “count” of researchers at each university where there is more than 1 researcher. Also, sort this query by the university name. You must user an INNER JOIN (NOT A SUBQUERY)

6. List all conferences in the state of georgia. Include the city and state with the query.

7. List the conference and researcher count for conferences in georgia. You CANNOT use an inner join. You must use “two” subqueries that are nested.

8. List the researcher, university and conferences where the conference is in California. You must user an INNER JOIN (NOT A SUBQUERY).

9. List the university and count of researchers that are planning to present at a conference in 2021. You CANNOT use an inner join. You must use a subquery.

10. List the Universities in the database table. If the university appears in a conference that is in charge of its marketing. Each university can only be listed once. You must user an OUTER JOIN (NO INNER JOIN OR SUBQUERY).

I have part A completed. I am stuck on part C mostly, but help on part B would be greatly appreciated.

what is super key,  candidate key, and primary key, and foreign key in terms of database? and plz provide some examples, thanks.

Using PHP and MYSQL and with a simple customer database, how can I create a simple log in and registration system for an ecommerce site

Describe the structure of codification. Codification of accounting standards reduces the time and effort of researching the vast database of GAAP. Do you agree?