酒店订餐系统数据库设计和实现(共6页).doc

精选优质文档-倾情为你奉上create database 酒店订餐系统on(name=酒店订餐,filename=D:酒店订餐.mdf,size=10,maxsize=50,filegrowth=5)log on(name =酒店订餐_log,filename=D:酒店订餐.ldf,size=5,maxsize=25,filegrowth=5)create table cookbook( Cooknumber char (9) primary key, /*菜单编号*/ name char (20) unique, /*菜单名*/ Member_price float (6), /*会员价格*/ constraint price_chk check (Member_price=0)