My idea in the Library web design

Q1 table in the end who's connected to whom?

for the user, should I borrow a book, book collection of less one; I also have a book, book collection one more book; These two numbers should be connected to each other, but can not be a one-to-many relationship, I can not borrow a book will be one less?! So, this should be many-to-many and many-to-many relationships. The number and the name of the book collection, and the number of users should be the corresponding relationship; When the user to the book to operate, his own borrowing quantity changes, the data table has changed, and its contact data table should also change (simple operation, the connection is good)

for administrators, he can delete and add to existing or new books directly without looking at the collection, and when he looks at the general books, he can also delete and modify them (this can be done directly with the lecture) .... )

there are so many functions, but the biggest problem now is how to query the books and display them in categories (directly using INSERT not just good? It seems that it is not very difficult to look at it .... )

The biggest problem is the list of relational charts!! Write so much also didn't think well how to do .... I guess I'm going to explode. The initial assumption is that the administrator and who are not connected to the user's personal information (definitely to change ....) The project is huge .... ) in the personal borrowing situation is divided into borrowing the title and the number of borrowing (one-on, the total sum now ...) ) and the library the title and quantity of the book correspond to each other, through the borrowing operation changes.

User information:

username, gender, password (initial password date of birth), mobile phone number, borrowing the title and quantity (first try to save a lot of information in a lattice, anyway, I set the most to borrow ten , not, the time to return the book Ah, a book button press, but also just this ... Multiple lattice thank you)

Administrator Information:

User name, password (set the initial Bai, have time to make an administrator to modify their password) what else? It's like nothing. Think of it again, a few buttons of the thing.

Administrators can not borrow books, want to borrow their own user account to go.

Book information:

Title, author, publisher, number, number in the library (not to save the book first) what else? To the right to classify!! And then.... I don't know what else.

Once the database is written, do not move, the number of data not too much, a class of a

Book category AH (with selection dropdown box):

the ll Dafa Good "Nakhinyi ll Publishing house WW001 Youth Literature ten

"Out of Africa"   Jeason Two dog publishing house ZZ001 Biography Literature

"Engineering Mathematics Analysis" Experts Harbin Press SS001 Math Ten

married woman of the age of Xujing 346 Publishing house AA001 novel

the C Language Program design rectification Wuhan Press BB001 computer

"My instructor's bluff is not straight." Maijan LL Publishing House WW002 Youth Literature ten

"How do I Grow to 177 " E Ming two Dog publishing house ZZ002 Biography Literature

"high number Answer" Wang Yuyi Harbin Press SS002 Math Ten

The wonderful encounter of Halloween Lutian a 346 publishing house AA002 novel

"on how to repair a computer" Liu Dongyu Wuhan Press BB002 Computer Ten

My idea in the Library web design