Code:
CREATE DATABASE <Student>
[ON [ PRIMARY]
(NAME = N’Student’,
FILENAME = N’C:Programfiles Microsoft SQL
ServerMSSQL10.MSSQLSERVERMSSQLDATAStudentDB.mdf’,
SIZE = 3000KB ,
MAXSIZE = UNLIMITED
FILEGROWTH = 10%)
USE (student)
GO
CREATE TABLE KOMINTENT
(
KOMINTENTNO int IDENTITY NOT NULL,
predmet varchar(30) not null,
profesor varchar(30) not null,
profesorpredmet varchar(30) not null,
student varchar(30) not null,
studentpredmet CHAR (11) NOT NULL,
)
CREATE VIEW student (profesorpredmet,student predmet)
INSERT INTO predmet (microsoft SQL 2...,Oracle 10g,Programiranje C,Programiranje V,Programiranje C,WEB programiranje,WEB programiranje,WEB programiranje)
VALUES (80,80,40,40,40,40,40,40)
INSERT INTO Profesor (imeTimotije'imeKrstivoje'imeLjiljana'prezimeTrandafilovic'prezimeKrstic'prezimeLilic)
INSERT INTO profesorpredmet (profesor1,profesor1,profesor2,profesor2profesor2,predmet3,predmet4,predmet2,predmet7,predmet8,predmet1,predmet5,predmet6)
INSERT INTO Student (ImePera,ImeRuzica,ImePetar,ImeZorica,ImeNikola)
INSERT INTO Student (PrezimePeric,PrezimeRuzic,PrezimePetrovic,PrezimeZoric,PrezimeNikolic)
INSERT INTO Student (BrojIndexa120/2007,BrojIndexa121/2007,BrojIndexa122/2007,BrojIndexa125/2007,BrojIndexa130/2007)
INSERT INTO Student (Telefon011455433,Telefon011455523,Telefon024232322,Telefon021235566,Telefon023558779)
INSERT INTO StudentPredmet (Student1,Student1,Student1,Student2,Student2,Student3,Student3,Student3,Student4,Student4,Student5,Student5,Student5,Student5)
INSERT INTO StudentPredmet (Predmet1,Predmet7,Predmet8,Predmet1,Predmet2,Predmet1,Predmet5,Predmet6,Predmet1,Predmet7,Predmet1,Predmet2,Predmet3,Predmet4)
INSERT INTO StudentPredmet (Ocena9,Ocena7,Ocena10,Ocena10,Ocena10,Ocena9,Ocena10,Ocena10,Ocena10,Ocena9,Ocena8,Ocena10,Ocena9,Ocena9)
CREATE VIEW ProfesorPredmet
SELECT Ime,Prezime,Naziv,BrojCasova
FROM Predmet
WHERE Profesor
CREATE VIEW StudentPredmet
SELECT Ime,Prezime,BrojIndexa
FROM Student
WHERE predmet
SKYPE: varan024