根据实体对象生成数据库模型图.ppt

软件工程 2 添加到购物蓝核心事件数据库图1 ）购物蓝主键，作为线项的外键建立关联2）账户的主键作为购物蓝的外键建立关联 帐号和购物蓝的SQL描述DROP TABLE 账号 CASCADE CONSTRAINTS;CREATE TABLE 账号( billingAddress VARCHAR2(50) DEFAULT Delivery Address, closed NUMBER(1), deliveryAddress VARCHAR2(50), emailAddress VARCHAR2(50), name VARCHAR2(50), accountID NUMBER NOT NULL, history NUMBER);ALTER TABLE 账号 ADD CONSTRAINT PK_Account PRIMARY KEY (accountID) USING INDEX;ALTER TABLE 账号 ADD CONSTRAINT FK_history FOREIGN KEY (history) REFERENCES 交易 (transactionID);DROP TABLE 购物篮 CASCADE CONSTRAINTS;CREATE TABLE 购物篮( lineItemID NUMBER, shoppingBasketNumber VARCHAR2(50), shoppi