Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE CENNIK
- (
- ID_WYDZIALU NUMBER (6) NOT NULL ,
- NAZWA_WYDZIALU VARCHAR2 (20) NOT NULL ,
- CENA NUMBER (6,2) NOT NULL
- ) ;
- ALTER TABLE CENNIK ADD CONSTRAINT CENNIK_PK PRIMARY KEY ( ID_WYDZIALU ) ;
- CREATE TABLE OPŁATY
- (
- ID_OPLATY NUMBER (6) NOT NULL ,
- DATA DATE NOT NULL ,
- KSIEGUJACY VARCHAR2 (20) NOT NULL ,
- KWOTA NUMBER (6,2) NOT NULL ,
- STUDENT_NR_ALBUMU NUMBER (6) NOT NULL ,
- CENNIK_ID_WYDZIALU NUMBER (6) NOT NULL
- ) ;
- ALTER TABLE OPŁATY ADD CONSTRAINT OPŁATY_PK PRIMARY KEY ( ID_OPLATY ) ;
- CREATE TABLE STUDENT
- (
- NR_ALBUMU NUMBER (6) NOT NULL ,
- IMIE VARCHAR2 (20) NOT NULL ,
- NAZWISKO VARCHAR2 (20) NOT NULL
- ) ;
- ALTER TABLE STUDENT ADD CONSTRAINT STUDENT_PK PRIMARY KEY ( NR_ALBUMU ) ;
- ALTER TABLE OPŁATY ADD CONSTRAINT OPŁATY_CENNIK_FK FOREIGN KEY ( CENNIK_ID_WYDZIALU ) REFERENCES CENNIK ( ID_WYDZIALU ) ;
- ALTER TABLE OPŁATY ADD CONSTRAINT OPŁATY_STUDENT_FK FOREIGN KEY ( STUDENT_NR_ALBUMU ) REFERENCES STUDENT ( NR_ALBUMU ) ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement