Lecture – Getting Started with SQL Server Management Studio

Summary of Video

This is a very simple video of creating a database inside of SQL Server Management Studio. It demonstrates creating a database, creating tables using both SQL and the wizards, setting up simple relationships, and the tools available in Management Studio.

Prerequisites

This is a first lecture in COP4709, students should have had a previous course in databases (COP4708 or COP2700)

Video Link

Support Materials

SQL Script to create tables as shown in Video

CREATE TABLE [dbo].[Artists](
[id] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
[name] [nvarchar](200) NULL)

CREATE TABLE [dbo].[Albums](
[id] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
[artistID] [int] FOREIGN KEY REFERENCES Artists(id) NULL,
[name] [nvarchar](200) NULL,
[year] [nvarchar](4) NULL)

CREATE TABLE [dbo].[Songs](
[id] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
[name] [nvarchar](200) NULL,
[albumID] [int] FOREIGN KEY REFERENCES Albums(id) NULL,
[TrackNumber] [int] NULL)