餐厅数据库设计

)notnull,Pricesmallintnotnull);创建表FoodList:createtableFoodList(Mnoint,Fnosmallint,Fnumsmallintnotnull,Ftastechar(4),Pricelnfo(Fno)primarykey(Mno,Fno),foreignkey(Fno)references):创建表Orderinfo:createtableOrderlnfo(Cusnoint,primarykey(Cusno,Mno),foreignkey(Cusno)referencesCustomerlnfo(Cusno)):四、物理结构设计创建索引:createindexindex_PricelnfoonPricelnfo(Fno);createindexindex_FoodListonFoodList(Mno);createindexindex_OrderlnfoonOrderlnfo(Mno);createindexindex_FoodlnfoonFoodlnfo(Fname);createindexindex_CustomerlnfoonCustomerlnfo(Cusno);createindexindex_ChargelnfoonChargelnfo(Chargeno);createindexindex_C_C_AonC_C_A(Cusno);ountlnfo(Accountno);创建视图:createviewKitchenasselectMno,Fname,Fnum,FtastefromFoodList,PricelnfocreateviewDeliveryasselectTableno,Fname,Fnum,CusnumfromFoodList,Customerinfo,Orderlnfo,Priceinfo