table creation, Sql Server

table creation

CREATE TABLE [dbo].[Film](
    [idFilm] [int] NOT NULL,
    [JudulFilm] [varchar](50) NOT NULL,
    [TanggalTayang] [date] NOT NULL
)

CREATE TABLE [dbo].[Member](
    [IdMember] [int] NOT NULL,
    [Umur] [int] NOT NULL
)

CREATE TABLE [dbo].[Review](
    [IdReview] [int] NOT NULL,
    [IdFilm] [int] NOT NULL,
    [IdMember] [int] NOT NULL,
    [Rating] [int] NULL
)

CREATE TABLE [dbo].[Survei](
    [idSurvei] [int] NOT NULL,
    [x] [float] NOT NULL,
    [y] [float] NOT NULL,
    [kebersihan] [int] NOT NULL
)

insert into film select 1,'The Godfather','20150418'
insert into film select 2,'The Shawshank Redemption','20150823'
insert into film select 3,'Schindler''s List','20151005'
insert into film select 4,'Raging Bull','20151120'
insert into film select 5,'Casablanca','20150815'
insert into film select 6,'Citizen Kane','20151218'
insert into film select 7,'Gone with the Wind','20150717'
insert into film select 8,'The Wizard of Oz','20150122'
insert into film select 9,'One Flew Over the Cuckoo''s Nest','20150328'
insert into film select 10,'Lawrence of Arabia','20150916'
insert into film select 11,'Vertigo','20151011'

insert into member select 1,24
insert into member select 2,26
insert into member select 3,28
insert into member select 4,34
insert into member select 5,23
insert into member select 6,28
insert into member select 7,28
insert into member select 8,30
insert into member select 9,24
insert into member select 10,35
insert into member select 11,28
insert into member select 12,33
insert into member select 13,20
insert into member select 14,28
insert into member select 15,35
insert into member select 16,17
insert into member select 17,34
insert into member select 18,23
insert into member select 19,25
insert into member select 20,18
insert into member select 21,24
insert into member select 22,20
insert into member select 23,23
insert into member select 24,35
insert into member select 25,17
insert into member select 26,24
insert into member select 27,35
insert into member select 28,25
insert into member select 29,21
insert into member select 30,18
insert into member select 31,29
insert into member select 32,25
insert into member select 33,25
insert into member select 34,20
insert into member select 35,27
insert into member select 36,21
insert into member select 37,35
insert into member select 38,26
insert into member select 39,28
insert into member select 40,28
insert into member select 41,30
insert into member select 42,30
insert into member select 43,35
insert into member select 44,22
insert into member select 45,26
insert into member select 46,27
insert into member select 47,35
insert into member select 48,26
insert into member select 49,23
insert into member select 50,21
insert into member select 51,23
insert into member select 52,28
insert into member select 53,21
insert into member select 54,25
insert into member select 55,29
insert into member select 56,33
insert into member select 57,30
insert into member select 58,24
insert into member select 59,31
insert into member select 60,17
insert into member select 61,34
insert into member select 62,27
insert into member select 63,31
insert into member select 64,29
insert into member select 65,19
insert into member select 66,19
insert into member select 67,20
insert into member select 68,33
insert into member select 69,32
insert into member select 70,29
insert into member select 71,19
insert into member select 72,28
insert into member select 73,19
insert into member select 74,30
insert into member select 75,34
insert into member select 76,33
insert into member select 77,35
insert into member select 78,27
insert into member select 79,24
insert into member select 80,35
insert into member select 81,22
insert into member select 82,17
insert into member select 83,21
insert into member select 84,27
insert into member select 85,19
insert into member select 86,26
insert into member select 87,17
insert into member select 88,18
insert into member select 89,26
insert into member select 90,22
insert into member select 91,20
insert into member select 92,28
insert into member select 93,18
insert into member select 94,34
insert into member select 95,24
insert into member select 96,17
insert into member select 97,35
insert into member select 98,26
insert into member select 99,32
insert into member select 100,30

insert into review select 1,11,54,0
insert into review select 2,6,30,3
insert into review select 3,3,10,5
insert into review select 4,4,57,2
insert into review select 5,11,99,3
insert into review select 6,5,96,3
insert into review select 7,9,68,4
insert into review select 8,10,74,5
insert into review select 9,6,37,2
insert into review select 10,11,23,4
insert into review select 11,1,98,2
insert into review select 12,8,99,3
insert into review select 13,1,61,2
insert into review select 14,11,27,0
insert into review select 15,10,44,4
insert into review select 16,8,2,0
insert into review select 17,7,5,3
insert into review select 18,11,5,1
insert into review select 19,6,33,4
insert into review select 20,8,59,2
insert into review select 21,5,71,0
insert into review select 22,10,96,3
insert into review select 23,5,48,3
insert into review select 24,10,85,4
insert into review select 25,8,11,2
insert into review select 26,1,74,0
insert into review select 27,5,15,0
insert into review select 28,1,40,0
insert into review select 29,7,20,0
insert into review select 30,1,2,1
insert into review select 31,3,55,2
insert into review select 32,10,43,0
insert into review select 33,1,89,3
insert into review select 34,10,74,5
insert into review select 35,10,32,5
insert into review select 36,10,47,4
insert into review select 37,2,90,3
insert into review select 38,2,94,4
insert into review select 39,2,50,3
insert into review select 40,7,12,4
insert into review select 41,2,21,2
insert into review select 42,8,55,2
insert into review select 43,7,94,4
insert into review select 44,2,53,3
insert into review select 45,4,17,1
insert into review select 46,7,63,4
insert into review select 47,11,51,5
insert into review select 48,7,36,1
insert into review select 49,11,19,3
insert into review select 50,10,90,0
insert into review select 51,7,7,5
insert into review select 52,6,17,1
insert into review select 53,9,92,5
insert into review select 54,11,89,2
insert into review select 55,9,54,0
insert into review select 56,7,7,0
insert into review select 57,7,38,1
insert into review select 58,1,20,2
insert into review select 59,1,98,5
insert into review select 60,8,9,2
insert into review select 61,4,76,5
insert into review select 62,9,99,5
insert into review select 63,3,12,0
insert into review select 64,3,18,4
insert into review select 65,10,50,1
insert into review select 66,10,14,2
insert into review select 67,9,8,0
insert into review select 68,7,21,2
insert into review select 69,3,75,3
insert into review select 70,11,81,1
insert into review select 71,11,13,3
insert into review select 72,8,94,3
insert into review select 73,5,38,4
insert into review select 74,8,35,5
insert into review select 75,4,72,0
insert into review select 76,9,81,2
insert into review select 77,7,59,0
insert into review select 78,9,43,1
insert into review select 79,10,44,1
insert into review select 80,9,47,4
insert into review select 81,9,89,4
insert into review select 82,6,69,1
insert into review select 83,7,83,0
insert into review select 84,1,69,0
insert into review select 85,3,89,1
insert into review select 86,4,42,5
insert into review select 87,3,67,5
insert into review select 88,5,69,4
insert into review select 89,6,14,5
insert into review select 90,9,90,4
insert into review select 91,4,68,1
insert into review select 92,11,64,1
insert into review select 93,7,58,0
insert into review select 94,7,12,1
insert into review select 95,1,7,2
insert into review select 96,1,41,3
insert into review select 97,2,14,4
insert into review select 98,1,86,1
insert into review select 99,8,31,0
insert into review select 100,6,35,4
insert into review select 101,8,12,0
insert into review select 102,8,39,5
insert into review select 103,6,51,3
insert into review select 104,6,22,3
insert into review select 105,10,37,0
insert into review select 106,7,59,3
insert into review select 107,2,79,1
insert into review select 108,2,64,1
insert into review select 109,7,19,4
insert into review select 110,10,17,5
insert into review select 111,8,2,2
insert into review select 112,11,28,3
insert into review select 113,11,1,2
insert into review select 114,3,94,1
insert into review select 115,7,47,3
insert into review select 116,9,13,4
insert into review select 117,5,69,0
insert into review select 118,7,25,5
insert into review select 119,1,14,4
insert into review select 120,8,21,2
insert into review select 121,1,100,3
insert into review select 122,10,64,5
insert into review select 123,3,65,2
insert into review select 124,2,45,3
insert into review select 125,11,10,5
insert into review select 126,4,23,2
insert into review select 127,9,45,1
insert into review select 128,7,76,4
insert into review select 129,8,49,5
insert into review select 130,7,67,3
insert into review select 131,8,63,4
insert into review select 132,9,83,2
insert into review select 133,1,97,0
insert into review select 134,1,36,3
insert into review select 135,6,96,1
insert into review select 136,5,48,5
insert into review select 137,6,31,3
insert into review select 138,10,26,4
insert into review select 139,5,75,2
insert into review select 140,7,82,5
insert into review select 141,7,11,2
insert into review select 142,5,81,4
insert into review select 143,1,61,1
insert into review select 144,9,78,5
insert into review select 145,10,42,1
insert into review select 146,6,81,4
insert into review select 147,2,69,1
insert into review select 148,10,10,2
insert into review select 149,4,78,0
insert into review select 150,10,23,1
insert into review select 151,4,9,5
insert into review select 152,5,95,5
insert into review select 153,9,61,2
insert into review select 154,6,87,3
insert into review select 155,3,51,5
insert into review select 156,3,7,4
insert into review select 157,6,65,1
insert into review select 158,7,89,4
insert into review select 159,7,13,1
insert into review select 160,7,67,0
insert into review select 161,4,38,3
insert into review select 162,2,94,0
insert into review select 163,6,20,2
insert into review select 164,1,73,2
insert into review select 165,7,90,5
insert into review select 166,5,21,2
insert into review select 167,5,93,4
insert into review select 168,9,74,5
insert into review select 169,9,19,1
insert into review select 170,10,79,2
insert into review select 171,7,86,5
insert into review select 172,1,35,3
insert into review select 173,8,71,3
insert into review select 174,9,41,5
insert into review select 175,1,29,4
insert into review select 176,4,59,1
insert into review select 177,11,14,2
insert into review select 178,8,38,4
insert into review select 179,6,66,0
insert into review select 180,1,78,0
insert into review select 181,1,54,0
insert into review select 182,6,24,1
insert into review select 183,4,26,3
insert into review select 184,1,43,2
insert into review select 185,10,19,4
insert into review select 186,6,21,0
insert into review select 187,3,56,5
insert into review select 188,2,42,0
insert into review select 189,5,36,3
insert into review select 190,1,35,3
insert into review select 191,5,49,5
insert into review select 192,6,45,2
insert into review select 193,11,92,3
insert into review select 194,2,52,1
insert into review select 195,4,91,1
insert into review select 196,7,96,2
insert into review select 197,8,48,5
insert into review select 198,6,16,1
insert into review select 199,10,37,5
insert into review select 200,11,92,4
insert into review select 201,6,70,2
insert into review select 202,9,41,2
insert into review select 203,4,31,4
insert into review select 204,11,46,0
insert into review select 205,11,34,3
insert into review select 206,1,38,2
insert into review select 207,9,34,5
insert into review select 208,2,11,0
insert into review select 209,2,53,4
insert into review select 210,8,21,3
insert into review select 211,4,81,0
insert into review select 212,2,61,3
insert into review select 213,10,54,2
insert into review select 214,11,40,0
insert into review select 215,4,13,2
insert into review select 216,11,21,2
insert into review select 217,7,28,0
insert into review select 218,1,70,4
insert into review select 219,9,73,4
insert into review select 220,7,80,5
insert into review select 221,5,67,2
insert into review select 222,8,4,2
insert into review select 223,2,41,5
insert into review select 224,5,76,1
insert into review select 225,8,5,4
insert into review select 226,10,6,0
insert into review select 227,10,9,3
insert into review select 228,6,65,5
insert into review select 229,10,11,5
insert into review select 230,10,15,2
insert into review select 231,8,89,0
insert into review select 232,6,76,5
insert into review select 233,4,76,5
insert into review select 234,8,47,3
insert into review select 235,9,34,0
insert into review select 236,4,33,5
insert into review select 237,10,70,1
insert into review select 238,6,92,3
insert into review select 239,5,87,1
insert into review select 240,2,94,0
insert into review select 241,6,96,4
insert into review select 242,3,3,4
insert into review select 243,5,24,5
insert into review select 244,1,61,0
insert into review select 245,11,66,2
insert into review select 246,2,12,0
insert into review select 247,1,94,0
insert into review select 248,2,20,5
insert into review select 249,3,57,5
insert into review select 250,2,30,4
insert into review select 251,7,4,1
insert into review select 252,6,29,0
insert into review select 253,10,18,5
insert into review select 254,2,81,4
insert into review select 255,11,56,1
insert into review select 256,11,51,1
insert into review select 257,8,39,3
insert into review select 258,4,41,3
insert into review select 259,5,20,2
insert into review select 260,5,88,0
insert into review select 261,7,68,5
insert into review select 262,7,8,5
insert into review select 263,4,87,3
insert into review select 264,4,32,1
insert into review select 265,3,69,0
insert into review select 266,7,66,0
insert into review select 267,1,67,2
insert into review select 268,8,38,1
insert into review select 269,1,32,4
insert into review select 270,11,89,1
insert into review select 271,3,84,0
insert into review select 272,6,63,2
insert into review select 273,4,85,1
insert into review select 274,9,100,1
insert into review select 275,10,24,1
insert into review select 276,3,73,3
insert into review select 277,11,24,1
insert into review select 278,10,39,3
insert into review select 279,7,27,2
insert into review select 280,6,83,3
insert into review select 281,5,69,2
insert into review select 282,11,23,0
insert into review select 283,6,71,1
insert into review select 284,1,29,0

insert into survei select 1,-145,-29,3
insert into survei select 2,-264,916,5
insert into survei select 3,967,25,0
insert into survei select 4,-915,186,2
insert into survei select 5,265,860,3
insert into survei select 6,-28,-215,0
insert into survei select 7,-381,505,5
insert into survei select 8,-377,898,4
insert into survei select 9,-638,110,4
insert into survei select 10,-303,279,4
insert into survei select 11,341,-790,4
insert into survei select 12,853,-955,4
insert into survei select 13,-904,-207,5
insert into survei select 14,992,900,0
insert into survei select 15,222,-825,0
insert into survei select 16,-663,-997,3
insert into survei select 17,635,-557,3
insert into survei select 18,-489,-404,5
insert into survei select 19,-324,-289,1
insert into survei select 20,-502,432,3
insert into survei select 21,-642,79,2
insert into survei select 22,210,961,0
insert into survei select 23,-156,237,4
insert into survei select 24,-990,-858,2
insert into survei select 25,-778,-393,2
insert into survei select 26,227,72,1
insert into survei select 27,424,-172,2
insert into survei select 28,499,-979,4
insert into survei select 29,698,-460,2
insert into survei select 30,176,841,1
insert into survei select 31,-601,-966,5
insert into survei select 32,689,396,0
insert into survei select 33,966,-235,1
insert into survei select 34,-594,703,4
insert into survei select 35,395,874,3
insert into survei select 36,577,-504,5
insert into survei select 37,22,332,5
insert into survei select 38,-927,13,0
insert into survei select 39,-460,-910,2
insert into survei select 40,406,325,5
insert into survei select 41,-764,-793,2
insert into survei select 42,-980,798,4
insert into survei select 43,-720,856,2
insert into survei select 44,480,-357,1
insert into survei select 45,197,354,2
insert into survei select 46,-727,-595,3
insert into survei select 47,-925,862,1
insert into survei select 48,103,-668,4
insert into survei select 49,-92,-977,0
insert into survei select 50,-360,-806,4
insert into survei select 51,31,-988,1
insert into survei select 52,-162,-568,3
insert into survei select 53,480,-345,3
insert into survei select 54,298,333,1
insert into survei select 55,-591,-155,1
insert into survei select 56,984,-861,0
insert into survei select 57,-184,-965,5
insert into survei select 58,-343,297,4
insert into survei select 59,-783,82,4
insert into survei select 60,485,-221,0
insert into survei select 61,-602,398,4
insert into survei select 62,934,154,0
insert into survei select 63,41,375,3
insert into survei select 64,-584,-614,0
insert into survei select 65,-961,893,0
insert into survei select 66,417,-368,5
insert into survei select 67,620,82,4
insert into survei select 68,287,76,2
insert into survei select 69,-734,-105,4
insert into survei select 70,626,366,4
insert into survei select 71,909,484,3
insert into survei select 72,-431,-528,3
insert into survei select 73,-177,-276,2
insert into survei select 74,-725,527,1
insert into survei select 75,-87,324,0
insert into survei select 76,-495,-787,0
insert into survei select 77,932,392,1
insert into survei select 78,361,-952,0
insert into survei select 79,496,43,2
insert into survei select 80,-505,936,5
insert into survei select 81,469,395,3
insert into survei select 82,-289,320,2
insert into survei select 83,-264,72,0
insert into survei select 84,64,-500,4
insert into survei select 85,-450,-254,1
insert into survei select 86,349,-158,3
insert into survei select 87,-929,596,0
insert into survei select 88,571,679,4
insert into survei select 89,114,679,2
insert into survei select 90,543,-980,0
insert into survei select 91,144,-180,0
insert into survei select 92,-520,-470,4
insert into survei select 93,-816,877,2
insert into survei select 94,106,454,0
insert into survei select 95,-187,717,3
insert into survei select 96,-198,202,1
insert into survei select 97,-872,-300,1
insert into survei select 98,81,-743,0
insert into survei select 99,469,760,5
insert into survei select 100,799,190,3


run \| edit \| history \| help	0