"Compensation Tactics and Practices" Please respond to the following:

Some industries appear to pay higher wages than others, even when measurable labor quality or the type of work they do seems similar. Use the Internet or the Strayer Library database to research one (1) company in a high and another in a low paying industry. Next, examine the key differences in the inter-industry wage differentials (e.g., IT vs. Retail industry). You will then need to summarize your findings within your discussion post.

Discuss at least two (2) factors that you believe influence inter-industry wage/salary differentials. Support your rationale.

Write a three page overview of what you learned about databases for this assignment. Use APA (Links to an external site.) style, double spaces and 12 point Arial font. On page one explain a few topic that you can now understand about database systems and their information power. Followed by two pages where you see databases in uses in our everyday lives. Explain how the data is turned into information. This is your opinion and there is no wrong answer for this part of the assignment. This paper will be reviewed and graded by and professional editor. Spend time proofing and editing your work. This assignment is a test grade!!!!

(Q)Choose a DBMS that you’d like to use. Provide some evidences to show that you have some basic knowledge of the software. For instance, use the software to define a name and address database of your business associates, friends, classmates etc. You can use the following relation: (LAST NAME, FIRST NAME, SEX, ADDRESS, POSTCODE, CITY, PHONE). Enter at least five people in your data file. Print/screen shot a copy of the records. There should be no blank records. (20)

please mention which dbms that you used and please give detail explanation in the answer thank you.

The plant asset and accumulated depreciation accounts of Pell Corporation had the following balances at December 31, 2017: Plant Asset Accumulated Depreciation Land $ 350,000 $ 0 Land improvements 180,000 45,000 Building 1,500,000 350,000 Machinery and equipment 1,158,000 405,000 Automobiles 150,000 112,000 Transactions during 2018 were as follows: On January 2, 2018, machinery and equipment were purchased at a total invoice cost of $260,000, which included a $5,500 charge for freight. Installation costs of $27,000 were incurred. On March 31, 2018, a small storage building was donated to the company. The person donating the building originally purchased it three years ago for $25,000. The fair value of the building on the day of the donation was $17,000. On May 1, 2018, expenditures of $50,000 were made to repave parking lots at Pell's plant location. The work was necessitated by damage caused by severe winter weather. On November 1, 2018, Pell acquired a tract of land with an existing building in exchange for 10,000 shares of Pell's common stock that had a market price of $38 per share. Pell paid legal fees and title insurance totaling $23,000. Shortly after acquisition, the building was razed at a cost of $35,000 in anticipation of new building construction in 2019. On December 31, 2018, Pell purchased a small storage building by giving $15,250 cash and an old automobile purchased for $18,000 on January 1, 2017. Depreciation on the old automobile recorded through December 31, 2018, totaled $13,500. The fair value of the old automobile was $3,750. Required: For each asset classification, prepare a schedule showing depreciation for the year ended December 31, 2018, using the following depreciation methods and useful lives: Land improvements—Straight line; 15 years. Building—150% declining balance; 20 years. Machinery and equipment—Straight line; 10 years. Automobiles—150% declining balance; 3 years. Depreciation is computed to the nearest month and no residual values are used. (Do not round intermediate calculations and round your final answers to 2 decimal places.)

The plant asset and accumulated depreciation accounts of Pell Corporation had the following balances at December 31, 2017:

Transactions during 2018 were as follows:

On January 2, 2018, machinery and equipment were purchased at a total invoice cost of $260,000, which included a $5,500 charge for freight. Installation costs of $27,000 were incurred.

On March 31, 2018, a small storage building was donated to the company. The person donating the building originally purchased it three years ago for $25,000. The fair value of the building on the day of the donation was $17,000.

On May 1, 2018, expenditures of $50,000 were made to repave parking lots at Pell's plant location. The work was necessitated by damage caused by severe winter weather.

On November 1, 2018, Pell acquired a tract of land with an existing building in exchange for 10,000 shares of Pell's common stock that had a market price of $38 per share. Pell paid legal fees and title insurance totaling $23,000. Shortly after acquisition, the building was razed at a cost of $35,000 in anticipation of new building construction in 2019.

On December 31, 2018, Pell purchased a small storage building by giving $15,250 cash and an old automobile purchased for $18,000 on January 1, 2017. Depreciation on the old automobile recorded through December 31, 2018, totaled $13,500. The fair value of the old automobile was $3,750.

Required:

For each asset classification, prepare a schedule showing depreciation for the year ended December 31, 2018, using the following depreciation methods and useful lives:

Land improvements—Straight line; 15 years.
Building—150% declining balance; 20 years.
Machinery and equipment—Straight line; 10 years.
Automobiles—150% declining balance; 3 years.

Depreciation is computed to the nearest month and no residual values are used. (Do not round intermediate calculations and round your final answers to 2 decimal places.)

– Problem –

Belanger & Associates, PC, is an engineering firm with offices in several cities in the Carolinas. Belanger’s fiscal year-end is December 31, and it prepares financial statements just once a year, at year-end. For bookkeeping purposes, the company has adopted a policy to record payments and collections in advance into asset and liability accounts, respectively. Belanger’s unadjustedtrial balance at December 31, 2018 is shown below. All accounts have normal-side balances.

Accounts Payable                                                                     $  602,715

Accounts Receivable                                                                     923,610

Accumulated Depreciation – Buildings                                           332,105

Accumulated Depreciation – Equipment                                         269,597

Allowance for Doubtful Accounts                                                    11,832

Advertising Expense                                                                        46,739

Buildings                                                                                   1,382,015

Cash                                                                                              582,287

Common Stock ($1 par)                                                                 196,750

Dividends                                                                                     152,500

Equipment                                                                                    793,926

Insurance Expense                                                                          77,205

Interest Expense                                                                              16,931

Land                                                                                             253,760

Notes Payable                                                                               821,000

Prepaid Insurance                                                                         385,104

Property Tax Expense                                                                     41,490

Retained Earnings                                                                      1,037,500

Salaries and Wages Expense                                                      3,938,920

Service Revenue                                                                         5,612,810

Unearned Rent Revenue                                                                  17,388

Utilities Expense                                                                           307,210

Additional information available at year-end is as follows:

Belanger sometimes leases unused space in its buildings to other businesses. On September 1, 2018, a new tenant signed a 3-year lease and paid the first 9 months’ rent of $17,388 in advance. The lease began on that date and runs through August 31, 2021.

The Notes Payable balance relates to a bank loan obtained in 2017 that is payable in full on March 31, 2023. The loan agreement specifies that Belanger pay interest annually on March 31 at the rate of 6.40%. Belanger’s bookkeeper made the proper entry for the first interest payment, on March 31, 2018. (Hint– Think about the entry Belanger made on the first interest payment date.)

On November 20, 2018, Belanger paid $31,640 for internet ads to run evenly over an 8-month period, starting December 1, 2018. Note – Contrary to the company’s normal practice, Belanger’s bookkeeper recorded the prepayment into the Advertising Expense account. Give the adjusting entry needed when a company uses the expense approach to record a payment in advance.

Belanger performed $182,976 of engineering services for several clients in December 2018 that it has not yet billed, recorded or collected.

In the first week of January 2019, Belanger received bills for December 2018 utilities totaling $22,651. The company paid all of these bills in late January 2019.

Belanger estimates that 8.19% of the 2018 year-end accounts receivable balance will notbe collected.

Belanger purchased its buildings in 2007 and its equipment in 2014. Belanger depreciates its fixed assets according to the straight-line method. For the buildings, it uses estimates of 35 years for the useful life and $275,000 for the salvage value. For the equipment, it uses estimates of 9 years for the useful life and $47,349 for the salvage value.

On June 1, 2018, Belanger purchased a 2-year insurance policy for $385,104 and paid the full cost of the policy in advance. The policy provides coverage through May 31, 2020.

Belanger operates 5 days a week, Mondays through Fridays. Employees are paid each Friday, for hours worked through the previous Friday. On Friday, December 28, 2018, the last pay day in 2018, Belanger paid its employees for hours worked during the week of December 17-21. The employees then worked their regular schedule through the end of the year. Note that Tuesday, December 25 was a paid holiday for all employees. Belanger’s payroll averages $15,720 per day.

The company’s income tax rate for the year is 30%. (Hint– The income tax rate is applied to the company’s income after all revenues and expenses have been considered except for the income tax charge.)

– Instructions –

Complete the following four tasks relating to Belanger & Associates, PC’s accounting process at year-end 2018:

(a)        Prepare the adjusting journal entries needed at December 31, 2018.

(b)       Prepare an adjustedtrial balance as of December 31, 2018. List the accounts in an appropriate trial balance order.

(c)        Prepare the closing journal entries needed at December 31, 2018. Belanger uses an Income Summary account.

(d)       Prepare a post-closingtrial balance as of December 31, 2018. List the accounts in an appropriate trial balance order.

Using the zip file provided, create a secure login/registration app. Make sure that your game pages (at least two) are unavailable to unregistered users. Upload a zip file with your working PHP application.

Contents of zip

Index.php

-----------------

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <?php
        // 1. display error message in the session (if any): $_SESSION['error']
        // 2. display either the user's name and the game menu or the form/link below
        // (display the menu by using a php include of menu.html)
        ?>
        <form action="authenticate.php" method="post">
            Username: <input type="text" name="user"><br>
            Password: <input type="password" name="pwd"><br>
            <input type="submit">
        </form>
        <a href="register.php">Register a new login</a>
    </body>
</html>

menu.html

---------------

   <h3>Game Menu</h3>
        <ul>
            <li><a href="guess.php">Guess</a></li>
        </ul>

newUser.php

-------------------

<?php
session_start();

// 1. validate the input
// 2. make sure user is not already in the database
// 3. make sure that pwd and repeat match
// 4. insert a new row (be sure to hash the pwd first)

// 5. redirect to home page
header("Location: index.php");
?>

register.php

-------------

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <form action="newUser.php" method="post">
            Username: <input type="text" name="user"><br>
            Password: <input type="password" name="pwd"><br>
            Repeat: <input type="password" name="repeat"><br>
            <input type="submit">
        </form>
    </body>
</html>

games_ddl.sql

----------------

CREATE DATABASE games;

USE games;
CREATE TABLE users
(
    id int primary key auto_increment,
    username varchar(255),
    password varchar(255)
);

-- insert a row into the users table for the administrator:
-- username = foo
-- password = bar
INSERT INTO users (username, password) VALUES ('foo', '$2y$10$IWDcVmWIHlx5nI5A.18gNOUDoJZgdfWJwFMamea9JaUK9M.iTx8g.');

Authenticate.php

---------------------

<?php

// 1. validate the form input (set $_SESSION['error'] if there is a problem)
// 2. create a database connection (using the standard root user)
// 3. select the password from the users table where the username came from the form
// 4. use password_verify to see if the form password matches the hashed password from db: password_verify($pwdFromFrom, $dbPwd) returns a boolean
// 5. forward user to index.php
// 6. allow execution to continue and close db connection

?>

SQL Questions

1. Select ALL of the TRUE statements.

a. You can control the location of objects within a database onto specific disks/SAN LUNs only if multiple filegroups are created for each disk or SAN LUN

b. Dirty pages are data pages that have been updated in memory, but not yet written to disk
c. DBCC CHECKDB should be executed at all times to ensure data integrity

d. SQL Server data files and log files perform best on network shares as opposed to locally connected drives

e. Filegroups apply only to data files and not to log files

f. SQL Server always writes to the transaction log on disk before any data page is updated in the memory buffers
g. A SQL Server data file can be a part of multiple filegroups

2. SQL Server 2008 SP4 Enterprise Edition can be upgraded to which of the following SQL Server 2017 editions?

a. SQL Server 2017 Developer Edition

b. SQL Server 2017 Standard Edition

c. SQL Server 2017 Enterprise Edition

d. SQL Server 2017 Express Edition

3. SQL Server 2017 supports compatibility mode for which of the following versions of SQL Server?

Select one or more:

a. SQL Server 2008 R2
b. SQL Server 2005

c. SQL Server 2012

d. SQL Server 2014
e. SQL Server 2008

4. Which of the following statements are true in SQL Server?

Select ALL that apply:

a. SQL Server data files can only grow in multiples of 64K

b. You must pay for all editions of SQL Server

c. Server-side networking for SQL Server is configured at the Database level

d. It is best practice to set Auto_Update_Statistics & Auto_Create_Statistics to FALSE

e. A data page in SQL Server can only hold one object (e.g. a specific table, index, etc.)

f. SQL Server pages can be any size between 8K and 64K

g. You can have multiple versions of SQL Server installed on the same virtual server

5. Which of the following SQL Statements that will provide a list of all tables in the 'AdventureWorks2014" database and nothing else?

Group of answer choices

a. use AdventureWorks2014; Select * from sys.objects where type='TABLE'

b. use AdventureWorks2014; SELECT * FROM INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE'

c. use AdventureWorks2014; Select * from INFORMATION_SCHEMA.TABLES

d. use AdventureWorks2014; Select * from system.tables

This database experience project has two parts: (1) creating the presentation-layer ERD, (2) developing the semantic integrity constraints (meta-data) for your data. The deliverable will include a title page with your name, your client’s name, and all sections as part of one file (.pdf).

1. Create the ERD

Review the business rules described in your project files and create a presentation-layer ERD illustrating the entities/relationships needed to support your database design with accompanying data definitions. Use any graphical tool you prefer but be consistent. No gridlines – keep it clean.

Make sure to follow all rules of ER diagramming. If you see additional files (e.g., patient visit form, initial medical history form), you need to consider including the data from those forms into your database model as well. Include all entities, label relationships if there are multiple relationships between 2 entities, include all attributes and constraints where necessary and identify all primary and foreign keys as discussed.

For full credit, part 1 deliverable must include:

1. ERD incorporating all entities identified in the project business rules (see your project specifics)
2. Relationships between those entities are drawn with min/max cardinalities and constraints where required. All primary and foreign keys will be identified.
3. Do not break the rules of EER diagramming.

2. Create Semantic Integrity Constraints

Semantic Integrity Constraints (or Data definitions) must be in the form of a table (use format shown below – do not add any other info columns), defining briefly each attribute of each entity, for each table. For example:

Data definitions for all attributes must be included; data-type and max length as a minimum requirement. (if the attribute is obvious such as first name, no need to define as “first name” etc.)

Journal Entries and Trial Balance

On October 1, 2018, Jay Pryor established an interior decorating business, Pioneer Designs. During the month, Jay completed the following transactions related to the business:

Enter the following transactions on Page 2 of the two-column journal:

True or False?

1. The seller's basic obligation under the UCC is to transfer and deliver goods to the Buyer that conform to the contact.

2. A Buyer's remedies under the UCC include the right to (i) accept the non-conforming goods; (ii) reject the non-conforming goods; or (iii) accept in part and reject part of the non-conforming goods.

3. If the Seller delivers conforming goods to the contract, then the Buyer may reject them if the Buyer changes his mind.
4. A warranty is a statement or representation made by the Seller that his goods conform to certain standards of quality, safety, performance, and title.

5. Parties' doing business internationally can specify what law governs in the terms of their contract.