EntityRelationship Diagram (ERD) or ER diagram provides the best graphical solution for any DBMS design and in this example I will shows the type of icons and graphics you can use to develop a model of a database of arbitrary complexity.
EntityRelationship Diagram (ERD) or ER diagram for the given problem :
A publishing company produces books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not necessarily being specialists in a particular area, each take sole responsibility for editing one or more book publications. Every book require some items for publication. These items supplied by suppliers. One supplier can supply many items. Shop owner buys books from the publisher. Shop owner can buy many books but one book can be bought by one shop owner only. Books are uniquely identified by Bookid.

I wish you Good Luck. If you have any query then I my contact details are given below.

Name: Debarghya Mukherjee
Mobile: (+91)9038787021
Email: [email protected]