數(shù)據(jù)庫課程設(shè)計--在線網(wǎng)上訂餐系統(tǒng)-文庫吧
2025-01-01 16:01 本頁面
【正文】 ，訂單時間，數(shù)量，客戶地址，狀態(tài)）管理客戶（管理員編號，客戶編號，時間，操作類別）管理商家（管理員編號，商家編號，時間，操作類別） ER具體轉(zhuǎn)換代碼①客戶表：create table client(c_id varchar(9) primary key not null check(c_id like 39。c%39。), c_name varchar(20) not null, c_key varchar(20) not null, c_tel varchar(11) not null check(c_tel like 39。1%39。) unique )②管理員表：create table manager( m_id varchar(4) primary key not null check(m_id like 39。m%39。), m_name varchar(20) not null, m_key varchar(20) not null)③商家表：create table provider(p_id varchar(9) primary key not null check(p_id like 39。p%39。), p_name varchar(20) not null, p_key varchar(20) not null, p_tel varchar(11) not null unique check(p_tel like 39。1%39。), p_add varchar(30) not null unique, p_lev int, p_state varchar(15) check (p_state in (39。營業(yè)中39。,39。打烊39。,39。歇業(yè)39。)))④菜譜：create table dish(d_id int identity(1378001,1) primary key not null, d_name varchar(30) not null, d_price float(2) not null, d_discount float(2), d_pid varchar(9) not null , foreign key (d_pid) references provider(p_id), d_remain int not null check (d_remain=0), d_total int not null, )⑤訂單：create table ord(o_id int identity(10000001,1) primary key not null, o_cid varchar(9), foreign key (o_cid) references client (c_id), o_did int, foreign key (o_did) references dish (d_id), o_pid varchar(9), foreign key (o_pid) references provider (p_id), o_time smalldatetime, o_num int not null check (o_num0), o_cadd varchar(50) not null, o_state varchar(15) check (o_state in(39。正常39。,39。取消39。)))⑥管理客戶：create table manager_client(m_c_mid varchar(4), foreign key (m_c_mid) references manager (m_id), m_c_cid varchar(9), foreign key (m_c_cid) references client (c_id), m_c_time smalldatetime, primary key (m_c_mid,m_c_cid,m_c_time), m_c_operation varchar(15) check (m_c_operation in(39。更新39。,39。增加39。,39。刪除39。)))⑦管理商店：create table manager_provider(m_p_mid varchar(4), foreign key (m_p_mid) references manager (m_id), m_p_pid varchar(9), foreign key (m_p_pid) references provider (p_id), m_p_time smalldatetime, primary key (m_p_mid,m_p_pid,m_p_time), m_c_operation varchar(15) check (m_c_operation in(39。允許注冊39。,39。注銷賬戶39。) ))四、完整性、安全性等方面設(shè)計c_id varchar(9) primary key not nullm_id varchar(4) primary key not nullp_id varchar(9) primary key not null1）菜譜表參照關(guān)系菜譜中的商店標(biāo)號參照商店表的主碼：foreign key (d_pid) references provider(p_id)2）訂單表參照關(guān)系訂單中的客戶號參照客戶表的主碼：foreign key (o_cid) references client (c_id),訂單表中的菜譜號參照菜譜表的主碼：foreign key (o_did) references dish (d_id),訂單表中的商店號參照商店表的主碼：foreign key (o_pid) references provider (p_id),3）管理客戶表管理客戶表中的客戶號參照客戶表的主碼：foreign key (m_c_mid) references manager (m_id),管理客戶表中的管理員號參照管理員表的主碼：foreign key (m_c_cid) references client (c_id),4）管理商店表管理商店表的商店號參考商店表的主碼：foreign key (m_p_mid) references manager (m_id),管理商店表的管理員號參照管理員表的主碼：foreign key (m_p_pid) references provider (p_id),1）client表①c_id not null check(c_id like 39。c%39。),②c_name c_key not null,③c_tel not null check(c_tel like 39。1%39。) unique2）manager表①m_id not null check(m_id like 39。m%39。),②m_name，m_key not null,3）provider表①p_id not null check(p_id like 39。p%39。),②p_name，p_key， not null,③p_tel not null unique check(p_tel like 39。1%39。),④p_add not null unique,⑤p_state check (p_state in (39。營業(yè)中39。,
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1