Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- A grupa
- -- 1. zadatak
- -- a)
- ALTER TABLE Glumac ADD Spol CHAR(1);
- -- b)
- ALTER TABLE Glumac ADD CONSTRAINT glumac_chk_spol CHECK(Spol IN ('M', 'Z'));
- -- c)
- ALTER TABLE Filmovi ALTER COLUMN Naslov VARCHAR(100);
- -- d)
- ALTER TABLE IzdavackaKuca DROP COLUMN Drzava;
- -- 2. zadatak
- -- a)
- INSERT INTO Glumac VALUES ('15', 'Enio', 'Dordan');
- -- b)
- INSERT INTO Filmovi (IDFilma, Naslov, Trajanje) VALUES ('5', 'Parasite', '132');
- -- c)
- UPDATE IzdavackaKuca SET NazivKuce = 'Twentieth Century Fox' WHERE NazivKuce = '20th Century Fox';
- -- d)
- DELETE FROM Filmovi WHERE (DatumIzdavanja BETWEEN '01/07/2007' AND '31/12/2007') AND (Trajanje < 120);
- -- 3. zadatak
- -- a)
- SELECT COUNT(*) FROM Glumac WHERE Ime LIKE 'P%' AND Prezime LIKE 'C%';
- -- b)
- SELECT Naslov, DatumIzdavanja, Trajanje FROM Filmovi WHERE Trajanje = (SELECT MIN(Trajanje) FROM Filmovi);
- -- c)
- SELECT YEAR(DatumIzdavanja), AVG(Trajanje) FROM Filmovi GROUP BY YEAR(DatumIzdavanja) ORDER BY 1 DESC;
- --d)
- CREATE VIEW FilmInfo AS SELECT Naslov, Trajanje, NazivKuce, SUBSTRING(Drzava, 1, 3) FROM Filmovi, IzdavackaKuca;
- -- 4. zadatak
- CREATE FUNCTION Funkcija (@n INT) RETURNS INT
- AS
- BEGIN
- DECLARE @rez = INT;
- SET @rez = 0;
- IF @n<0
- BEGIN
- SET @rez = ABS(@n);
- END
- ELSE
- BEGIN
- DECLARE @brojac = 0
- WHILE @brojac < @n
- BEGIN
- IF @n%2=0
- BEGIN
- SET @rez = @rez + @brojac;
- END
- END
- END
- RETURN @rez;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement