《数据库课程设计报告-个人记账系统》.doc

目 录 一、课程设计目的二、系统设计、数据库逻辑结构设计、系统功能模块图、课程设计总结课程设计目的通过数据库课程设计，培养学生数据库设计的综合能力。从需求分析和数据库逻辑、物理设计，到功能分析和应用程序的最终实现，让学生亲自动手参与一个具有一定规模的数据库应用系统的设计和开发，真正理解和掌握数据库设计和开发的思路和方法，并更好的理解和消化课本所学的知识，为今后的实际应用打下良好的基础。系统设计、数据库逻辑结构设计、系统功能模块图de_pay create trigger de_pay on pay for delete as declare @new_time char(20) declare @new_item char(20) declare @new_mon int declare @new_rela char(20) declare @new_expl char(200) select @new_time=支出时间 from deleted select @new_item=支出项目 from deleted select @new_mon=支出金额 from deleted select @new_rela=支出人员 from deleted select @new_expl=支出说明 from deleted delete from account where 录入时间=@new_time and 收支金额=@new_mon and 收支项目=@new_item and 收支人员=@new_rela and 收支说明=@new_expl out_tr create trigger out_tr on pay for insert as declare @new_time char(20) declare @new_item char(20) declare @new_mon int declare @new_rela char(20) declare @new_expl char(200) select @new_time=支出时间 from inserted select @new_item=支出项目 from inserted select @new_mon=支出金额 from inserted select @new_rela=支出人员 from inserted select @new_expl=支出说明 from inserted insert into account(录入时间,收支类型,收支金额,收支项目,收支人员,收支说明) values(@new_time,支出,@new_mon,@new_item,@new_rela,@new_expl) up_pay create trigger up_pay on pay for update as declare @new_time char(20) declare @new_item char(20) declare @new_mon int declare @new_rela char(20) declare @new_expl char(200) declare @old_time char(20) declare @old_item char(20) declare @old_mon int declare @old_rela char(20) declare @old_expl char(200) select @old_time=支出时间 from deleted select @old_item=支出项目 from deleted select @old_mon=支出金额 from deleted select @old_rela=支出人员 from deleted select @old_expl=支出说明 from deleted select @new_time=支出时间 from inserted select @new_item=支出项目 from inserted select @new_mon=支出金额 from inserted select @new_rela=支出人员 from inserted select @new_expl=支出说明 from inserted update account set 录入时间=@new_time where 录入时间=@old_time update account set 收支金额=@new_mon where 收支金额=@old_mon update account set 收支项目=@new_item where 收支项目=@old_item upd