четвер, 5 квітня 2018 р.

Books and Multimedia data structure

I'm developing web application, diary for travelers. And I have 'Books' and 'Multimedia' pages. The functionality of these pages pretty similar but work with different types of data. These pages provide simple CRUD functionality for the list of books (Books page) and for the list of multimedia content (Multimedia page).



But this part of business logic has quite unusable data structure, simple Books and Multimedia entities.
For avoiding performance issues and difficulties in extending this part of application in the future, I decided to expand database structure.



So each author has an authors_type, for example:
  • writer
  • composer
  • singer
  • band

Movies and music have a genre. Also movies have a type:
  • film
  • cartoon
  • anime

Also we should keep in mind next situations:
  •  movie has multiple genres
  •  author has multiple types (writer and producer)
  •  book has multiple authors

Now we can develop business layer for Books and Multimedia pages regarding to this database schema.

Немає коментарів:

Дописати коментар

Books and Multimedia data structure

I'm developing web application, diary for travelers. And I have 'Books' and 'Multimedia' pages. The functionality of the...