餐廳訂餐管理系統(tǒng)數(shù)據(jù)庫分析與設(shè)計(已改無錯字)
2022-11-17 03:37:52 本頁面
【正文】 /*性別 */ Ucode char (9), /*密碼 */ Telephone char(12), /*常用電話 */ Address char(40) /*收貨具體地點(diǎn) */ ) Create table controller (Cnumber char (9) primary key, Cname char (20), /*服務(wù)員 姓名 */ Csex char (4), /*服務(wù)員 性別 */ Cage smallint, /*服務(wù)員 年齡 */ Cdepartment char (20) /*服務(wù)員 部門 */ ) Create table food_data /*菜品資料 */ (systems char (10), /*菜系 */ Country char (20), /*國家 */ Name char (20) primary key, /*菜名 */ Price float (6) /*價格 */ ) /*建立索引 */ create unique index food on food_data(name) create unique index list on order_list(Lnumber) create unique index users on 用戶 (Unumber) Create view snack As Select produce, price From food_data Where name=39。泡粉 39。 Create view snack As Select produce, price From food_data Where name=39。湯圓 39。 Create view snack As Select produce, price From food_data Where name=39。年糕湯 39。 Create view Chinastyle_food As Select produce, price From food_data Where name=39。童子雞 39。 Create view Chinastyle_food As Select produce, price From food_data Where name=39。東坡肉 39。 Create view Chinastyle_food As Select produce, price From food_data Where name=39。佛跳墻 39。 Create view Chinastyle_food As Select produce, price From food_data Where name=39。酸菜魚 39。 Create view Chinastyle_food As Select produce, price From food_data Where name=39。水煮魚 39。 Create view Chinastyle_food As Select produce, price From food_data Where name=39。紅燒魚 39。 Create view Chinastyle_food As Select produce, price From food_data Where name=39。紅燒肉 39。 Create view Chinastyle_food As Select produce, price From food_data Where name=39。糖醋里脊 39。 Create view Chinastyle_food As Select produce, price From food_data Where name=39。西湖牛肉羹 39。 Create view snack As Select produce, price From food_data Where name=39。油炸冰激凌 39。 Create view Westernstyle_food As Select produce, price From food_data Where name=39。意大利面 39。 Create view Westernstyle_food As Select produce, price From food_data Where name=39
公司管理相關(guān)推薦
鄂ICP備17016276號-1