Creating the School Sample Database
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.
On the File menu, click Connect Object Explorer.
In the Connect to Database Engine dialog box, type either localhost or the name of the local SQL Server instance, and then click Connect.
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.
You have successfully created the School database. Next, you will create the class scheduling application: