data

CREATE TABLE tutors (
    tutor_id INT IDENTITY(1,1),
    name VARCHAR(25) NOT NULL,
    last_name VARCHAR(25) NOT NULL,
    zip_code VARCHAR(5) NOT NULL,
    city VARCHAR(20) NOT NULL,
    street VARCHAR(50) NOT NULL,
    phone_number VARCHAR(15) NOT NULL,
    fax VARCHAR(15) NULL,
    email VARCHAR(15) NOT NULL,
    CONSTRAINT prim_tutor PRIMARY KEY(tutor_id)
);

CREATE TABLE students (
    student_id INT IDENTITY(1,1),
    name VARCHAR(25) NOT NULL,
    last_name VARCHAR(25) NOT NULL,
    index_no VARCHAR(20) NOT NULL,
    birth_date DATE NOT NULL,
    birth_place VARCHAR(20) NOT NULL,
    zip_code VARCHAR(5) NOT NULL,
    city VARCHAR(20) NOT NULL,
    street VARCHAR(50) NOT NULL,
    phone_number VARCHAR(15) NOT NULL,
    fax VARCHAR(15) NULL,
    email VARCHAR(15) NOT NULL,
    registration_date datetime DEFAULT getdate(),
    CONSTRAINT prim_stud PRIMARY KEY(student_id)
);


CREATE TABLE  subjects (
    subject_id INT IDENTITY(1,1),
    subject_name VARCHAR(20) NOT NULL,
    SUBJECT_specification VARCHAR(100) NULL,
    CONSTRAINT sub_prim PRIMARY KEY(subject_id)
);



CREATE TABLE places(
    place_id INT IDENTITY(1,1),
    building VARCHAR(10) NOT NULL,
    audience VARCHAR(10) NOT NULL,
    CONSTRAINT prim_place PRIMARY KEY(place_id)
);




INSERT INTO tutors VALUES ('James', 'Bond', '12345','Lodz', 'Piotrkowska 5', '696722246', NULL, 'bond@o2.pl');
INSERT INTO tutors VALUES ('James', 'Bond', '12345','Lodz', 'Piotrkowska 5', '696722246', NULL, 'bond@o2.pl');
INSERT INTO tutors VALUES ('James', 'Bond', '12345','Lodz', 'Piotrkowska 5', '696722246', NULL, 'bond@o2.pl');
INSERT INTO tutors VALUES ('Juan', 'Carlos', '14315','Lodz', 'Mickiewicza 5', '696832146', NULL, 'carlos@o2.pl');
INSERT INTO tutors VALUES ('Yoko', 'Ono', '22345','Lodz', 'Niciarniana 88', '596722246', NULL, 'ono@o2.pl');
INSERT INTO tutors VALUES ('James', 'Dean', '32445','Lodz', 'Malczewskiego 11', '456722246', NULL, 'dean@o2.pl');
INSERT INTO tutors VALUES ('Marilyn ', 'Monroe', '33345','Lodz', 'Aleksandrowska 123', '443322246', NULL, 'marlin@o2.pl');


INSERT INTO students VALUES ('Tom', 'Sawyer', '121475','10-10-1982','Lodz', '12345','Lodz', 'Piotrkowska 5', '696722246', NULL, 'bond@o2.pl', DEFAULT);
INSERT INTO students VALUES ('Bridget', 'Jones', '183475','12-12-2050','New York','22345','Lodz', 'Niciarniana 88', '596722246', NULL, 'ono@o2.pl', DEFAULT);
INSERT INTO students VALUES ('Audrey', 'Hepburn', '345675','04-05-1929' ,'Elsene','32445','Elsene', 'Malczewskiego 11', '456722246', NULL, 'dean@o2.pl', DEFAULT);
INSERT INTO students VALUES ('Marilyn ', 'Monroe', '121475','01-06-1926','Los Angeles', '33345','Lodz', 'Aleksandrowska 123', '443322246', NULL, 'marlin@o2.pl', DEFAULT);
INSERT INTO students VALUES ('Juan', 'DeMarcos','141415', '01-10-1943', 'Havana' ,'10000','Lodz', 'Mickiewicza 5', '696832146', NULL, 'carlos@o2.pl', DEFAULT);

INSERT INTO places(building,audience) VALUES ('EEIA', '121');
INSERT INTO places(building,audience) VALUES ('EEIA', '123');
INSERT INTO places(building,audience) VALUES ('FTIMS', '122');
INSERT INTO places(building,audience) VALUES ('FTIMS', '124');
INSERT INTO places(building,audience) VALUES ('EEIA', '114');


INSERT INTO subjects VALUES ('Maths', NULL);
INSERT INTO subjects VALUES ('Physics', NULL);
INSERT INTO subjects VALUES ('Electrotechnics', NULL);
INSERT INTO subjects VALUES ('Electronics', NULL);
INSERT INTO subjects VALUES ('Management', NULL);

INSERT INTO exams VALUES (1,1,1,'06-24-2010',1);
INSERT INTO exams VALUES (4,1,1,'06-24-2010',1);
INSERT INTO exams VALUES (1,2,1,'06-24-2010',1);
INSERT INTO exams VALUES (3,3,1,'06-24-2010',1);
INSERT INTO exams VALUES (2,4,1,'06-24-2010',1);