36장 테이블 생성

Create Table tblPeople (     Name NVarChar(10) Primary Key,     Age Int Not Null,     Male Bit Not Null ); Insert Into tblPeople Values('정우성',36,1); Insert Into tblPeople Values('배용준',63,1); Insert Into tblPeople Values('고쇼용',12,1); Insert Into tblPeople Values('김태희',33,1); Select *From tblPeople Create Table tblSale (    OrderNo Int Identity(1,1) Primary Key,    Customer NVarChar(10) Not Null References tblPeople(Name),    Item NVarChar(20) Not Null,    oDate DateTime Not Null ); Insert Into tblSale(Customer,Item,oDate) Values                                                   ('정우성','면도기','2008/03/01'); Insert Into tblSale(Customer,Item,oDate) Values                                                   ('김태희','핸드폰','2008/03/03'); Insert Into tblSale(Customer,Item,oDate) Values                                                   ('김태희','휘발류','2008/03/04'); Insert Into tblSale(Customer,Item,oDate) Values                                                   ('고쇼용','화장품','2008/03/05'); Select *From tblSale