PERSONAL CONNECTION 2
https://documents.lucidchart.com/documents/fa0cdc60-8d27-42f5-9a0e-307f5107b00e/pages/0_0?a=2409&x=-182&y=-102&w=2546&h=2020&store=1&accept=image%2F*&auth=LCA%204f2af55586f5ad573b3aeeb59cac17af88a4f7fe-ts%3D1574842126
E-R DIAGRAM:
Description:
This project basically describes the book rating social network system.ERD has many entities and relationships among them.
Publisher:
Publisher has many properties that are publisher id, name, publisher price, phone and country.
Relation with other entities:
Publisher can publish one or more book.
Publisher can have one or more author.
Author:
Properties:
Autherid, ISBN, name, bookid and address.
Relation with other entities:
Author can belong to one or more publishers
Author can write one or more books
Author’s book can have one or more editions
Book:
Properties:
ISBN, book id, book name, publication date, book title, page count, publisher id, publisher price, category id, edition id, format id.
Relation with other entities:
Book can have 3 categories.
Book can have one or more editions, formats and authors.
Book also has rating.
Category:
Properties:
Category id, category description
Relation with other entities:
Category has associated with book.
User:
Properties:
User id, ISBN, name, gender, age and location
Relation with other Entities:
User can rate books through social networks.
User can send request to another user
Store:
Properties:
Request id, status, sent time, answer time
Relation with other entities:
Store is associated with request entity.