individual project 5.docx - Individual Project 5 Clayton...

This preview shows page 1 - 3 out of 3 pages.

Individual Project 5Clayton BakerDiagramSCRIPT FOR DEGREE :USE[University]GO/****** Object:Table [dbo].[Degrees]Script Date: 11/5/2019 5:25:27 PM******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE[dbo].[Degrees]([DegreeID] [int]IDENTITY(1,1) NOT NULL,[DegreeName] [nchar](50) NULL,[Description] [nchar](1000) NULL,CONSTRAINT[PK_Degrees]PRIMARY KEY CLUSTERED([DegreeID]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
SCRIPT FOR DEGREE_CLASSES:USE[University]GO/****** Object:Table [dbo].[Degree_Classes]Script Date: 11/5/2019 5:26:12PM ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE[dbo].[Degree_Classes]([DegreeClassID] [int]IDENTITY(1,1) NOT NULL,[ClassID] [int]NULL,[DegreeID] [int]NULL,CONSTRAINT[PK_Degree_Classes]PRIMARY KEY CLUSTERED([DegreeClassID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GOALTER TABLE[dbo].[Degree_Classes]
End of preview. Want to read all 3 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
lewismcado
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture