· 6 years ago · Apr 16, 2019, 10:56 AM
1USE [Studenti]
2GO
3/****** Object: ForeignKey [FK_Student_Smer] Script Date: 12/12/2012 22:03:26 ******/
4IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Student_Smer]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student]'))
5ALTER TABLE [dbo].[Student] DROP CONSTRAINT [FK_Student_Smer]
6GO
7/****** Object: ForeignKey [FK_Prijava_Predmet] Script Date: 12/12/2012 22:03:28 ******/
8IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Prijava_Predmet]') AND parent_object_id = OBJECT_ID(N'[dbo].[Prijava]'))
9ALTER TABLE [dbo].[Prijava] DROP CONSTRAINT [FK_Prijava_Predmet]
10GO
11/****** Object: ForeignKey [FK_Prijava_Student] Script Date: 12/12/2012 22:03:28 ******/
12IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Prijava_Student]') AND parent_object_id = OBJECT_ID(N'[dbo].[Prijava]'))
13ALTER TABLE [dbo].[Prijava] DROP CONSTRAINT [FK_Prijava_Student]
14GO
15/****** Object: StoredProcedure [dbo].[Ispiti] Script Date: 12/12/2012 22:03:28 ******/
16IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Ispiti]') AND type in (N'P', N'PC'))
17DROP PROCEDURE [dbo].[Ispiti]
18GO
19/****** Object: StoredProcedure [dbo].[spIspiti] Script Date: 12/12/2012 22:03:28 ******/
20IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spIspiti]') AND type in (N'P', N'PC'))
21DROP PROCEDURE [dbo].[spIspiti]
22GO
23/****** Object: Table [dbo].[Prijava] Script Date: 12/12/2012 22:03:28 ******/
24IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Prijava]') AND type in (N'U'))
25DROP TABLE [dbo].[Prijava]
26GO
27/****** Object: StoredProcedure [dbo].[ProfQuery] Script Date: 12/12/2012 22:03:28 ******/
28IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProfQuery]') AND type in (N'P', N'PC'))
29DROP PROCEDURE [dbo].[ProfQuery]
30GO
31/****** Object: StoredProcedure [dbo].[spJedanPredmet] Script Date: 12/12/2012 22:03:28 ******/
32IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spJedanPredmet]') AND type in (N'P', N'PC'))
33DROP PROCEDURE [dbo].[spJedanPredmet]
34GO
35/****** Object: StoredProcedure [dbo].[spSviPredmeti] Script Date: 12/12/2012 22:03:28 ******/
36IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spSviPredmeti]') AND type in (N'P', N'PC'))
37DROP PROCEDURE [dbo].[spSviPredmeti]
38GO
39/****** Object: Table [dbo].[Student] Script Date: 12/12/2012 22:03:26 ******/
40IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Student]') AND type in (N'U'))
41DROP TABLE [dbo].[Student]
42GO
43/****** Object: Table [dbo].[Smer] Script Date: 12/12/2012 22:03:26 ******/
44IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Smer]') AND type in (N'U'))
45DROP TABLE [dbo].[Smer]
46GO
47/****** Object: Table [dbo].[Predmet] Script Date: 12/12/2012 22:03:26 ******/
48IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Predmet]') AND type in (N'U'))
49DROP TABLE [dbo].[Predmet]
50GO
51/****** Object: Table [dbo].[Predmet] Script Date: 12/12/2012 22:03:26 ******/
52SET ANSI_NULLS ON
53GO
54SET QUOTED_IDENTIFIER ON
55GO
56IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Predmet]') AND type in (N'U'))
57BEGIN
58CREATE TABLE [dbo].[Predmet](
59 [PredmetID] [int] NOT NULL,
60 [Naziv] [nvarchar](40) NOT NULL,
61 [Profesor] [nvarchar](30) NULL,
62 CONSTRAINT [PK_Predmet] PRIMARY KEY CLUSTERED
63(
64 [PredmetID] ASC
65)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
66) ON [PRIMARY]
67END
68GO
69INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (10101, N'RaÄunarska matematika', N'Tomić')
70INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (20101, N'RaÄunarski sistemi', N'Pokorni')
71INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (30101, N'Strukture podataka', N'Pokorni')
72INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (40102, N'Osnovi programiranja', N'Urošević')
73INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (50102, N'Engleski jezik I', N'Terzić')
74INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (60102, N'RaÄunarske mreže', N'Pokorni')
75INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (70203, N'Programerski alati', N'Pajić')
76INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (80203, N'Engleski jezik II', N'Terzić')
77INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (90203, N'Objektno orjentisano programiranje', N'Urošević')
78INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (100204, N'Projektovanje informacionih sistema', N'Marković')
79INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (120204, N'Poslovni engleski za IT struÄnjake', N'Terzić')
80INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (130305, N'Elektronsko poslovanje', N'Stojanović')
81INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (140305, N'Internet marketing', N'KovaÄević')
82INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (150305, N'Internet programiranje', N'Simić')
83INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (160406, N'Praktikum primenjenog programiranja', N'Anđelić')
84INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (170406, N'ZaÅ¡tita raÄunarskih mreža', N'Pokorni')
85INSERT [dbo].[Predmet] ([PredmetID], [Naziv], [Profesor]) VALUES (180406, N'StruÄna praksa', NULL)
86/****** Object: Table [dbo].[Smer] Script Date: 12/12/2012 22:03:26 ******/
87SET ANSI_NULLS ON
88GO
89SET QUOTED_IDENTIFIER ON
90GO
91IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Smer]') AND type in (N'U'))
92BEGIN
93CREATE TABLE [dbo].[Smer](
94 [SmerID] [int] NOT NULL,
95 [Naziv] [nchar](40) NOT NULL,
96 CONSTRAINT [PK_Smer] PRIMARY KEY CLUSTERED
97(
98 [SmerID] ASC
99)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
100) ON [PRIMARY]
101END
102GO
103INSERT [dbo].[Smer] ([SmerID], [Naziv]) VALUES (101, N'Aplikativno programiranje ')
104INSERT [dbo].[Smer] ([SmerID], [Naziv]) VALUES (201, N'Internet programiranje ')
105INSERT [dbo].[Smer] ([SmerID], [Naziv]) VALUES (301, N'Projektovanje informacionih sistema ')
106INSERT [dbo].[Smer] ([SmerID], [Naziv]) VALUES (401, N'Menadžment u informacionim tehnologijama')
107INSERT [dbo].[Smer] ([SmerID], [Naziv]) VALUES (502, N'Elektronska trgovina i bankarstvo ')
108INSERT [dbo].[Smer] ([SmerID], [Naziv]) VALUES (602, N'Internet marketing sa Web dizajnom ')
109/****** Object: Table [dbo].[Student] Script Date: 12/12/2012 22:03:26 ******/
110SET ANSI_NULLS ON
111GO
112SET QUOTED_IDENTIFIER ON
113GO
114IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Student]') AND type in (N'U'))
115BEGIN
116CREATE TABLE [dbo].[Student](
117 [StudentID] [int] NOT NULL,
118 [Ime] [nvarchar](15) NOT NULL,
119 [Prezime] [nvarchar](20) NOT NULL,
120 [GodinaUpisa] [smallint] NOT NULL,
121 [DatumRodjenja] [nvarchar](10) NOT NULL,
122 [Skolarina] [real] NOT NULL,
123 [Prosek] [real] NULL,
124 [SmerID] [int] NOT NULL,
125 CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
126(
127 [StudentID] ASC
128)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
129) ON [PRIMARY]
130END
131GO
132INSERT [dbo].[Student] ([StudentID], [Ime], [Prezime], [GodinaUpisa], [DatumRodjenja], [Skolarina], [Prosek], [SmerID]) VALUES (10120081, N'Petar', N'Kostić', 2008, N'25.11.1998', 2000, 8.96, 101)
133INSERT [dbo].[Student] ([StudentID], [Ime], [Prezime], [GodinaUpisa], [DatumRodjenja], [Skolarina], [Prosek], [SmerID]) VALUES (10120087, N'Sandra', N'Pajić', 2008, N'13.11.1999', 1600, 7.57, 602)
134INSERT [dbo].[Student] ([StudentID], [Ime], [Prezime], [GodinaUpisa], [DatumRodjenja], [Skolarina], [Prosek], [SmerID]) VALUES (20120074, N'Marija', N'Martić', 2007, N'25.11.1990', 2000, 7.56, 201)
135INSERT [dbo].[Student] ([StudentID], [Ime], [Prezime], [GodinaUpisa], [DatumRodjenja], [Skolarina], [Prosek], [SmerID]) VALUES (20120085, N'Katarina', N'Pajić', 2008, N'07.04.1986', 2500, 9.4, 201)
136INSERT [dbo].[Student] ([StudentID], [Ime], [Prezime], [GodinaUpisa], [DatumRodjenja], [Skolarina], [Prosek], [SmerID]) VALUES (30120011, N'Ana', N'Vidić', 2011, N'27.12.1991', 1500, 8.75, 301)
137INSERT [dbo].[Student] ([StudentID], [Ime], [Prezime], [GodinaUpisa], [DatumRodjenja], [Skolarina], [Prosek], [SmerID]) VALUES (40120074, N'Nikola', N'Vidić', 2007, N'06.06.1985', 2000, 7.85, 401)
138INSERT [dbo].[Student] ([StudentID], [Ime], [Prezime], [GodinaUpisa], [DatumRodjenja], [Skolarina], [Prosek], [SmerID]) VALUES (50220095, N'Jasmina', N'Grujić', 2009, N'27.12.1988', 2000, 8.65, 502)
139INSERT [dbo].[Student] ([StudentID], [Ime], [Prezime], [GodinaUpisa], [DatumRodjenja], [Skolarina], [Prosek], [SmerID]) VALUES (60220073, N'Milan', N'Marković', 2007, N'07.12.1989', 1500, 6.76, 602)
140/****** Object: StoredProcedure [dbo].[spSviPredmeti] Script Date: 12/12/2012 22:03:28 ******/
141SET ANSI_NULLS ON
142GO
143SET QUOTED_IDENTIFIER ON
144GO
145IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spSviPredmeti]') AND type in (N'P', N'PC'))
146BEGIN
147EXEC dbo.sp_executesql @statement = N'-- =============================================
148-- Author: <Author,,Name>
149-- Create date: <Create Date,,>
150-- Description: <Description,,>
151-- =============================================
152CREATE PROCEDURE [dbo].[spSviPredmeti]
153AS
154BEGIN
155 select *
156 from Predmet
157 order by Naziv
158END
159'
160END
161GO
162/****** Object: StoredProcedure [dbo].[spJedanPredmet] Script Date: 12/12/2012 22:03:28 ******/
163SET ANSI_NULLS ON
164GO
165SET QUOTED_IDENTIFIER ON
166GO
167IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spJedanPredmet]') AND type in (N'P', N'PC'))
168BEGIN
169EXEC dbo.sp_executesql @statement = N'
170-- =============================================
171-- Author: <Author,,Name>
172-- Create date: <Create Date,,>
173-- Description: <Description,,>
174-- =============================================
175CREATE PROCEDURE [dbo].[spJedanPredmet]
176@predmetId char(10)
177AS
178BEGIN
179 select *
180 from Predmet
181 where PredmetID=@predmetId
182END
183
184'
185END
186GO
187/****** Object: StoredProcedure [dbo].[ProfQuery] Script Date: 12/12/2012 22:03:28 ******/
188SET ANSI_NULLS ON
189GO
190SET QUOTED_IDENTIFIER ON
191GO
192IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProfQuery]') AND type in (N'P', N'PC'))
193BEGIN
194EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[ProfQuery]
195(
196 @Prof nvarchar(30)
197)
198AS
199 SET NOCOUNT ON;
200SELECT PredmetID, Naziv, Profesor
201FROM Predmet
202WHERE (Profesor LIKE @Prof)
203ORDER BY Naziv'
204END
205GO
206/****** Object: Table [dbo].[Prijava] Script Date: 12/12/2012 22:03:28 ******/
207SET ANSI_NULLS ON
208GO
209SET QUOTED_IDENTIFIER ON
210GO
211IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Prijava]') AND type in (N'U'))
212BEGIN
213CREATE TABLE [dbo].[Prijava](
214 [PredmetID] [int] NOT NULL,
215 [StudentID] [int] NOT NULL,
216 [Ocena] [int] NOT NULL,
217 CONSTRAINT [PK_Prijava] PRIMARY KEY CLUSTERED
218(
219 [PredmetID] ASC,
220 [StudentID] ASC
221)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
222) ON [PRIMARY]
223END
224GO
225INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (10101, 10120081, 9)
226INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (10101, 10120087, 6)
227INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (10101, 20120074, 6)
228INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (10101, 20120085, 9)
229INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (10101, 30120011, 10)
230INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (10101, 40120074, 10)
231INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (10101, 60220073, 9)
232INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (30101, 10120081, 6)
233INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (30101, 10120087, 8)
234INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (30101, 20120085, 10)
235INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (30101, 40120074, 6)
236INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (40102, 10120081, 6)
237INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (40102, 10120087, 7)
238INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (40102, 20120074, 8)
239INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (40102, 20120085, 6)
240INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (50102, 10120081, 10)
241INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (50102, 10120087, 6)
242INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (50102, 30120011, 9)
243INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (50102, 60220073, 8)
244INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (70203, 10120081, 7)
245INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (70203, 10120087, 8)
246INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (70203, 20120074, 6)
247INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (80203, 20120074, 6)
248INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (80203, 40120074, 6)
249INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (90203, 20120074, 8)
250INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (100204, 10120081, 6)
251INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (100204, 20120074, 10)
252INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (100204, 30120011, 6)
253INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (120204, 10120081, 7)
254INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (130305, 10120081, 8)
255INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (130305, 50220095, 9)
256INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (140305, 10120081, 7)
257INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (140305, 20120085, 9)
258INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (160406, 10120081, 8)
259INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (170406, 10120081, 7)
260INSERT [dbo].[Prijava] ([PredmetID], [StudentID], [Ocena]) VALUES (180406, 10120081, 8)
261/****** Object: StoredProcedure [dbo].[spIspiti] Script Date: 12/12/2012 22:03:28 ******/
262SET ANSI_NULLS ON
263GO
264SET QUOTED_IDENTIFIER ON
265GO
266IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spIspiti]') AND type in (N'P', N'PC'))
267BEGIN
268EXEC dbo.sp_executesql @statement = N'-- =============================================
269-- Author: <Author,,Name>
270-- Create date: <Create Date,,>
271-- Description: <Description,,>
272-- =============================================
273CREATE PROCEDURE [dbo].[spIspiti]
274
275AS
276BEGIN
277 -- SET NOCOUNT ON added to prevent extra result sets from
278 -- interfering with SELECT statements.
279 SET NOCOUNT ON;
280
281 SELECT Prijava.StudentID, Prijava.PredmetID, Predmet.Naziv, Prijava.Ocena
282FROM Predmet INNER JOIN
283 Prijava ON Predmet.PredmetID = Prijava.PredmetID
284 where Predmet.PredmetID = Prijava.PredmetID
285END
286'
287END
288GO
289/****** Object: StoredProcedure [dbo].[Ispiti] Script Date: 12/12/2012 22:03:28 ******/
290SET ANSI_NULLS ON
291GO
292SET QUOTED_IDENTIFIER ON
293GO
294IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Ispiti]') AND type in (N'P', N'PC'))
295BEGIN
296EXEC dbo.sp_executesql @statement = N'-- =============================================
297-- Author: <Author,,Name>
298-- Create date: <Create Date,,>
299-- Description: <Description,,>
300-- =============================================
301CREATE PROCEDURE [dbo].[Ispiti]
302
303AS
304BEGIN
305 -- SET NOCOUNT ON added to prevent extra result sets from
306 -- interfering with SELECT statements.
307 SET NOCOUNT ON;
308
309 SELECT Prijava.StudentID, Prijava.PredmetID, Predmet.Naziv, Prijava.Ocena
310FROM Predmet INNER JOIN
311 Prijava ON Predmet.PredmetID = Prijava.PredmetID
312 where Predmet.PredmetID = Prijava.PredmetID
313END
314'
315END
316GO
317/****** Object: ForeignKey [FK_Student_Smer] Script Date: 12/12/2012 22:03:26 ******/
318IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Student_Smer]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student]'))
319ALTER TABLE [dbo].[Student] WITH CHECK ADD CONSTRAINT [FK_Student_Smer] FOREIGN KEY([SmerID])
320REFERENCES [dbo].[Smer] ([SmerID])
321GO
322IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Student_Smer]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student]'))
323ALTER TABLE [dbo].[Student] CHECK CONSTRAINT [FK_Student_Smer]
324GO
325/****** Object: ForeignKey [FK_Prijava_Predmet] Script Date: 12/12/2012 22:03:28 ******/
326IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Prijava_Predmet]') AND parent_object_id = OBJECT_ID(N'[dbo].[Prijava]'))
327ALTER TABLE [dbo].[Prijava] WITH CHECK ADD CONSTRAINT [FK_Prijava_Predmet] FOREIGN KEY([PredmetID])
328REFERENCES [dbo].[Predmet] ([PredmetID])
329GO
330IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Prijava_Predmet]') AND parent_object_id = OBJECT_ID(N'[dbo].[Prijava]'))
331ALTER TABLE [dbo].[Prijava] CHECK CONSTRAINT [FK_Prijava_Predmet]
332GO
333/****** Object: ForeignKey [FK_Prijava_Student] Script Date: 12/12/2012 22:03:28 ******/
334IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Prijava_Student]') AND parent_object_id = OBJECT_ID(N'[dbo].[Prijava]'))
335ALTER TABLE [dbo].[Prijava] WITH CHECK ADD CONSTRAINT [FK_Prijava_Student] FOREIGN KEY([StudentID])
336REFERENCES [dbo].[Student] ([StudentID])
337GO
338IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Prijava_Student]') AND parent_object_id = OBJECT_ID(N'[dbo].[Prijava]'))
339ALTER TABLE [dbo].[Prijava] CHECK CONSTRAINT [FK_Prijava_Student]
340GO