Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- use Student
- SELECT * FROM student_1
- INSERT INTO student_1 VALUES ('50204912485', 'Onur', 'Vassiljev', '58581201', 'Puru 20', 'Johvi', '31234')
- SELECT *
- INTO Students.dbo.student
- FROM student_1
- use Students
- SELECT * FROM student
- CREATE TABLE profession (id_profession INTEGER IDENTITY(10000,1) NOT NULL CONSTRAINT PK_id_profession PRIMARY KEY,
- name_profession CHAR(30) NOT NULL,
- short_name CHAR(2),
- date_reg DATE DEFAULT getDate())
- INSERT INTO profession (name_profession, short_name) VALUES('noorem tarkvaraarendaja', 'TV'),('keevitaja', 'KV')
- CREATE TABLE ruhm (id_group CHAR(10) NOT NULL CONSTRAINT PK_id_group PRIMARY KEY,
- school CHAR(15) NOT NULL DEFAULT 'pohikool', CHECK (school IN ('pohikool', 'kesk kool')),
- languageGroup CHAR(15) NOT NULL DEFAULT 'vene', CHECK (languageGroup IN ('vene', 'eesti')),
- city CHAR(15) NOT NULL DEFAULT 'Johvi', CHECK (city IN ('Johvi', 'Sillamae')),
- groupDate_reg DATE NOT NULL DEFAULT getDate(),
- profession INTEGER NOT NULL,
- CONSTRAINT FK_profession FOREIGN KEY(profession) REFERENCES profession (id_profession))
- INSERT INTO ruhm VALUES ('JPTVR18','pohikool','vene','Johvi',DEFAULT,10000)
- INSERT INTO ruhm VALUES ('JKKKR19','pohikool','eesti','Sillamae',DEFAULT,10001)
- CREATE TABLE opimine (sudent char(11) NOT NULL,
- ruhm CHAR(10) NOT NULL,
- start DATE NOT NULL DEFAULT getDate(),
- finish DATE NULL,
- status CHAR(20) NOT NULL, CHECK(status IN ('study','finish','expelled'))
- CONSTRAINT PK_opimine PRIMARY KEY (sudent, ruhm))
- INSERT INTO opilane VALUES (50208302215,'JPTVR18','2018-09-01',NULL,'study'),
- (50405028515,'KTVRI18','2017-09-01',DEFAULT,'finish'),
- (40405028512,'JKKKR19','2017-09-01','2017-12-06','expelled')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement