1 / 10

Primer modela iz ErWin-a - logički

Primer modela iz ErWin-a - logički. Primer modela iz ErWin-a - fizički. ErWin - Meni za izbor tipa DBMS. Primer – relacioni model u Access-u. OSNOVNI ELEMENTI SQL. prof D. Bečejski-Vujaklija. Structured Query Language (SQL).

demi
Download Presentation

Primer modela iz ErWin-a - logički

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Primer modela iz ErWin-a- logički

  2. Primer modela iz ErWin-a- fizički

  3. ErWin - Meni za izbor tipa DBMS

  4. Primer – relacioni model u Access-u

  5. OSNOVNI ELEMENTI SQL prof D. Bečejski-Vujaklija

  6. Structured Query Language (SQL) Relacioni jezik za upite, manipulaciju i upravljanje podacima. Predstavlja programski interfejs Sistema za upravljanje relacionom bazom podataka (RDBMS). Prihvaćen ANSI standardom

  7. DEFINISANJE BAZE CREATE TABLE – kreiranje tabele CREATE VIEW – kreiranje pogleda CREATE INDEX – kreiranje indeksa ALTER TABLE – redefinisanje tabele DROP TABLE – brisanje tabele DROP VIEW – brisanje pogleda MANIPULACIJA PODACIMA INSERT – dodavanje redova u tabelu UPDATE – izmene podataka DELETE – brisanje podataka UPRAVLJANJE PODACIMA GRANT CONNECT- dodela privilegije REVOKE – ukidanje privilegije COMMIT – prenos transakcije iz bafera u tabelu ROLLBACK – ponistavanje izmena u tabelama LOCK TABLE – zakljucavanje tabela Pregled najčešćih SQL naredbi

  8. Standardna struktura SQL upita SELECT kolona [, kolona2...] FROM [tabela]

  9. SQL – klauzule SELECT naredbe • WHERE - uslov • DISTINCT – eliminacija duplih vrednosti • BETWEEN, NOT BETWEEN – operatori ranga • IN, NOT IN – operatori liste • LIKE, NOT LIKE – operatori uzorka • AND, OR – višestruki uslov • ORDER BY [ASC, DESC] – sortiranje • ....

  10. Primer za vežbu RADNIK ORG JED SIFRA OJ NAZIV OJ LOKACIJA OJ SIFRAR SIFRAOJ PREZIME IME POL DATUM ZAPOSL SIFRA RM KOEF PLATE 10 PRIPREMA PANCEVO 20 RAZVOJ NOVI SAD 30 PRODAJA BEOGRAD 40 PROIZVOD PAZOVA 101 10 PERIC PETAR M 11.03.1995 222 5 102 10 MIRIC MITAR M 02.03.1999 223 4 103 20 ILIC ANA Z 25.08.2000 235 4 104 30 JOVIC JOVAN M 20.03.1998 244 3 105 40 SIMIC SIMA M 15.05.1999 254 4 106 30 LAZIC STANA Z 10.10.2000 244 3

More Related