TBL_JURUSAN :

USE [DB_JNM]
GO

CREATE TABLE [dbo].[TBL_JURUSAN](
 [KodeJurusan] [VARCHAR](6) NOT NULL,
 [NamaJurusan] [VARCHAR](100) NULL,
 CONSTRAINT [PK_TBL_JURUSAN] PRIMARY KEY CLUSTERED
(
 [KodeJurusan] 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

INSERT INTO [dbo].[TBL_JURUSAN]
 ([KodeJurusan]
 ,[NamaJurusan])
 VALUES
 ('JUR001','HUKUM'),
 ('JUR002','SASTRA'),
 ('JUR003','EKONOMI'),
 ('JUR004','MANAGEMENT')
GO