问题描述
我有3个表格
table1是tbl_members
table2是tbl_library
table3是tbl_borrowing
tbl_members hase this columns
idmebmer int autoincrement(主键)
name varchar
adress varchar
tel varchar
email varchar
tbl_library hase this columns
idbook int autoincrement(主键)
bookname varchar
bookauthor varchar
类别varchar
tbl_borrowing hase this columns
idmebmer int autoincrement(primary key)''此列来自tbl_members的外键''
idbook int autoincrement(外键)''这一列是来自tbl_library的外键''
data_checkoutbook varchar''时间用户从库中取出书籍的时间
data_retunbook varchar''的时间用户必须将图书归还图书馆
i cane保存表tbl_library和tbl_members中的数据但
如何保存日期tbl_borrowing为用户如何拿起一本书
用户只能拿一本书来支付
或者我如何构建一个数据库一个图书馆管理系统
对不起我的英文
i have 3 tablese
table1 is tbl_members
table2 is tbl_library
table3 is tbl_borrowing
tbl_members hase this columns
idmebmer int autoincrement (primary key)
name varchar
adress varchar
tel varchar
email varchar
tbl_library hase this columns
idbook int autoincrement (primary key)
bookname varchar
bookauthor varchar
category varchar
tbl_borrowing hase this columns
idmebmer int autoincrement (primary key) ''this column is from foreign key from tbl_members ''
idbook int autoincrement (foreign key) ''this column is from foreign key from tbl_library''
data_checkoutbook varchar '' the time where the user hase pickup the book from the library
data_retunbook varchar ''the time where the user must return the book to the library
i cane save data in table tbl_library and tbl_members but
how ken i save the date in tbl_borrowing for the user how has pick up a book
the user can only one book pick up
or how to i construk a database for a library menagment system
sorry for my english
这篇关于使用vb.net在sqlserver中保存数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!