宠物商店详细设计说明书(6)

)

values(656,'旺财','狗狗

',100,85,to_date('2015-11-11','yyyy-mm-dd'),366,215);

insert into

pet(ID,NAME,TYPENAME,LOVE,BITHDAY,OWNER_ID,STORE_ID)

values(657,'小白','蛇

',100,75,to_date('201512-12','yyyy-mm-dd'),367,216);

SELECT * FROM PET; DELETE PET;

create table Petowner( ID NUMBER,

NAME VARCHAR2(50), PASSWORD VARCHAR2(50), MONEY NUMBER(10,2) );

insert into Petowner(ID,NAME,PASSWORD,MONEY) values(361,'小红'，'6661',150);

insert into Petowner(ID,NAME,PASSWORD,MONEY) values(362,'前前'，'6662',200);

insert into Petowner(ID,NAME,PASSWORD,MONEY) values(363,'小静'，'6663',80);

insert into Petowner(ID,NAME,PASSWORD,MONEY) values(364,'菲菲'，'6664',163);

insert into Petowner(ID,NAME,PASSWORD,MONEY) values(365,'夏雨'，'6665',45);

select * from Petowner; delete Petowner;

create table Petstore( ID NUMBER,

NAME VARCHAR2(50), PASSWORD VARCHAR2(50), MONEY NUMBER(10,2));

insert into Petstore(ID,NAME,PASSWORD,MONEY)

values(001,'安徽第一宠物店'，'1101',4300);

insert into Petstore (ID,NAME,PASSWORD,BALANCE) values(002,'北京西苑','1102',5507);

insert into Petstore(ID,NAME,PASSWORD,BALANCE) values(003,'重庆观音桥','1103',8954);

SELECT * FROM PETSTORE; DELETE PETSTORE;

create table Account( ID NUMBER,

DEAL_TYPE NUMBER, PET_ID NUMBER, SELLER_ID,

BUYER_ID,NUMBER, PRICE NUMBER, DEAL_TIME DATE);

v. 维护与扩展

主要为对服务器上的数据库数据进行维护。可使用Oracle数据库的维护功能机制。例如，定期为数据库进行Backup，维护管理数据库死锁问题和维护数据库内数据的一致性等。