说明：  根据事务需求（详见所给材料）中的每一项要求，写出相关的存储过程。 说明： 1）“创建”记录就是在存储过程中使用Insert语句实现插入新记录的功能； 2）“维护”记录包括更新和删除数据库中的记录，要求完成更新功能，删除功能可选； 3）查询功能要求较多，灵活运用所学SQL编程知识来完成。
(In accordance with Service requirements (see the given material) in each of the requirements, write a stored procedure-related. Description: 1) create records in the stored procedure is used to achieve Insert statement to insert a new record function 2) preserve records including updating and deleting database records, the requirements to complete the update function, delete function optional 3) query the functional requirements of more flexible use of learned knowledge to the completion of SQL programming.)