Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- USE [master];
- GO
- IF EXISTS (SELECT * FROM sys.databases WHERE name = 'MyDatabase')
- DROP DATABASE MyDatabase;
- GO
- -- Create the MyDatabase database.
- CREATE DATABASE MyDatabase COLLATE SQL_Latin1_General_CP1_CI_AS;
- GO
- -- Specify a simple recovery model
- -- to keep the log growth to a minimum.
- ALTER DATABASE MyDatabase
- SET RECOVERY SIMPLE;
- GO
- USE MyDatabase;
- GO
- CREATE TABLE [dbo].[Course] (
- [CourseID] INT NOT NULL,
- [CourseName] NVARCHAR (50) NOT NULL,
- PRIMARY KEY CLUSTERED ([CourseID] ASC)
- );
- CREATE TABLE [dbo].[Student] (
- [StudentID] INT NOT NULL,
- [Name] NVARCHAR (50) NOT NULL,
- [Age] INT NULL,
- PRIMARY KEY CLUSTERED ([StudentID] ASC)
- );
- CREATE TABLE [dbo].[CourseSelection] (
- [ID] INT NOT NULL,
- [StudentID] INT NOT NULL,
- [CourseID] INT NOT NULL,
- PRIMARY KEY CLUSTERED ([ID] ASC),
- CONSTRAINT [FK_CourseSelection_ToTable] FOREIGN KEY ([StudentID]) REFERENCES [dbo].[Student] ([StudentID]) ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT [FK_CourseSelection_Course_1] FOREIGN KEY ([CourseID]) REFERENCES [dbo].[Course] ([CourseID]) ON DELETE NO ACTION ON UPDATE NO ACTION
- );
- CREATE TABLE [dbo].[LastStudent] (
- [StudentID] INT NOT NULL,
- [Name] NVARCHAR (50) NOT NULL,
- [Age] INT NULL,
- PRIMARY KEY CLUSTERED ([StudentID] ASC)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement