Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE student(
- ID_S NUMBER PRIMARY KEY,
- imie VARCHAR2(40) NOT NULL,
- nazwisko VARCHAR2(50) NOT NULL,
- data_ur DATE,
- miejsce_ur VARCHAR2(100) NOT NULL,
- pesel VARCHAR2(11) NOT NULL,
- adres_zam VARCHAR2(100)
- );
- CREATE TABLE wykladowca(
- ID_W NUMBER PRIMARY KEY,
- imie VARCHAR2(20) NOT NULL,
- nazwisko VARCHAR2(30) NOT NULL,
- ID_St NUMBER REFERENCES stopien(ID_St)
- );
- CREATE TABLE stopien(
- ID_St NUMBER PRIMARY KEY,
- nazwa VARCHAR2(40) NOT NULL
- );
- REFERENES - klucz obcy.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement