Design

Overview:

With the help of our group leader, Shengke Zhou, we successfully built the database and applied in into the web page design. With the help of the database, different books information could be presented in a new page without creating thousands of templates but just loading the database for what we need.

Basic database design idea

Trying to set a sets of models that could build many to many relationships between the three main models, the books, the authors and the publisher. Our goal is to make the relationship between books and authors, and the relationship between books and publishers could be two-sides. However, the relationship between the author and the publisher is not so important and we did not form a back and forth relationship between the publishers and the authors.