use?cai
go
create?table?菜系
(系號?char(3)?not?null?primary?key?check(len(系號)=3?and?substring(系號,1,1)='x'?and?substring(系號,2,2)like'[0-9][0-9]'),
菜系名稱?char(4)?not?null,
菜系特點?char?not?null,
)
create?table?代表菜
(菜號?char(3)?not?null?primary?key?check(len(菜號)=3?and?substring(菜號,1,1)='c'?and?substring(菜號,2,2)like'[0-9][0-9]'),
系號?char(3)?foreign?key(系號)?references?菜系(系號)not?null,
菜名?char?not?null,
菜譜?char?not?null,
特點?char?not?null)
create?table?代表飯店
(店號?char(3)?not?null?primary?key?check(len(店號)=3?and?substring(店號,1,1)='d'?and?substring(店號,2,2)like'[0-9][0-9]'),
菜號?char(3)?foreign?key(菜號)?references?代表菜(菜號)?not?null,
店名?char?not?null,
地址?char?not?null,
平均消費?char?not?null,
訂餐電話?char(8)?check(substring(訂餐電話,1,8)?like'[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')?not?null)
妳新建壹個cai數據庫（也可以是其他數據庫名，自己定），然後新建查詢，把上面的復制過去，對每個表進行逐次執行，然後刷新數據庫，就行了