How do I start to code in mysql to Alter table to modify column

remove not null constraint

First drop the foreign key associated with

Drop the column

Add the column back with new definition

Add the foreign key back

This Is what I wrote so far

alter table employees modify column repotsTo remove null:

With successful candidates, they should be prepared to deal with ethical issues not only in the workplace as well also answering ethical questions during an interview process.

Would this be true or false and why would you say so?

The appropriate dress attire for an interview should make you stand out, a good way to do this is to pair your suit with a bright colored shirt and matching tie or scarf?

Would this be true or false and why?

The most common mistake someone could do during an interview process is a lie, why would this be a problem with getting hired or declined?

In the fashion business, faux pas can be costly. In order to hem back the risk writes The Wall Street Journal (Sept. 9, 2013), some retailers are increasingly turning to trend forecasting and analytics (the topic of Chapter 4). For an average annual fee of $7,000-$15,000, customers get access to forecasts of fashion trends and data offering ideas for colors, fabrics, and cuts. Fashion companies use the data to plan their latest collection or show.

“Fashion forecasters have always been used but they’re more accessible now because of the technology,” says a Marks & Spencer exec. “They are important, not always to lead but to re-evaluate and help confirm you’re on the right track.”

Forecasters claim to save their clients travel expenses, the cost of freelancers paid to photograph trendy people, and time spent trawling the vast cache of fashion data on the Internet. “We can’t get rid of risk but we can mitigate risk,” says the CEO of the forecasting firm Stylesight.

“Forecasters take the information and package it in a way that speaks the language of the retailers and manufacturers. Then it’s our job to decide what makes sense for our business; we have to filter it again,” says Kohl’s VP. “Fashion moves so quickly. Companies like Stylesight, which are updated every day, are really useful in order to make sure we have the right information. They offer us an industry eye on all of the information, broken down by print, color, and classification like sweaters of woven tops.”

Retailers say the information forecasters provide has become an important part of how they tap consumers, who spend less, shop online more and demand the latest outfits in increasingly tight time frames.

Discussion questions:

1. Why do large retailers like Macy’s and Kohl’s need forecasts of fashion demands?

2. What forecasting techniques discussed in Chapter 4 can be applied to this problem?

1. Larry and Gary are two of the three directors of Scary Inc., a corporation which owns a local music club. Without informing Scary’s third director, they secretly vote to enter into a very lucrative contract to purchase all of the club’s alcoholic beverages from “Bloody Mary’s Inc.,” a liquor distributor owned by their sister, Mary. Relying solely on Mary’s representations, Larry and Gary believe that Mary’s prices are fair and competitive. In fact, her prices turned out to be higher than most other local distributors, resulting in significant lost profits for Scary. When Scary’s shareholders learned of the contract with Mary, they sued Larry and Gary personally for damages. If Larry and Gary raise the Business Judgment Rule as a Defense:

i) Explain what elements are generally necessary for the Rule to apply?

ii) Will the Rule protect Larry and Gary from Liability? Why or why not?

Describe the existing needs for cost information in healthcare firms.

Python 3.7.4 (Introductory Level)

You want to know your grade in Computer Science:

Write a program that continuously takes grades between 0 and 100 to standard input until you input "stop", at which point it should print your average to standard output.

Separate code into .cpp and .h files:

// C++ program to create and implement Poly class representing Polynomials
#include <iostream>
#include <cmath>
using namespace std;

class Poly
{
private:
int degree;
int *coefficients;
public:
Poly();
Poly(int coeff, int degree);
Poly(int coeff);
Poly(const Poly& p);
~Poly();

void resize(int new_degree);
void setCoefficient(int exp, int coeff);
int getCoefficient(int exp);

void display();
};

// default constructor to create a polynomial with constant 0
Poly::Poly()
{
// set degree to 0
degree = 0;
// create an array of size 1
coefficients = new int[degree+1];
coefficients[0] = 0;
}

// parameterized constructor to create a polynomial with degree degree whose coefficient is coeff
Poly::Poly(int coeff, int degree)
{
this->degree = degree;
// create an array of size degree+1
coefficients = new int[degree+1];
// loop to set all the entries to 0
for(int i=0;i<degree;i++)
coefficients[i] = 0;
// set coefficient of degree to coeff
coefficients[degree] = coeff;
}

// parameterized constructor to create a polynomial with constant coeff
Poly::Poly(int coeff)
{
// set degree to 0
degree = 0;
// create an array of size 1
coefficients = new int[degree+1];
// set coefficients of constant to coeff
coefficients[0] = coeff;
}

// copy constructor to create a Polynomial same as p
Poly::Poly(const Poly& p)
{
// set degree
degree = p.degree;
// create a new array of size degree+1
coefficients = new int[degree+1];
// loop to copy the coefficients
for(int i=0;i<=degree;i++)
coefficients[i] = p.coefficients[i];
}

// destructor to release the memory allocated
Poly::~Poly()
{
delete[] coefficients;
}

// function to resize the polynomial to new_degree if new_degree > degree
void Poly:: resize(int new_degree)
{
if(new_degree > degree) // validate new_degree > degree
{
// create a new temporary array of size new_degree+1
int *temp = new int[new_degree+1];
// loop to copy coefficients to temp
for(int i=0;i<=degree;i++)
temp[i] = coefficients[i];

// loop to set the coefficients entries to 0
for(int i=degree+1; i<=new_degree; i++)
temp[i] = 0;

// release memory of existing array
delete[] coefficients;
// update degree
degree = new_degree;
// set coefficients to point to temp
coefficients = temp;
}
}

// function to set coefficient of exp to coeff
void Poly:: setCoefficient(int exp, int coeff)
{
// validate exp to be between [0,degree]
if(exp >= 0 && exp <= degree)
{
coefficients[exp] = coeff;
}
}

// function to return the coefficient of exp
int Poly::getCoefficient(int exp)
{
// validate exp to be between [0,degree]
if(exp >= 0 && exp <= degree)
return coefficients[exp];
return 0; // invalid exp, return 0
}

// function to display the polynomial
void Poly:: display()
{
bool firstTermDisplayed = false;

// loop from degree to 0
for(int i=degree; i>=0 ; i--)
{
if(coefficients[i] != 0) // ith coefficients is non-zero
{
if(firstTermDisplayed) // first term displayed
{
if(coefficients[i] > 0) // display sign between terms
cout<<" + ";
else
cout<<" - ";
cout<<abs(coefficients[i]); // display absolute value of coefficient
}
else // first term being displayed
{
cout<<coefficients[i];
firstTermDisplayed = true; // set firstTermDisplayed to true
}

// display the power of x
if(i > 0)
{
if(i == 1)
cout<<"x";
else
cout<<"x^"<<i;
}
}
else if(i == 0 && !firstTermDisplayed) // if polynomial is 0, display the constant 0
cout<<coefficients[i];
}
}

int main()
{
// test the Poly class
Poly A(5, 7), B(2), X;
Poly C(A);
cout<<"A: ";
A.display();
cout<<endl<<"B: ";
B.display();
cout<<endl<<"X: ";
X.display();
cout<<endl<<"C: ";
C.display();

A.setCoefficient(0, -2);
A.setCoefficient(1, 10);
A.setCoefficient(3, -4);
cout<<endl<<"A: ";
A.display();

B.resize(5);
B.setCoefficient(2, 10);
cout<<endl<<"B: ";
B.display();

return 0;
}

//end of program

How is the first argument passed to a function in x86-64 assembly? Give an example of this happening in assembly and the corresponding C code.

What x86-64 register is changed to allocate local variables? Explain briefly with an example.

what are the four pillars of design And discuss them?

You’re a well-adjusted person—mature, friendly, generous, even-tempered, and not prone to violence. You decide to join the police department (in an American city) because you regard police work as a good career option and a constructive way to serve your community. The police department trains you and your fellow recruits in today’s standard ways; and, once on the job, department policy requires that you and your fellow officers take a top-down, strict approach to policing. You’re assigned to car-patrol duty in a poor, predominately Black and Latino neighborhood.

From the standpoint of social structure and social interaction--with emphasis on social institutions (such as political power/inequality, law, economy, social class, and racial-ethnic relations) and on statuses and roles for both police officers and community—describe the probable consequences of this experience:

for your relations with the non-police community, including your pre-career friends;

for your relations with fellow police officers;

and for your perceptions and interpretations of the world, emotions, priorities/politics, and personality?

Program Specification: (Visual Studio C++)
1. Read data for names and weights for 15 people from the console where there is a name on a line followed by a weight on the next line.
2. Your program will build a list for the data maintained in ascending order based on both name and weight via a doubly linked list.
3. This dll will use one pointer to keep weights in sorted order, and use the other link to keep names on sorted order.
4. You need to build the list as you go maintaining this ordering, so at any time a print method was called it would print the related field in order. (This means nodes are added to the list in sorted order, elements are not added to the list followed by a sort called on the list.)

For example after 3 elements are added for (Name – Weight):
Michael – 275, Tom – 150, Abe – 200.

Output:
Names & weights sorted(ascending) by name. : Abe – 200, Michael – 275, Tom - 150
Names & weights sorted(ascending) by weight. : Tom – 150, Abe – 200, Michael - 275

Jim
150
Tom
212
Michael
174
Abe
199
Richard
200
April
117
Claire
124
Bobby
109
Bob
156
Kevin
145
Jason
182
Brian
150
Chris
175
Steven
164
Annabelle
99

How should the law deal with threats by employers to abandon all or parts of their domestic operations for overseas locations if their unions fail to make appropriate economic concessions?

Should the NLRA be modified to prohibit strikes and lockouts in favor of arbitration of negotiation impasses or redefine good faith bargaining to require interest based bargaining?

*C PROGRAMMING LANGUAGE*

a) Given an array of size n, sort the array using pointers using malloc or calloc. Examples: Input: n = 5, A= {33,21,2,55,4} Output: {2,4,21,33,55}

b) Write a function that declares an array of 256 doubles and initializes each element in the array to have a value equal to half of the index of that element. That is, the value at index 0 should be 0.0, the value at index 1 should be 0.5, the value at index 2 should be 1.0, and so on. your function must be called in the main. Also, declaring array and the size must be using heap.

NOK Plastics is considering the acquisition of a new plastic injection-molding machine to make a line of plastic fittings. The cost of the machine and dies is $125,000. Shipping and installation is another $8,000. NOK estimates it will need a $10,000 investment in net working capital initially, which will be recovered at the end of the life of the equipment. Sales of the new plastic fittings are expected to be $350,000 annually. Cost of goods sold are expected to be 50% of sales. Additional operating expenses are projected to be $115,000 per year over the machine’s expected 5-year useful life. The machine will depreciated using a 5-year MACRS class life. The equipment will be sold at the end of its useful life (5 years) for $35,000. The tax rate is 25% and the relevant discount rate is 15%. Calculate the net present value (NPV), internal rate of return (IRR), payback period (PB), and profitability index (PI) and state whether the project should be accepted.