The project sponsors of the U.S. Student Aid Data project want you to participate in the project debrief meeting. You are to provide information around the methodology and practices you used to develop the database and the reporting tools used to answer the project questions.

/in /by

Assignment Content

The project sponsors of the U.S. Student Aid Data project want you to participate in the project debrief meeting. You are to provide information around the methodology and practices you used to develop the database and the reporting tools used to answer the project questions.

Refer to the U.S. Student Aid Data assignments you completed throughout this course to prepare your debrief report. Previous assignments may need to be revised with instructor feedback.

Document the following for the project sponsors:

An explanation of the schema selected to develop the database, including:

A summary of any schema discrepancies you found and how you resolved them

The process and considerations you used to select the best schema for the database

The strategy you used to optimize and incorporate best practices into the SQL used to develop the databases, including strengths and weaknesses of the techniques you used

The strategy used to transform from one schema to another

The challenges encountered while preparing the data for analysis

The strategy used to clean the data

The tools you selected for integrating various database elements, including the strengths and weaknesses of these tools

Screenshots, diagrams, and other images as needed to support your summary

Practices you will replicate or avoid in similar projects based on your experiences with this project

Present your summary as either:

A 10- to 12-slide Microsoft® PowerPoint® presentation with detailed speaker notes

A 3- to 4-page Microsoft® Word document

Develop a Complete Disaster Recovery Plan to be submitted to the executive board of your company.

/in /by

Develop a Complete Disaster Recovery Plan to be submitted to the executive board of your company.

Only MS Word (.doc, .docx) and Adobe Acrobat (PDF) formats are acceptable.

-Please note that this is a formal writing, all references (peer-reviewed) mostly must be cited appropriately within the text and clearly avoid plagiarism.

– The paper should have a minimum of 10 pages, 1.5 spacing and Times New Roman font. A minimum of 5 peer review references must be provided.

-Reference style is APA.

-You can also have some web references alongside the stated requirement.

Please identify and cite one federal statute that regulates pornography on the internet, and also summarize (in not less than 100 words) what that statute accomplishes (please also post the hyperlink to the statute)

/in /by

1. Please identify and cite one federal statute that regulates pornography on the internet, and also summarize (in not less than 100 words) what that statute accomplishes (please also post the hyperlink to the statute).

2. Please identify and cite one state statute that regulates pornography on the internet and summarize (in not less than 100 words) what that statute accomplishes (please also post the hyperlink to the statute).

3. Please identify and cite one federal court case that influences online gambling, and also briefly summarize (in not less than 100 words) what that court case accomplishes (please also post the hyperlink to the case summary).

4. Please identify and cite one state court case that influences online gambling, and also briefly summarize (in not less than 100 words) what that court case accomplishes (please also post the hyperlink to the case summary)

The Director of Purchasing for parts distribution company wants to purchase steel coach screws from Germany; however, he is not sure what the best option is.

/in /by

Evaluate two of the scenarios listed below and explain the best solution for each. Include comments related to any ethical issues that arise. Support your responses with appropriate cases, laws and other relevant examples by using at least one scholarly source from the SUO Library in addition to your textbook for each scenario.

Scenario 1—International Trade

The Director of Purchasing for parts distribution company wants to purchase steel coach screws from Germany; however, he is not sure what the best option is. The director comes to you and asks your opinion. You know that Germany, Canada, and Korea are the best sources for obtaining this product. While your research shows coach screws from Germany are of the highest quality, the United States imposes a tariff of 12.5%, which makes this option noncompetitive.

Which US trade laws should you consider when selecting a country?

Is there any way by which you can seek a reduction on the tariff? If so, how? If not, why?

Select an alternative country (Canada or Korea) for purchasing the coach screws and explain your reasons for selecting the country.

Scenario 2 – Bribery

Slyce Pizza Company purchased four commercial refrigerators for the restaurants and eight pizza ovens from a supplier in Italy. Between the shipping costs, delays, and unanticipated duties, the purchasing manager was worried that his boss would be upset about the total costs. In an effort to reduce costs, the manager offered a US Customs officer $500 in cash to re-classify the imported goods to reduce the amount of duties owed.

Analyze the legal and ethical ramifications of the purchasing manager’s offer to the customs official?

Would it make a difference if the purchasing manager offered to donate $500 to St. Jude Children’s Research Hospital if the officer expedited the paperwork necessary to release the goods from custom’s custody?

Scenario 3—Environment

Recycling Genie is a new company that contracts with Best Buy and other electronics retailers for the collection old computers, monitors, televisions, and cell phones dropped off at their facilities. The electronics contain lead, mercury, and polyvinyl chlorides that are known to have toxicological effects such as cancer, kidney disease, and brain damage. Recycling Genie has been in negotiations to ship the e-waste to companies in China, Vietnam, and Mongolia.

What are the legal and ethical concerns with shipping e-waste to these countries?

Scenario 4—Property

Ginger and Allen lived together in New Mexico since 2011, but they were not married until July 2013. Allen purchased the home in 2008, prior to meeting Ginger. He did not add Ginger to the title after they were married; however, she contributed to the mortgage payments from 2011 until she started her business in 2013. In September 2013, Ginger inherited $55,000 from her father that she used to start a corporation, Fantastic Faces, a beauty consulting business

Ginger worked full time for Fantastic Faces, while Allen continued with his job teaching at the university. Allen made no contributions to Fantastic Faces. Due to limited financial resources, Ginger did not earn any salary until 2015.

In May 2013, Allen inherited 20 acres of farmland in Alabama from his grandfather. The land was leased to a local farmer. Allen visited the farm after the funeral in 2013 but did not return to Alabama. The rental income of $5,000 per year was deposited into the couple’s joint account. Allen filed for divorce in New Mexico on November 10, 2015.

Explain the how the court will determine the ownership of the house, farmland, and business based on New Mexico law.

Determine how the court would decide if the couple resided in your state instead of New Mexico.