How many tables does it take to make a library management system? Library card form, book form, borrowing form, administrator form, what else do you need?

That's basically it. But as a management system, why didn't you do a demand analysis first?

For the book management system, the following analysis should be made:

1. Object information that the system faces, that is, users, including administrator information and ordinary user information. You'd better unify the administrator table and the library card table into one user table, and merge the user information and the library card information into one table.

2. The functions that the system needs to realize include: book collection information record, book borrowing and recycling record. This requires a separate table.

To sum up, a book management system only needs three tables: user table, book information table and record table. For a system, the fewer tables used, the better. On the premise of not affecting the validity, all kinds of information should be merged into the same table as much as possible.

Which website can read educational classics?

Shunyi primary school ranking

What are the four nutritious and delicious Chinese medicine dietotherapy for losing weight?

Choosing medicated diet to lose weight is a relatively simple way to lose weight. Many medicated diets

[45] The picture book water sprite and the Mud Monster, which guides children to talk about hygiene.

What papers are worth recommending to beginners of economics?

Can I get a VAT invoice when I buy things in a department store?

Zhao Lihong's The Jade Bird

Which university libraries are good?

What kind of book is Laozi? When was it written and what are its characteristics?

Which primary school is good in Taiping District of Fuxin City?