USE [master] GO /****** Object: Database [University] Script Date: 02/12/2012 18:08:13 ******/ CREATE DATABASE [University] ON PRIMARY ( NAME = N'University', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\University.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'University_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\University_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO ALTER DATABASE [University] SET COMPATIBILITY_LEVEL = 100 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [University].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [University] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [University] SET ANSI_NULLS OFF GO ALTER DATABASE [University] SET ANSI_PADDING OFF GO ALTER DATABASE [University] SET ANSI_WARNINGS OFF GO ALTER DATABASE [University] SET ARITHABORT OFF GO ALTER DATABASE [University] SET AUTO_CLOSE OFF GO ALTER DATABASE [University] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [University] SET AUTO_SHRINK OFF GO ALTER DATABASE [University] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [University] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [University] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [University] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [University] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [University] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [University] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [University] SET DISABLE_BROKER GO ALTER DATABASE [University] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [University] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [University] SET TRUSTWORTHY OFF GO ALTER DATABASE [University] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [University] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [University] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [University] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [University] SET READ_WRITE GO ALTER DATABASE [University] SET RECOVERY SIMPLE GO ALTER DATABASE [University] SET MULTI_USER GO ALTER DATABASE [University] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [University] SET DB_CHAINING OFF GO USE [University] GO /****** Object: Table [dbo].[GRADE_REPORT] Script Date: 02/12/2012 18:08:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[GRADE_REPORT]( [Section_Identifier] [int] NOT NULL, [Student_Number] [int] NOT NULL, [Grade] [char](10) NULL, PRIMARY KEY CLUSTERED ( [Section_Identifier] ASC, [Student_Number] 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].[COURSE] Script Date: 02/12/2012 18:08:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[COURSE]( [Course_Name] [char](50) NULL, [Course_Number] [char](10) NOT NULL, [Credit_Hours] [int] NULL, [Department] [char](50) NULL, PRIMARY KEY CLUSTERED ( [Course_Number] 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].[STUDENT] Script Date: 02/12/2012 18:08:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[STUDENT]( [Name] [char](50) NULL, [Student_Number] [int] NOT NULL, PRIMARY KEY CLUSTERED ( [Student_Number] 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].[SECTION] Script Date: 02/12/2012 18:08:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SECTION]( [Section_Indentifier] [int] NOT NULL, [Course_Number] [char](10) NULL, [Semester] [char](50) NULL, [S_Year] [int] NULL, [S_Instructor] [char](50) NULL, PRIMARY KEY CLUSTERED ( [Section_Indentifier] 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].[PREREQUISITE] Script Date: 02/12/2012 18:08:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[PREREQUISITE]( [Course_Number] [char](10) NULL, [Prerequisite_Number] [char](10) NOT NULL, PRIMARY KEY CLUSTERED ( [Prerequisite_Number] 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: ForeignKey [FK__SECTION__Course___21B6055D] Script Date: 02/12/2012 18:08:13 ******/ ALTER TABLE [dbo].[SECTION] WITH CHECK ADD FOREIGN KEY([Course_Number]) REFERENCES [dbo].[COURSE] ([Course_Number]) ON DELETE CASCADE GO /****** Object: ForeignKey [FK__PREREQUIS__Cours__2B3F6F97] Script Date: 02/12/2012 18:08:13 ******/ ALTER TABLE [dbo].[PREREQUISITE] WITH CHECK ADD FOREIGN KEY([Course_Number]) REFERENCES [dbo].[COURSE] ([Course_Number]) ON DELETE CASCADE GO INSERT INTO STUDENT (Name,Student_Number) Values ('PAPADOPOYLOS', 8) Go INSERT INTO STUDENT (Name,Student_Number) Values ('KANELOPOYLOS', 17) Go INSERT INTO STUDENT (Name,Student_Number) Values ('DHMOY', 3) Go INSERT INTO COURSE (Course_Name, Course_Number,Credit_Hours,Department) Values ('Intro to Computer Science', 'CS1310', 4, 'CS') GO INSERT INTO COURSE (Course_Name, Course_Number,Credit_Hours,Department) Values ('Data Structures', 'CS3320', 4, 'CS') GO INSERT INTO COURSE (Course_Name, Course_Number,Credit_Hours,Department) Values ('Database', 'CS3380', 3, 'CS') Go INSERT INTO COURSE (Course_Name, Course_Number,Credit_Hours,Department) Values ('Discrete Mathematics', 'MATH2410', 3, 'MATH') GO INSERT INTO PREREQUISITE (Course_Number, Prerequisite_Number) Values ('CS3380', 'CS3320') GO INSERT INTO PREREQUISITE (Course_Number, Prerequisite_Number) Values ('CS3380', 'MATH2410') GO INSERT INTO PREREQUISITE (Course_Number, Prerequisite_Number) Values ('CS3320', 'CS1310') GO INSERT INTO SECTION (Section_Indentifier, Course_Number, Semester, S_Year, S_Instructor) Values (85, 'MATH2410', 'Fall', 4, 'King') Go INSERT INTO SECTION (Section_Indentifier, Course_Number, Semester, S_Year, S_Instructor) Values (92, 'CS1310', 'Fall', 4, 'Anderson') Go INSERT INTO SECTION (Section_Indentifier, Course_Number, Semester, S_Year, S_Instructor) Values (102, 'CS3320', 'Spring', 5, 'Knuth') Go INSERT INTO SECTION (Section_Indentifier, Course_Number, Semester, S_Year, S_Instructor) Values (112, 'MATH2410', 'Fall', 5, 'Chang') Go INSERT INTO SECTION (Section_Indentifier, Course_Number, Semester, S_Year, S_Instructor) Values (119, 'CS1310', 'Fall', 5, 'Anderson') Go INSERT INTO SECTION (Section_Indentifier, Course_Number, Semester, S_Year, S_Instructor) Values (125, 'CS3380', 'Fall', 5, 'Stone') Go INSERT INTO GRADE_REPORT (Section_Identifier,Student_Number,Grade) Values (85,8,'A') Go INSERT INTO GRADE_REPORT (Section_Identifier,Student_Number,Grade) Values (92,8,'A') Go INSERT INTO GRADE_REPORT (Section_Identifier,Student_Number,Grade) Values (102,8,'B') Go INSERT INTO GRADE_REPORT (Section_Identifier,Student_Number,Grade) Values (112,17,'B') Go INSERT INTO GRADE_REPORT (Section_Identifier,Student_Number,Grade) Values (119,17,'C') Go INSERT INTO GRADE_REPORT (Section_Identifier,Student_Number,Grade) Values (135,8,'A') Go