Create the following tables in the Northwind database
Create the following tables in the Northwind database:Regions tableColumn NameDatatypePrimary Key (Y/N)Nullable (Y/N)RegionIDIntegerYNRegionDescriptionCharacter (50)NNDepartments tableColumn NameDatatypePrimary Key (Y/N)Nullable (Y/N)DepartmentIDIntegerYNDepartmentDescriptionCharacter (50)NNInsert the following data into the 2 tables:Regions table1Eastern2Western3Northern4SouthernDepartments table10CEO20Sales30MarketingAlter the Employees table, and add a column:Employees tableColumn NameDatatypePrimary Key (Y/N)Nullable (Y/N)DepartmentIDIntegerNYAlter the Employee table to establish a foreign key between Employees and Departments.Employees.DepartmentID references Departments.DepartmentIDAlter the Territories table to establish a foreign key between Territories and Regions.Territories.RegionID references Regions.RegionIDUpdate the data in the Employees table so that employees with the following managers are listed as working in the following departments:ReportsToDepartmentAndrew FullerSalesSteven BuchananMarketingAll OthersCEOSubmit the SQL, DDL, and DML scripts needed to complete tasks 2–8 and a database diagram of the final data
Assignment Content The president and board of directors accept your proposal and are ready to adopt the cloud solution
The president and board of directors accept your proposal and are ready to adopt the cloud solution recommendation. You are asked to write a message for a dashboard publication on the company’s internal website. Your audience is a diverse workforce, and they will be reading the announcement about this new solution.
Draft a 1- to 2-page announcement to be used for the dashboard.
This message can be created as one of the following:
Website (provide a wireframe)
For introductory information on wireframing, refer to “Conceptualizing the Solution” from Wire Framing for Product Managers from LinkedIn Learning in the Wk 5 Learning Activities folder.
Microsoft® Word or Microsoft® PowerPoint® presentation
Another instructor-approved deliverable
Provide the following in your announcement:
A brief background of the problem
The solution to address the business’s needs
The business benefits to employees and the community
Key highlights of the service management and operation plan to roll out the cloud solution
A timeline for the implementation and the teams included in the project
Identify different types and levels of statistics
· Identify different types and levels of statistics.
· Describe the role of statistics in business decision making.
· Provide at least three examples or problem situations in which statistics was used or could be used.
Scenario Suppose you have been hired by a small group of partners who are in the process of starting
Suppose you have been hired by a small group of partners who are in the process of starting a new business. The business will design, produce, and sell an innovative product to the biomedical industry. The partners have a great deal of experience designing products but very little knowledge about starting a business. Due to the sensitive nature of the new business, you feel that the partners need to develop a code of ethics and a mission and vision statement for the company. They do not agree. You need to write a white paper (a document providing information on a topic) to convince them that this is an important step in establishing a new business.
Based on the scenario above, develop a white paper on the importance of mission and vision statements and a code of ethics. Use the Week 4 Assignment Template [DOCX] to develop your white paper with the following sections.
Purpose of Mission and Vision Statements.
Explain the purpose of mission and vision statements using real-world examples and supporting evidence.
Key Elements of Mission and Vision Statements.
Identify key elements within mission and vision statements and explain why the elements are important for a company.
Purpose of a Code of Ethics.
Explain the purpose of a code of ethics and why the code should be directed toward all stakeholders, including leadership, employees, and customers.
Key Elements of a Code of Ethics.
Identify key elements within a code of ethics and explain why the elements are important for a company.
Relationship Between a Company’s Mission and Vision Statements and Its Code of Ethics.
Explain the relationship between a company’s mission and vision statements and its code of ethics in terms of strategic management.
Role of Leadership in Promoting and Supporting the Mission, Vision, and Code of Ethics.
Explain the role of an organization’s leadership in promoting and supporting the mission, vision, and ethical principles of the organization, and discuss the consequences of a leader who fails to promote and support the mission, vision, and ethical principles of the company.
Your white paper should be 3–5 pages in length, well organized, and written in clear, succinct language. Follow current APA rules for attributing sources that support your analysis and conclusions.
Academic Integrity and APA Formatting
As a reminder related to using APA rules to ensure academic honesty:
When using a direct quote (using exact or nearly exact wording), you must enclose the quoted wording in quotation marks, immediately followed by an in-text citation. The source must then be listed on your references page.
When paraphrasing (using your own words to describe a non-original idea), the paraphrased idea must be immediately followed by an in-text citation, and the source must be listed on your references page.
Refer to the scoring guide to ensure that your work meets the grading criteria for this assignment.
Example assignment: You may use the Week 4 Assignment Example [PDF] to give you an idea of what a Proficient or higher rating on the scoring guide would look like.
Your assignment should also meet the following requirements:
Written communication: Communication should be clear and well organized, and support a central idea, with no technical writing errors, as expected of a business professional.
References: References and citations are formatted in consistent style, with a preference for using current APA style and formatting.
Number of resources: Use a minimum of three scholarly resources related to the content of the assignment.
Length of paper: 3–5 typed, double-spaced pages, in addition to the title and references pages.
Font and font size: Times New Roman, 12 point.
Essay Writing at Proficient Essay
Review This Service