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.

Operations managers must be concerned with more than final outcomes (the final product or service delivered). They must be involved in determining the processes used to develop and create the final product and how they can be created or manufactured within the current capacities of the organization.Successful organizations appear complex because they are made up of a multitude of different departments with each having a specific responsibility in the creation and delivery of the final product or service.For this Discussion, you will need to conduct research on capacity and facilities before you can prepare a complete response to the questions asked. Start this research by reviewing the Web Field Trip resources below.Web Field TripThe below relate to your Discussion topic for this week. Please spend some time reviewing these websites before you compose your response.Store design & construction. (2016). Retrieved from http://supermarketnews.com/news/store-design-const...Phillips, T. (2016). Phillips enterprises, Inc. Food market designs. Retrieved from http://www.foodmarketdesigns.com/How to Layout Your SupermarketDiscussionBe sure each of the questions below is addressed. Address each question individually and be careful not to combine your questions and answers:Identify a supermarket/grocery market to discuss for this Discussion topic.What departments within the market tend to be co-located (adjacent to one another)? Do you believe the co-location is planned? If so, why?What departments within the market tend to be distant from one another? What purpose is accomplished by separating these departments so far apart from each other?Why is the layout of the supermarket so important to the overall delivery of the products and services provided?What recommendations would you make to the layout of the supermarket to make the layout more effective or efficient?