Sql Unit 3 Ip

Sequel Script

USE [CTUNov2015]

GO

/****** Object: Table [dbo].[tblAdvisors] Script Date: 11/17/2015 8:23:29 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblAdvisors](

[AdvisorID] [int] IDENTITY(1,1) NOT NULL,

[FirstName] [varchar](25) NOT NULL,

[LastName] [varchar](30) NOT NULL,

[EmailAddr] [varchar](100) NOT NULL,

CONSTRAINT [PK_tblAdvisors] PRIMARY KEY CLUSTERED

(

[AdvisorID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object: Table [dbo].[tblClasses] Script Date: 11/17/2015 8:23:29 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblClasses](

[ClassID] [int] IDENTITY(1,1) NOT NULL,

[ClassCode] [varchar](20) NOT NULL,

[ClassName] [varchar](20) NOT NULL,

[Description] [varchar](max) NOT NULL,

CONSTRAINT [PK_tblClasses] PRIMARY KEY CLUSTERED

(

[ClassID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object: Table [dbo].[tblStudent] Script Date: 11/17/2015 8:23:29 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblStudent](

[StudentsID] [int] IDENTITY(1,1) NOT NULL,

[FirstName] [varchar](25) NOT NULL,

[LastName] [varchar](30) NOT NULL,

[BirthDay] [date] NOT NULL,

[Gender] [nchar](10) NOT NULL,

[StartDate] [nchar](10) NOT NULL,

[GPA] [decimal](3, 2) NOT NULL,

[IsActive] [int] NOT NULL,

[Bio] [varchar](500) NOT NULL,

[AdvisorID] [int] NOT NULL,

CONSTRAINT [PK_tblStudent] PRIMARY KEY CLUSTERED

(

[StudentsID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,...