The topic of graduation project is book management system. What are the tables in the database based on?
First of all, there should be a record of book information (book ID, book name, book author, book publishing house, book price and other information). Second, there must be a user table (user name, password, permissions, etc.). ). 3. Borrowing table (borrower ID, borrowing time, overdue time, borrower ID, whether to renew the loan) Q: What is the content of the table in the database based on? Of course, the content of the table is determined according to the function you want to realize. For example, if you want to borrow books, then you must have books and people. The information of books is put in a table, the information of people is put in a table, and then the borrowing situation is put in a table. Q: I mean that my graduation project is that the library management system has been completed. During the defense, the teacher asked me a question: What are the tables in the database based on? (Analyze the needs of users and the attributes of books, summarize some borrowed materials into fields, and design the business between them. ) Can you help me expand it in detail? A: First, the functions and requirements are defined through requirements analysis, then the E-R model is established according to the requirements, and then the logical design and physical design are carried out.