f7c3M4vU

1IF NOT EXISTS (SELECT name FROM master.sys.databases WHERE name = N'universitatea')
2    BEGIN
3      CREATE DATABASE universitatea;
4    END
5GO
6use universitatea
7GO
8IF NOT EXISTS(
9    SELECT *
10    FROM INFORMATION_SCHEMA.COLUMNS
11    WHERE TABLE_NAME = 'Discipline'
12)
13  BEGIN
14    CREATE TABLE [dbo].Discipline (
15      Id_Disciplina            INT          NOT NULL IDENTITY (100, 1) PRIMARY KEY,
16      [Disciplina]             varchar(255) NOT NULL,
17      [Nr_ore_plan_disciplina] SMALLINT     NULL,
18    )
19  END
20IF NOT EXISTS(
21    SELECT *
22    FROM INFORMATION_SCHEMA.COLUMNS
23    WHERE TABLE_NAME = 'Grupe'
24)
25  BEGIN
26    CREATE TABLE [dbo].Grupe (
27      Id_Grupa         SMALLINT     NOT NULL IDENTITY (1, 1) PRIMARY KEY,
28      [Cod_Grupa]      char(6)      NOT NULL,
29      [Specialitatea]  varchar(255) NULL,
30      [Nume_Facultate] varchar(255) NULL
31    )
32  END
33GO
34
35INSERT INTO [dbo].[Discipline] VALUES
36  ('Sisteme de operare', 60),
37  ('Programarea calculatoarelor', 60),
38  ('Informatica aplicata', 46),
39  ('Sisteme de calcul', 46),
40  ('Asamblarea si depanarea PC', 60),
41  ('Cercetari operationale', 76),
42  ('Programarea WEB', 46),
43  ('Baze de date', 60),
44  ('Structuri de date si algoritmi', 76),
45  ('Retele informatice', 46),
46  ('Matematica discreta', 60),
47  ('Modelarea sistemelor', 46),
48  ('Limbaje evaluate de programare (Java, .NET)', 76),
49  ('Programarea aplicatiilor Windows', 60),
50  ('Tehnologii de procesare a informatiei', 46),
51  ('Programarea declarativa', 46),
52  ('Proiectarea sistemelor informatice', 60),
53  ('Practica de licenta', 80),
54  ('Practica de productie', 80),
55  ('Integrarea informationale europeana', 20),
56  ('Programarea aplicativa', 46)
57
58INSERT INTO [dbo].[Grupe] VALUES
59  ('CIB171', 'Cibernetica', 'Informatica si cibernetica'),
60  ('INF171', 'Informatica', 'Informatica si cibernetica'),
61  ('TI171', 'Tehnologii informationale', 'Informatica si cibernetica')