Investigate how to design a DatabaseRead Chapters 3, 4, & 5 of Beginning SQL Server 2012 for Developers Watch Lessons 3,4, & 5 in Foundations of Programming: Databases with Simon AllardiceRead the Data Definition Language from http://www.w3schools.com/sql/. Complete the SQL Create DB through SQL Alter tutorials. Using the Northwind Database, create an ERD from the databaseExplain the create queries that create the database in SQL Server.Submit the ERD and a document that explains the create queries in a Word Document.

Business Source Complete: SWOT Analyses list.Competency StatementUsing a SWOT analysis, the MBA candidate will be able to evaluate competitive advantage and present a proposal for adapting to changes in the global business environment.Assessment OverviewWorking in business management means taking on responsibility to lead your organization in a variety of situations. Part of that responsibility is understanding where an organization has been and where it’s going. In this course, you will put yourself in the shoes of a manager and use resources to make decisions on where an organization is heading in respect to business needs, organizational structure, leadership strategies, and change management. Some of the information needed will be easy to locate, but other information will take time and effort to find. You may even need to make assumptions based on research. These research and strategizing skills will be useful in your business management career.In this assessment you will evaluate the strategic needs of a company within a changing global environment.PART 1Select a company - either the company you work for, a company you have worked for in the past, or 1 of the companies on the Business Source Complete: SWOT Analyses list - to use for the rest of the course (this will sometimes be referred to as “your organization”) and research its history.Note: Some reports are more recent than others. It’s in your best interest to find an organization with a recent (within 2 years) report.Create a chart or outline that conveys the following information:Name of your companyIndustryBrief history of companyAt least 3 milestones from the company’s history3 resources (in addition to Business Source Complete) where you can locate company information. These may include company websites, current employees, journals, and so on.Define 1 new unique business opportunity the company can do to increase its competitive advantage.Identify a function of management that is needed for this opportunity.PART 2Managers at each level of the organization use SWOT analysis to identify strategies that will best position the company to achieve its mission and goals.The first step in a SWOT analysis is to identify and describe an organization’s strengths and weaknesses that characterize the present state of the company. The next step requires managers to identify potential opportunities and threats in the environment that affect the organization in the present or possibly in the future.When the SWOT analysis is complete, managers begin developing strategies. These strategies should allow the company to attain its goals by taking advantage of opportunities, countering threats, building strengths, and correcting organizational weaknesses.Congratulations! You’ve been hired as a manager and have been asked to analyze the current status of your organization (the company you selected in Part 1 of this assessment).Review your organization’s SWOT analysis and other available sources to evaluate the strategic needs of the organization within a changing global environment. Complete the Organizational Analysis worksheet for your evaluation.Note: This type of information is often found in the organization’s annual report.*****Please use APA format***