B. Presented below is information related to Dublin Company for 2018.

Required:

Prepare an (1) income statement and (2) a retained earnings statement. Dublin Company decided to discontinue its entire wholesale operations and to retain its manufacturing operations. On August 10, Dublin sold the wholesale operations to Rene Company. During 2018, there were 400,000 ordinary shares outstanding all year.

DBMS Create/Insert/Update SQL

I need the create, insert, and update SQL statement for this table:

Vendor is the name of the table the FK comes from.

1. What is database tuning? Explain some of the tuning methods used by DBAs to improve performance.
2. What types of things affect performance of a database? Explain how those things are identified and managed.
3. Explain database statistics and why they are important. How do you obtain database statistics?

Database Design

A database is an electronic filing system: a collection of data organized for use and retrieval. Database design is the process of creating a model of the database. The model can include several attributes and entities, such as users, logic, physical storage locations, relationships, and other parameters.

Write a post in which you explain at least three ways that database design and data architecture can work together to improve patient satisfaction, lower care costs, or improve patient outcomes. Then identify at least two areas of uncertainty or unanswered questions that you have about database design and data architecture.

NoSQL databases can store relationship data—they just store it differently than relational databases do. How would you describe the differences between a relational database and a NoSQL database? What do you see as the business advantages that a NoSQL database has over a relational database?

The U.S. and many other governments spend more then it raises in taxation almost every year. Since 1965 the federal government has balanced its budget 4 times (1969, 1998-2000). What are the moral aspects of this? What are the moral failings of the people (government and voters) that allow us to justify non-stop borrowing from the future to pay for current consumption? What should we do and why don't we do it?

I'm honestly not 100% sure what's going on here. Can someone post an example? This is for C++/Databases

Deliverable You must upload to moodle a single .zip archive file of your site folder. Use a utility that produces .zip files (Windows: right click | Send to | compress, Mac: right click | compress). Objectives To design, code and publish a database driven web site of your choosing. Project setup • Using VS Code, create the folder project. This folder is referred to from here on out as the folder. This is the folder you will .zip and upload. Project Requirements The web site you are going to develop over the course of the semester is up to you. The site should be designed and coded with the following set of minimum requirements in mind. • MySQL Database • The site must be database driven and as such you should use MySQL. You should export your database into the file project.sql and add it to your site folder for delivery. • The database should be named project and should include a User table to store users of your site. Include at least two more tables in a one-to-many relationship. • You must provide full CRUD functionality, i.e. A user must be able to - add a record, retrieve a record, update a record and delete a record. • User login form • You must include a login form to allow a user to log in. This is the very first page any user of your site must allowed to land on. • You must include a register form to allow users to register before they log in. • Use mysql to create an initial user account in the database with credentials (username: guest, password: guest) • Home page • The home page is the first page a user sees once they successfully log in. Do not allow a user to access this page if they have not logged in. Design and code this and other pages as you see fit. • Server side scripting • Must use PHP to handle server side scripting. Use PHP to access the database and to perform proper validation of all forms (login, register). You should use regular expressions for validation. • Authenticate the user when trying to log in. This means verify user credentials against the DB record. • Use sessions to prevent a user from accessing any page directly if they have not logged in first. 1 / 2 Last updated: September 2, 2019 at 6:09 PM • Client side scripting • Must use JS or jQuery to perform client-side validation of the login form. At this point you should not allow for empty or invalid field entries. Again, use regular expressions for this. • Use client-side scripting to enhance the user's experience while interacting with the UI as you see fit. There is no maximum expected level of functionality, but you must provide some minimum interaction. • Presentation • You must use the W3.CSS framework to style your site. Do not use another framework or your own CSS style rules unless you are overwriting/customizing a W3.CSS rule you don't like.

Grading Rubric

Feature / Weight Max / points

Deliverable / 100% / 300

MySQL / 30% / 90

Login form UI / 5% / 15

Register form UI / 5% / 15

Home page UI / 10% / 30

Server side scripting 30% 90

Client side scripting 10% 30

Presentation 10% 30

Winningham Company sold the following two machines in 2019:

Machine A Machine B
Cost $ 92,000 $ 43,000
Purchase date July 1, 2015 Jan. 1, 2016
Useful life 8 years 8 years
Residual value $ 4,000 $ 3,000
Depreciation method Straight-line Double diminishing-balance
Date sold July 1, 2019 Aug. 1, 2019
Sales price (Cash) $ 37,000 $ 12,000

Instructions:

Journalize all entries required to update depreciation and record the sales of the two assets in 2019.

NOTE: The company has recorded depreciation on the machines up to December 31, 2018.

Write a program that declares a struct to store the data of a football player (player’s name, player’s position, number of touchdowns, number of catches, number of passing yards, number of receiving yards, and the number of rushing yards).

Declare an array of 10 components to store the data of 10 football players.

Your program must contain a function to input data and a function to output data. Add functions to search the array to find the index of a specific player, and up-date the data of a player. (You may assume that the input data is stored in a file.) Before the program terminates, give the user the option to save data in a file. Your program should be menu driven, giving the user various choices.

An example of the program is shown below:

Select one of the following options:                                 
1: To print a player's data                                          
2: To print the entire data                                          
3: To update a player's touch downs                                  
4: To update a player's number of catches                            
5: To update a player's passing yards                                
6: To update a player's receiving yards                              
7: To update a player's rushing yards                                
99: To quit the program                                              
1                                                                    

Enter player's name: Bill                                            

Name: BillPosition: Quarter_Back;  Touch Downs: 70;  Number of Catche
s: 0;  Passing Yards: 8754;  Receiving Yards: 0;  Rushing Yards: 573  

Select one of the following options:                                 
1: To print a player's data                                          
2: To print the entire data                                          
3: To update a player's touch downs                                  
4: To update a player's number of catches                            
5: To update a player's passing yards                                
6: To update a player's receiving yards                              
7: To update a player's rushing yards                                
99: To quit the program                                              
99                                                                   

Would you like to save data: (y,Y/n,N) N

Bogdan received the following dividends in 2018: • an eligible dividend of $4,000 • a non-eligible dividend of $1,500 • a dividend of $850 from a foreign corporation, net of $150 of foreign tax withheld • a stock dividend of 100 shares; the paid-up capital of the corporation was increased by $10 for each share issued, and the issuing company is a public company • a capital dividend of $2,000 Required: Indicate the amount to be included in net income for tax purposes in respect of each of the dividends received by Bogdan in 2018.