Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- C grupa
- -- 1. zadatak
- -- a)
- ALTER TABLE Filmovi ADD CONSTRAINT filmovi_chk_trajanje CHECK(Trajanje > 0 AND Trajanje < 600);
- -- b)
- ALTER TABLE Glumac ALTER COLUMN Ime VARCHAR(50);
- -- c)
- ALTER TABLE Filmovi DROP CONSTRAINT filmovi_chk_trajanje;
- -- d)
- ALTER TABLE Glumac ADD BrojFilmova INT;
- -- 2. zadatak
- -- a)
- INTERT INTO Filmovi (IDFilma, Naslov, DatumIzdavanja) VALUES ('5', 'Parasite', '2019');
- -- b)
- UPDATE Filmovi SET Trajanje = 120;
- -- c)
- UPDATE IzdavackaKuca SET Drzava = 'United States of America' WHERE Drzava = 'USA';
- -- d)
- DELETE FROM Filmovi WHERE (Trajanje > 115) AND (Naslov LIKE 'A%');
- -- 3. zadatak
- -- a)
- SELECT COUNT(*) FROM Filmovi WHERE Naslov LIKE 'The%';
- -- b)
- SELECT Naslov, DatumIzdavanja, Trajanje FROM Filmovi WHERE Trajanje = (SELECT MAX(Trajanje) FROM Filmovi);
- -- c)
- CREATE VIEW FilmInfo AS SELECT Naslov, YEAR(DatumIzdavanja), NazivKuce FROM Filmovi, IzdavackaKuca;
- --d)
- SELECT YEAR(DatumIzdavanja), AVG(Trajanje) FROM Filmovi GROUP BY YEAR(DatumIzdavanja) ORDER BY 1 DESC;
- -- 4. zadatak
- CREATE FUNCTION Funkcija (@n INT) RETURNS INT
- AS
- BEGIN
- DECLARE @rez = INT;
- IF @n=0
- BEGIN
- SET @rez = 0;
- END
- IF (@n>0 AND @n<=100)
- BEGIN
- SET @rez = 1;
- DECLARE @brojac = 0
- WHILE @brojac < @n
- BEGIN
- IF @n%2!=0
- BEGIN
- SET @rez = @rez * @brojac;
- END
- END
- END
- IF @n>100
- BEGIN
- SET @rez = 0;
- 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