Question

Objectives The purpose of this assignment is to create and populate tables in SQL Server using the SQL Server Management Studio (SSMS) client. Tables will be created with constraints and then populated with data to produce a test database for a pre-defined application scenario. This test database will be used for additional assignments in other modules to learn how to program in SQL. Application Scenario Assume the company you are working with to produce this database is called MountainDesign, LLC, a sporting goods manufacturing and supply company. MountainDesign specializes in designing and manufacturing sporting goods for hiking, camping, and backpacking. MountainDesign makes and sells sporting goods to the public and to more general sporting goods stores, such as Scheels, REI, and Cabela’s. The application for this assignment is part of a purchase order system. The purchase order system is used to place orders with vendors for the products (also called items or materials) that MountainDesign uses to manufacture its sporting goods. This system is NOT a customer ordering system; this is not the system that MountainDesign uses to sell sporting goods to its customers. This is the system MountainDesign uses to buy materials from its vendors. MountainDesign usually refers to the materials it buys from vendors as products.

Answer 1

The question is about setting up a database for a purchase order system in the SQL Server Management Studio (SSMS) for MountainDesign, LLC, which is a sporting goods manufacturing company. The focus is on creating and populating tables with constraints that will aid in managing the company's material procurement from various vendors.

Step-by-step explanation:

The subject of the question is the creation and population of tables using SQL Server and specifically within the SQL Server Management Studio (SSMS) for a company named MountainDesign, LLC. This company specializes in sporting goods manufacturing and the database in question is to be used for their purchase order system, which is involved in buying materials from vendors for product manufacturing.

The assignment does not concern a customer ordering system but rather an internal system to streamline MountainDesign's procurement process. Given this application scenario, students would need to understand how to set up a relational database, including designing tables, applying constraints, and entering data relevant to MountainDesign's operations and supply chain management.