餐厅订餐E-R图.docxVIP

createtable zhuowei(桌号varchar(20)primarykey,几人桌varchar(20)notnull,是否空varchar(10)notnulldefault空)Gocreatetable caidan(菜名varchar(20)unique,菜号varchar(20)primarykey,单价varchar(20)notnull)Gocreatetable jingli(帐号varchar(20)primarykey,密码varchar(20)unique,姓名varchar(20)notnull)Gocreatetable guke(身份证号varchar(20),VIP varchar(20),姓名varchar(20)notnull,性别varchar(2)notnulldefault男,手机varchar(20)notnull,primarykey(身份证号,VIP))gocreatedatabase cantingguanlionprimary(name=cantingguanli,filename=E:\can\cantingguanli.mdf,size=10mb,maxsize=100mb,filegrowth=5mb)logon(name=cantingguanli_log,filename=E:\can\cantingguanli