CREATE DATABASE sqlDB GO USE sqlDB CREATE TABLE userTbl -- »ç¿ëÀÚÅ×À̺í ( userID char(8) NOT NULL PRIMARY KEY, -- »ç¿ëÀÚ¾ÆÀ̵ð name nvarchar(10) NOT NULL, -- À̸§ birthYear int NOT NULL, -- Ãâ»ý³âµµ addr nchar(2) NOT NULL, -- Áö¿ª(°æ±â,¼­¿ï,°æ³² ½ÄÀ¸·Î2±ÛÀÚ¸¸ÀÔ·Â) mobile1 char(3), -- ÈÞ´ëÆùÀDZ¹¹ø(011, 016, 017, 018, 019, 010 µî) mobile2 char(8), -- ÈÞ´ëÆùÀdzª¸ÓÁöÀüÈ­¹øÈ£(ÇÏÀÌÇÂÁ¦¿Ü) height smallint, -- Å° mDate date -- ȸ¿ø °¡ÀÔÀÏ ) GO CREATE TABLE buyTbl -- »ç¿ëÀÚ±¸¸ÅÅ×À̺í ( num int IDENTITY NOT NULL PRIMARY KEY, -- ¼ø¹ø(PK) userid char(8) NOT NULL --¾ÆÀ̵ð(FK) FOREIGN KEY REFERENCES userTbl(userid), prodName nchar(6) NOT NULL, -- ¹°Ç°¸í groupName nchar(4) , -- ºÐ·ù price int NOT NULL, -- ´Ü°¡ amount smallint NOT NULL -- ¼ö·® ) GO INSERT INTO userTbl VALUES('YJS', N'À¯Àç»è', 1972, N'¼­¿ï', '011', '1111111', 178, '2008-8-8') INSERT INTO userTbl VALUES('KHD', N'°­Èĵ¿', 1970, N'°æºÏ', '011', '2222222', 182, '2007-7-7') INSERT INTO userTbl VALUES('KKJ', N'±è±¹Â¡', 1965, N'¼­¿ï', '019', '3333333', 171, '2009-9-9') INSERT INTO userTbl VALUES('KYM', N'±è¿ë¸Õ', 1967, N'¼­¿ï', '011', '4444444', 177, '2005-5-5') INSERT INTO userTbl VALUES('KJD', N'±èÁ¦µÕ', 1974, N'°æ³²', NULL , NULL , 173, '2003-3-3') INSERT INTO userTbl VALUES('NHS', N'³²È÷¼®', 1971, N'Ãæ³²', '016', '6666666', 180, '2004-4-4') INSERT INTO userTbl VALUES('SDY', N'½Åµ¿¾÷', 1971, N'°æ±â', NULL , NULL , 176, '2010-10-10') INSERT INTO userTbl VALUES('LHJ', N'ÀÌÈÖÀú', 1972, N'¼­¿ï', '011', '8888888', 180, '2009-4-4') INSERT INTO userTbl VALUES('LKK', N'ÀÌ°­±Ô', 1960, N'°æ³²', '018', '9999999', 170, '2008-8-8') INSERT INTO userTbl VALUES('PSH', N'¹Ú¼öÄO', 1970, N'¼­¿ï', '019', '0000000', 183, '2011-5-5') GO INSERT INTO buyTbl VALUES('KHD', N'¿îµ¿È­', NULL , 30, 2) INSERT INTO buyTbl VALUES('KHD', N'³ëÆ®ºÏ', N'ÀüÀÚ', 1000, 1) INSERT INTO buyTbl VALUES('KYM', N'¸ð´ÏÅÍ', N'ÀüÀÚ', 200, 1) INSERT INTO buyTbl VALUES('PSH', N'¸ð´ÏÅÍ', N'ÀüÀÚ', 200, 5) INSERT INTO buyTbl VALUES('KHD', N'û¹ÙÁö', N'ÀÇ·ù', 50, 3) INSERT INTO buyTbl VALUES('PSH', N'¸Þ¸ð¸®', N'ÀüÀÚ', 80, 10) INSERT INTO buyTbl VALUES('KJD', N'Ã¥' , N'¼­Àû', 15, 5) INSERT INTO buyTbl VALUES('LHJ', N'Ã¥' , N'¼­Àû', 15, 2) INSERT INTO buyTbl VALUES('LHJ', N'û¹ÙÁö', N'ÀÇ·ù', 50, 1) INSERT INTO buyTbl VALUES('PSH', N'¿îµ¿È­', NULL , 30, 2) INSERT INTO buyTbl VALUES('LHJ', N'Ã¥' , N'¼­Àû', 15, 1) INSERT INTO buyTbl VALUES('PSH', N'¿îµ¿È­', NULL , 30, 2) GO SELECT * FROM userTbl SELECT * FROM buyTbl USE master BACKUP DATABASE sqlDB TO DISK = 'C:\sqlDB2008.bak'