Creating the School Sample Database

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

In this task, you will create the schema for the School database and load data into the database. To do this, you use SQL Server Management Studio or SQL Server Management Studio Express to execute a Transact-SQL script. The resulting School database is used as the relational data source in the rest of the tasks in this quickstart.

  1. On the File menu, point to New, and then click Database Engine Query.

  2. In the Connect to Database Engine dialog box, type either localhost or the name of the local SQL Server instance, and then click Connect.

  3. Paste the following Transact-SQL script in the query window and then click Execute.

  1. On the File menu, click Connect Object Explorer.

  2. In the Connect to Database Engine dialog box, type either localhost or the name of the local SQL Server instance, and then click Connect.

  3. In the Object Explorer window, expand the node for the newly connected instance, then expand Databases, expand School, expand Tables, and review the list of table objects in the database.

    The following shows a diagram of the School database schema.

SchoolDBDiagram

You have successfully created the School database. Next, you will create the class scheduling application:

Creating the Course Manager Application.

Show: