图书馆管理系统的数据库设计stu_info(–学号stu_num varchar(10) primary key,–姓名stu_name varchar(12) not null,–学院stu_college varchar(20),–年级stu_grade smallint,–宿舍stu_dorm varchar(10));teacher_info(–职工号tea_num varchar(10) primary key,–职工名tea_name varchar(12) not null,–职工所在学院tea_college varchar(20));book_info(–图书编号book_num varchar(20) primary key,–图书名book_name varchar(30) not null,–图书分类book_cla varchar(20),–图书出版社book_pre varchar(30),–图书总数目book_all_quan ,–可借数目book_quan ,–出版时间book_time datetime);br_stu_info(–借书证lib_card bigint,–图书编号book_num varchar(20),–借书时间bro_time datetime,–归还期限rn_deadline datetime,–归还时间rn_time datetime,primary key (lib_card,book_num),foreign key (lib_card) references log_stu_info (lib_card),foreign key (book_num) references book_info(book_num));br_tea_info(–借书证lib_card bigint,–图书编号book_num varchar(20),–借书时间bro_time datetime,–归还期限rn_deadline datetime,–归还时间rn_time datetime,primary key (lib_card,book_num),foreign key (lib_card) references log_tea_info (lib_card),foreign key (book_num) references book_info(book_num));sym_man_info(–管理员账户sym_num varchar(20) primary key,–管理员名字sym_name varchar(10) not null,–管理员密码sym_pass );log_stu_info(–借书证号lib_card bigint (1000000,1),–学号stu_num varchar(10) not null,–密码stu_pass varchar(20) not null,foreign key (stu_num) references stu_info (stu_num));log_tea_info(–借书证号lib_card bigint (1999999,1),–职工号tea_num varchar(10) not null,–密码tea_pass varchar(20) not null,foreign key (tea_num) references teacher_info (tea_num));
，当爱丽思丢失了通往仙境的钥匙，
