CMIS 320 Project 1
Write a justification paper, of at least 2 pages, to your boss explaining how a relational database solution can be applied to a current business problem or area for improvement. Assume that your boss knows nothing about relational database theory. The goal of this paper is to obtain your boss's approval to proceed with your stated project. Do not focus on technical aspects of a database management system. Focus on how the information will be captured, manipulated, managed, and shared, and the value the database brings to the organization. Include brief examples of how other industries (both domestic and international) have successfully used relational databases to increase efficiency.

Graham manufactures and sells hiking and camping equipment. The business started trading on 1 January 2018 and purchased the following assets:

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:

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

€

Please answer within 45 minutes maximum!

Which of the following statements in relation to GST adjustments is most correct? Select one:

1. If an entity registered for GST on a quarterly basis purchased an item for $8800 in the September 2018 quarter, the last adjustment period will be September 2023

. 2. If an entity which is registered for GST on a quarterly basis purchased an item for $2200 in the December 2018 quarter, the first adjustment period will be June 2019.

3. A decreasing adjustment under Division 129 means that extra GST is liable to be paid.

4. If you claimed a partial input tax credit to take into account some non-creditable use, then no adjustments are required to be made.

5. If an entity which is registered for GST on a quarterly basis purchased an item for $2200 in December 2018 quarter, the first adjustment period will be December 2020.

Boulder, Inc., obtained 90 percent of Rock Corporation on January 1, 2016. Annual amortization of $25,700 is applicable on the allocations of Rock's acquisition-date business fair value. On January 1, 2017, Rock acquired 75 percent of Stone Company's voting stock. Excess business fair-value amortization on this second acquisition amounted to $12,600 per year. For 2018, each of the three companies reported the following information accumulated by its separate accounting system. Separate operating income figures do not include any investment or dividend income.

1. What is consolidated net income for 2018?

2. How is 2018 consolidated net income distributed to the controlling and non-controlling interests?

You work for a small advertising agency in Greengrass, N.Y. The agency’s principal
advertising clients are automobile dealers and automobile repair shops. The agency has a good
record of placing advertisements for its clients in both real-space and on the internet.
Last week, you were considering buying a used car, and you found a web-site called
“CarValues.com.” The web site contains a database of information about used vehicles on the
market. The (searchable) database contains dealer-written factual descriptions of the make,
model, color and condition of the vehicle; the number of miles on the vehicle; how long the
vehicle has been on the market; and the price history of the vehicle (what it was originally
offered for, and any subsequent price reductions).
The web site was very helpful to you as a consumer. The data base also contained
information about past used-car sales in the area for the prior 6 months. The formatting on
CarValues.com was not good, and the interface was not user-friendly. You are confident the
developers who work for your company would have created a more user-friendly website.
When you got to work on Monday, a light bulb went on in your head. Why don’t we
create a car-selling website for our advertising clients? They would love it. All we need is a
database to start with. And one is available – right there on the internet, at CarValues.com. So,
you go back and check. There was no Terms of Use Agreement!!! Their data is right there for the
taking. Once we have the data, our company can update the information on our own going
forward without having to copy it from CarValues. But being able to use the CarValues
information would help us get started right away.
Your technician says he can capture all the existing data in minutes. Then your
organization can do the updating going forward as new cars come on the market and existing
ones are sold.
You mention your idea to, Carla Speil, the head of the agency at lunch. She is intrigued.
But is it legal? What are the potential consequences if CarValues.com finds out? ...She sees the
rewards.... But what are the risks? “Should we do it?,” she asks. Unusual for an advertising
executive, she seemed concerned about the ethics.
Write a one-page memo, Ms. Speil says, answering her questions.

AVL Group assignment

POST ANSWER IN JAVA PLS

Populate a tree via a text file (input.txt) Make sure that after every insert, the tree is balanced. At the end, display the tree in level format. Make sure to include the height and the balance factor of every node in your output. Redirect the display to an output file (output.txt)

Hint:

//I will not accept any other algorithm

//This is not a recursive algorithm

node * rebalance(node *node){

    node->height = max(height(node->left), height(node->right)) + 1;   

    int balance = getBalance(node); //node->left - node->right

    /*do rotations as necessary

      If Left heavy outside : return rightRotate(node);

      If right heavy outside: return leftRotate(node);

      If left heavy inside: left rotation first, right rotation 2nd, return top node

                        node->left = leftRotate(node->left);

                        return rightRotate(node);      

     if right heavy inside: right rotation first, left rotation 2nd, return top node

                        node->right = rightRotate(node->right);

            return leftRotate(node);

     if no rotation, return node  

   */

}

//non-tail recursive algorithm because of rebalance

node* insert(node* node, int key)

{

    //recursive Code for inserting a node

    //When insert happens set height to 0 for the node    

    if (node == NULL)

        return(newNode(key));

    if (key < node->key)

        node->left = insert(node->left, key);

    else

        node->right = insert(node->right, key);

    node=rebalance(node); //update heights and rebalance

    return node;

}

node *leftRotate(node *x){

   struct node *y=x->right;

   //add more code to rotate to the left, update heights for x and y

   //return y

}

node *rightRotate(node *x){

   struct node *y=x->left;

   //add more code to rotate to the right, update heights for x and y

   //return y

}

POST ANSWER IN JAVA PLS

Please use APA style for all aspects of this question. You must cite all course materials in-text; improper or missing citations will receive a zero grade and/or a formal investigation of academic misconduct. You are not allowed to use internet materials, quotations from outside readings or any “cut and paste” learning materials in any of your written answers. Write in your words only and draw on required course materials only.

1. Proponents of globalization like neoliberalists argue their approach to economic development can best lift countries out of poverty. Advocates of alternative theories and approaches like Bejing’s approach to economic development purported by Dambisa Moyo OR sustainable development are critical of neoliberalism. Define ONE alternative approach to economic development and explain ONE way it improves upon neoliberalism. Here, choose Bejing’s approach to economic development purported by Dambisa Moyo in her TED talk, Is China the New Idol for Emerging Economies? (Module 5) OR sustainable development (Module 6). For example, why does Dambisa Moyo think that Bejing’s approach to development is more appealing to poor countries than that of the United States? OR, why do proponents of sustainable development argue it is a superior approach to sustainable and equitable development than neoliberalism? Use specific empirical evidence and examples to demonstrate why the alternative approach is better.

Address Labeller Simple databases normally store address information as single line of data. In our database, fields are delimited by the percent sign '%' and can be placed in any order. Each field starts with a label "Street:", "City:", "State:", and "Zipcode:". Write an address labeller that extracts the fields from a database record entered by the user and prints a label if all fields are present. The program will report on any missing fields.

Sample runs: Enter an address database entry: State:New York%Street:12 Primrose Lane%Zipcode:11564%City:ValleyStream% 12 Primrose Lane ValleyStream, New York 11564

Enter an address database entry: Street:12 Primrose Lane%Zipcode:11564%State:New York%City:ValleyStream% 12 Primrose Lane ValleyStream, New York 11564

Enter an address database entry: Street:12 Primrose Lane%State:New York%City:ValleyStream% Error: Address does not contain zipcode

Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number, and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the entity set, as

• course with attributes name, department, and c-number

• section with attributes s-number and enrollment, and dependent as a weak entity set on course

• room with attributes r-number, capacity, and building
Design a relational database schema for this database application. First show all
the functional dependencies that should hold among the attributes. Then, design relation schemas for the database that are each in 3NF or BCNF. Specify the key attributes of each relation. Note any unspecified requirements, and make
appropriate assumptions to make the specification complete.
>>>MUST upload a word document or an image. Handwritten answers are acceptable.

Question 1 – Inserting data to the CITY table

Using the following DML statement:

INSERT INTO CITY (id, name, countrycode, district, population) VALUES (7000, ‘Guelph’, ‘CAN’, ‘Ontario’, 131794);

Query the CITY table to ensure this row was inserted correctly.

Provide screenshot of your ‘SELECT statement’ and resultset pane here

               Insert another row into the CITY table with the following values:

                              Id                           7002

                              Name                   Montebello

                              Countrycode       CAN

                              District                 Quebec

                              Population          983

Provide screenshot of your ‘INSERT statement’ and resultset pane here

Question 2 – Insert data to COUNTRY table

               Insert a row into the COUNTRY table with the following values:

                              Code                     SRB

                              Name                   Serbia

                              Continent            Europe

                              Region                 Eastern Europe

                              Surface Area       88361

                              IndepYear            2006

                              Population          6963764

Provide screenshot of your ‘INSERT statement’ and resultset pane here

Question 3 – Incorrect SQL statement

There are syntax errors in the following SQL statement.   Correct and execute the corrected SQL statement.

INSERT INTO Country( Code, Name, Continent, Region, SurfaceArea, IndepYear, Population )

VALUES( 'MNE, 'Montenegro', 'Europe', 'Eastern Europe' 13812, 2006, 622359 );

Provide screenshot of your ‘INSERT statement’ and resultset pane here

Question 4 – Update a row in COUNTRY table

It is often necessary to query the data to determine how best to filter on the correct row (s) to update.   Using the Select * from COUNTRY will display all the data and then you see all the data.

               Update the column – governmentform changing the value from Serbia to Republic

              But only for the country named Serbia

Note: this query should only update a single row

Provide screenshot of your ‘UPDATE statement’ and resultset pane here

Question 5 – Update a row in COUNTRY table

This ‘update’ is meant to change the ‘population’ of Canada to 37971020

Provide screenshot of your ‘UPDATE statement’ and resultset pane here

Question 6 – Deleting rows in the COUNTRYLANGUAGE table

Create the SQL statement which will delete any rows in COUNTRYLANGUAGE table where country is Canada.   Hint, you should see twelve (12) rows and its is best when ‘deleting’ data, to always query the data using the filter before running the ‘delete’ statement.

Provide screenshot of your ‘UPDATE statement’ and resultset pane here

Question 7 – Deleting rows in a table

Modify the data in the COUNTRYLANGUAGE table using the script provided – CanadianLanguages2020.sql

Once you have executed this script, write a query statement that will list all rows which have English and French as languages.

Provide screenshot of your ‘SELECT statement’ and resultset pane here

Question 8 – Updating the Official Language for Canada

Modify the rows in the COUNTRYLANGUAGE table so that all rows associated to Canada has their ‘isofficial’ indicator column set to one(1).

Provide screenshot of your ‘UPDATE statement’ and resultset pane here

Question 9 – Updating more than one column using a single SQL statement

Write a single SQL statement to change the population of Algeria to 43600000 and gnp to 684689.

Provide screenshot of your ‘UPDATE statement’ and resultset pane here