"update" "non-redundant database" 2018 empirical citations 2000 questions

Questions

Purpose Review and reinforcement of pointers, dynamic memory allocation, pointer arithmetic, passing pointers to a function,...

Purpose

Review and reinforcement of pointers, dynamic memory allocation, pointer arithmetic, passing pointers to a function, returning a pointer by a function, dangling pointer, and memory deallocation, pointer initialization, and struct data type.

Project description

In this project, you will create a database of employees of an organization while meeting the requirements described below. Your program MUST NOT interact with the user to receive inputs, so that the instructor and/or the teaching assistant can save a big time in testing programs.

Construction of a Database of Employees

Employee

Employee is a struct data type that has the following attributes, or data members, or data fields

struct Employee {

string firstName;

string lastName;

int SSN;

string department;

Role role;

double salary;

};

The data type Role is defined as below.

enum Role {programmer, manager, director};

Define Employee.h and include the two data types above in the file. Role must be defined before Employee because Employee uses Role.

Create an array of employees (considered as a database) with the size of 5 by using one single dynamic memory allocation
Set the salaries of employees by defining and calling setSalaries() in which each employee is given a salary with a random number ranging from 45000 to 65000
Set the roles of employees by defining and setRoles() in which each employee is given a random role
In order to fill out other data members of each employee, you can do hardcoding or apply random number generator and/or string manipulation or any of your choice, as long as your program does not interact with the user.
Display on the console information of all employees using a table format

Display of the Statistics
1. Display the average salary of the employees on the console
2. Display the information of programmers only on the console

Memory management

Release any dynamically allocated memory in your program without memory leak
Reset any pointer variable if it is no longer used. Otherwise, such a pointer variable becomes a dangling pointer pointing to a memory that has been deleted already.

Readability
1. Apply indentations appropriately to make your program readable.

Others

No need of classes/objects
No need of makefile

In: Computer Science

A new company is planning to build a new database system for holding information about customers...

A new company is planning to build a new database system for holding information about customers and salesmen. ‘Customers’, ‘Salesmen’ and ‘Customers_Salesmen’ are part of the information that the new company wants to store in the new database. These tables are shown below in figure 1, figure 2 and figure 3. The new company intends to use MySQL for building the new database.

Customer_ID	Customer_Name	Customer_City	Customer_Grade
3002	Ahmad Salman	New York	100
3007	Mazen Ali	New York	200
3005	Sami Khalil	California	200
3008	Ashraf Ahmad	London	300
3004	Manal Faris	Paris	300
3009	Tahani Mahdi	Berlin	100
3003	Fawzi Jama	Moscow	200
3001	Tareq Mohsen	London	100

Figure 1: Customers table

Salesman_ID	Salesman_Name	Salesman_City	Salesman_Commission
5001	Naser Hamad	New York	0.15
5002	Rami Farhan	Paris	0.13
5006	Salem Alawi	Paris	0.14
5003	Faten Morad	San Jose	0.12
5007	Turkey Fahad	Rome	0.13
5005	Juma Khalaf	London	0.11

Figure 2: Salesmen table

Customer_ID	Salesman_ID
3002	5001
3007	5001
3005	5002
3008	5002
3004	5006
3009	5003
3003	5007
3001	5005

Figure 3: Customers_Salesmen table

Based on the above three tables, answer the following 6 questions:

Write an SQL statement for creating the customer table that is shown in figure 2. No need to write any SQL statement for adding any record to the customer table.
Write an SQL statement for adding one record to the customer table that was created in question-1 above. The added record should be one of the records that are given in the customer table.
Write an SQL statement to list the information of salesmen who work in Paris.
Write an SQL statement to list all customer names who work with the salesman whose id is 5001. \
Write an SQL statement to list all customer names who work with the salesman whose commission is 0.13. ]
Write an SQL statement to increase the salesman commission by 5%.

In: Computer Science

Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018...

Financial statements for Allendale Company follow:

ALLENDALE COMPANY
Balance Sheets As of December 31
	2019		2018
Assets
Current assets
Cash	$	40,000	$	36,000
Marketable securities		20,000		6,000
Accounts receivable (net)		54,000		46,000
Inventories		135,000		143,000
Prepaid items		25,000		10,000
Total current assets		274,000		241,000
Investments		27,000		20,000
Plant (net)		270,000		255,000
Land		29,000		24,000
Total assets	$	600,000	$	540,000
Liabilities and Stockholders’ Equity
Liabilities
Current liabilities
Notes payable	$	17,000	$	6,000
Accounts payable		113,800		100,000
Salaries payable		21,000		15,000
Total current liabilities		151,800		121,000
Noncurrent liabilities
Bonds payable		100,000		100,000
Other		32,000		27,000
Total noncurrent liabilities		132,000		127,000
Total liabilities		283,800		248,000
Stockholders’ equity
Preferred stock, (par value $10, 4% cumulative, non-participating; 8,000 shares authorized and issued)		80,000		80,000
Common stock (no par; 50,000 shares authorized; 10,000 shares issued)		80,000		80,000
Retained earnings		156,200		132,000
Total stockholders’ equity		316,200		292,000
Total liabilities and stockholders’ equity	$	600,000	$	540,000

ALLENDALE COMPANY
Statements of Income and Retained Earnings For the Years Ended December 31
	2019		2018
Revenues
Sales (net)	$	230,000	$	210,000
Other revenues		8,000		5,000
Total revenues		238,000		215,000
Expenses
Cost of goods sold		120,000		103,000
Selling, general, and administrative		55,000		50,000
Interest expense		8,000		7,200
Income tax expense		23,000		22,000
Total expenses		206,000		182,200
Net earnings (net income)		32,000		32,800
Retained earnings, January 1		132,000		107,000
Less: Preferred stock dividends		3,200		3,200
Common stock dividends		4,600		4,600
Retained earnings, December 31	$	156,200	$	132,000

Required

Calculate the following ratios for 2019 and 2018. Since 2017 numbers are not presented do not use averages when calculating the ratios for 2018. Instead, use the number presented on the 2018 balance sheet.

Working capital.

Current ratio. (Round your answers to 2 decimal places.)

Quick ratio. (Round your answers to 2 decimal places.)

Receivables turnover (beginning receivables at January 1, 2018, were $47,000). (Round your answers to 2 decimal places.)

Average days to collect accounts receivable. (Round your intermediate calculations to 2 decimal places and your final answers to the nearest whole number.)

Inventory turnover (beginning inventory at January 1, 2018, was $140,000). (Round your answers to 2 decimal places.)

Number of days to sell inventory. (Round your intermediate calculations to 2 decimal places and your final answers to the nearest whole number.)

Debt to assets ratio. (Round your answers to the nearest whole percent.)

Debt to equity ratio. (Round your answers to 2 decimal places.)

Number of times interest was earned. (Round your answers to 2 decimal places.)

Plant assets to long-term debt. (Round your answers to 2 decimal places.)

Net margin. (Round your answers to 2 decimal places.)

Turnover of assets. (Round your answers to 2 decimal places.)

Return on investment. (Round your answers to 2 decimal places.)

Return on equity. (Round your answers to 2 decimal places.)

Earnings per share. (Round your answers to 2 decimal places.)

Book value per share of common stock. (Round your answers to 2 decimal places.)

Price-earnings ratio (market price per share: 2018, $11.75; 2019, $12.50). (Round your intermediate calculations and final answer to 2 decimal places.)

Dividend yield on common stock. (Round your answers to 2 decimal places.)

In: Accounting

Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018...

Financial statements for Allendale Company follow:

ALLENDALE COMPANY
Balance Sheets As of December 31
	2019		2018
Assets
Current assets
Cash	$	40,000	$	36,000
Marketable securities		20,000		6,000
Accounts receivable (net)		54,000		46,000
Inventories		135,000		143,000
Prepaid items		25,000		10,000
Total current assets		274,000		241,000
Investments		27,000		20,000
Plant (net)		270,000		255,000
Land		29,000		24,000
Total assets	$	600,000	$	540,000
Liabilities and Stockholders’ Equity
Liabilities
Current liabilities
Notes payable	$	17,000	$	6,000
Accounts payable		113,800		100,000
Salaries payable		21,000		15,000
Total current liabilities		151,800		121,000
Noncurrent liabilities
Bonds payable		100,000		100,000
Other		32,000		27,000
Total noncurrent liabilities		132,000		127,000
Total liabilities		283,800		248,000
Stockholders’ equity
Preferred stock, (par value $10, 4% cumulative, non-participating; 8,000 shares authorized and issued)		80,000		80,000
Common stock (no par; 50,000 shares authorized; 10,000 shares issued)		80,000		80,000
Retained earnings		156,200		132,000
Total stockholders’ equity		316,200		292,000
Total liabilities and stockholders’ equity	$	600,000	$	540,000

ALLENDALE COMPANY
Statements of Income and Retained Earnings For the Years Ended December 31
	2019		2018
Revenues
Sales (net)	$	230,000	$	210,000
Other revenues		8,000		5,000
Total revenues		238,000		215,000
Expenses
Cost of goods sold		120,000		103,000
Selling, general, and administrative		55,000		50,000
Interest expense		8,000		7,200
Income tax expense		23,000		22,000
Total expenses		206,000		182,200
Net earnings (net income)		32,000		32,800
Retained earnings, January 1		132,000		107,000
Less: Preferred stock dividends		3,200		3,200
Common stock dividends		4,600		4,600
Retained earnings, December 31	$	156,200	$	132,000