一个简单的酒店系统的数据库设计

--16,服务项目可以追加
create proc addserverlist @serverid char(6),@servername char(20),@servercost money
as
  insert into serverlist values(@serverid,@servername,@servercost)
go
  exec addserverlist 'c02','苹果汁',12
  select * from serverlist
go

--17,房屋类型可能增加
create proc addroomtype @roomtypeid int,@roomtype char(20),@roomcost money
as
  insert into roomtypelist values(@roomtypeid,@roomtype,@roomcost)
go
  exec addroomtype 4,'普通客房',108
  select * from roomtypelist
go

--18,登记客人资料    掉了'卡号'字段  卡号字段没缺省值
create proc addguest
@guestcardno char(20),
@guestname char(10),
@guestsex char(2),
@guestphone char(20)
as
  insert into guest values(@guestcardno,@guestname,@guestsex,@guestphone)
go
  exec addguest '我','210112197909094035','男','(080)027-12345678'
  select * from guest
go

--19,登记客房使用单 
create proc addroomuse @roomid char(6),@guestid int
as
  insert into guestroom(roomid,guestid) values(@roomid,@guestid)
go
  exec addroomuse '1004',10002
  select * from guestroom
go
---------------------------------------------------------------------------

--触发器  
--1,顾客登记就应该有触发器，向事务表中添加顾客记录(default)
create trigger trgaddguest on guest
for insert
as
   declare @guestid int

上一页 [1] [2] [3] [4] [5] [6] [7] [8] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:持续数据保护方案打破传统备份的局限

下一篇:提高查询速度：SQL Server数据库优化方案