Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[Studenci](
- [nr] [int] IDENTITY(1,1) NOT NULL,
- [firstName] [varchar](25) NOT NULL,
- [lastName] [varchar](25) NOT NULL,
- [nr_indeksu] [int] NOT NULL,
- [id] [varchar](50) NOT NULL,
- PRIMARY KEY (nr))
- CREATE TABLE [dbo].[Przedmioty](
- [classID] [int] IDENTITY(1,1) NOT NULL,
- [className] [varchar](25) NOT NULL
- PRIMARY KEY (classID))
- CREATE TABLE [dbo].[Obecnosci](
- [nr] [int] IDENTITY(1,1) NOT NULL,
- [data] [varchar](25) NOT NULL,
- [classID] [int] NOT NULL,
- [group] [int] NOT NULL,
- [classStartDate] [varchar](5) NOT NULL,
- [classEndDate] [varchar](5) NOT NULL,
- [isPresent] [bit] NOT NULL,
- [id] [varchar](50) NOT NULL
- PRIMARY KEY (nr)
- FOREIGN KEY (classID) REFERENCES Przedmioty(classID))
- INSERT INTO Przedmioty(className)
- VALUES('PT-1')
- INSERT INTO Przedmioty(className)
- VALUES('PT-2')
- INSERT INTO Przedmioty(className)
- VALUES('TSM-1')
- INSERT INTO Przedmioty(className)
- VALUES('TSM-2')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Michal','Andrzejewski',131131,'013697D7')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Przemyslaw','Barlog',131123,'0136C21C')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Dominik','Blaszczyk',131733,'013697G8')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Robert','Blaszynski',131734,'0136C2T4')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Jan','Kowalski',131231,'01369891')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Piotr','Nowak',131198,'0136AB87')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Adam','Malysz',131112,'013697U2')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Mariusz','Pudzianowski',131199,'0136CZ73')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Robert','Kubica',131190,'013697F1')
- INSERT INTO Studenci(firstName,lastName,nr_indeksu,id)
- VALUES('Robert','Lewandowski',131195,'0136CZ75')
- INSERT INTO Obecnosci([data],classID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-05',1,'TI-1', '15:10','16:40',0,'013697D7')
- INSERT INTO Obecnosci([data],ID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-05',1,'TI-1', '15:10','16:40',1,'0136C21C')
- INSERT INTO Obecnosci([data],classID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-08',2,'TI-2', '08:00','09:30',1,'013697G8')
- INSERT INTO Obecnosci([data],ID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-08',2,'TI-2', '08:00','09:30',1,'0136C2T4')
- INSERT INTO Obecnosci([data],classID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-10',3,'TI-3', '09:45','11:15',0,'01369891')
- INSERT INTO Obecnosci([data],ID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-10',3,'TI-3', '09:45','11:15',1,'0136AB87')
- INSERT INTO Obecnosci([data],classID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-11',4,'TI-4', '15:10','16:40',1,'013697U2')
- INSERT INTO Obecnosci([data],ID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-05',4,'TI-4', '15:10','16:40',0,'0136CZ73')
- INSERT INTO Obecnosci([data],classID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-12',1,'TI-1', '15:10','16:40',0,'013697F1')
- INSERT INTO Obecnosci([data],ID,[group],classStartDate, classEndDate, isPresent,id)
- values('2019-06-12',2,'TI-1', '15:10','16:40',1,'0136CZ75')
- SELECT * FROM Obecnosci
- SELECT * FROM Studenci
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement