电脑销售数据库设计
sLEAD VARCHAR(4) )
建立营业员表: CREATE TABLE assistant (aID CHAR(6) PRIMARY KEY, aNAME VARCHAR(4), aFEAT INT )
建立门店表: CREATE TABLE shop
(shID CHAR(6) PRIMARY KEY, shNAME VARCHAR(10), shADD VARCHAR(8) )
建立管理员表: CREATE TABLE manager (mID CHAR(6) PRIMARY KEY, mNAME VARCHAR(4), mFEAT INT)
建立采购员表: CREATE TABLE shopper
(shopperID CHAR(6) PRIMARY KEY, shopperNAME VARCHAR(4), shopperFEAT INT )