Entity-Relationship Diagram (ERD) example | ER diagram Example 1
Entity-Relationship 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.
Entity-Relationship 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: debarghya_mkr@yahoo.com
Пікірлер: 99
you have taken attributes for the relationship only if cardinality is n:m . those attributes were same as the attributes for the entities participating in the relationship. so this is a thumb rule that: if a cardinality of a relation is N:M, then you need to give the attributes which are the attributes of the entities.
@zaidakram5782
6 жыл бұрын
yes
There is a mistake in last second point.Books are bought from the publisher not directly from Book entity.
@mohamedtaha391
5 жыл бұрын
including an entity for the company itself is a mistake because you are designing the database for that company
Thanks!! This helped me a lot in doing my ER Diagram.
There is no need to go tuition classes because u r awesome guiding us like eguru. Thx for guidance
Good video... It took me a while to focus, I was so baffled by the fact that you're using the most annoying symbol a windows machine can show you as your cursor. I was concerned your computer was frozen when you started your video but nope. Good content though!! Thank you for sharing.
@DebarghyaMukherjeeEducation
8 жыл бұрын
+Miguel Marquez Thank you
@vanshikagoyal4092
4 жыл бұрын
@@DebarghyaMukherjeeEducation want ur hlp
@MaxRollison
3 жыл бұрын
funny
its explained in a very lucid way ,very easy to understand the concept.thanks for the video
Thank you so much!!! GOD Bless you richly.
Thank you so much sir you solved my ER diagram based problems
Very nice sir after long time I'm seeing the vids of Data base design again 👍
Thanks for the tutorial. Helped me a lot.
This vedio can clear all the concepts of...ERD....
I do think there will be ternary relationship between shop owner, books and publisher. Am I correct?
Thanks Debarghya! Your videos are really helpful!
@ashwink.l2034
5 ай бұрын
bro what are doing in your life now
It says that the shop owners buys book from publisher. Why haven't we drawn the line from "buy" diamond box to publisher?
In the description says that ONE supplier can supply many books, so it should be a 1 instead of the N, isn't it?
@suchintandas1624
3 жыл бұрын
No, many suppliers have the choice of selling many books, that line mean that at a moment of time only one supplier can sell one book.
I think there should be a relationship between editor and the subject since "The company employs editors who, not necessarily being specialists in a particular area", and those areas can mean what other than subjects?
Beautifully done!!
“Traditions” covers weddings functions, birthday parties and corporate meetings. Customers have to get registered before placing order. Customer has to select the desired venue according to the category of function. Customer can select only a single venue for a function. Company is also offering other services like catering, stage decoration etc., for the events. Customers select the menu and catering while placing order. Menu has many food items plz make er diagram with this solution.
why supplier and item relation have m:n cardinality? One supplier can supply many items but shouldnt be one item supplied by one supplier only?
Yes, there is so much helpful & also meanful for us.. This scenerio way is such a systematic & current way with the help of understanding & reliable diagrams also.. Thankyousomuch for shared with us..
Best video I have seen or ER-Diagram. Good example for conceptual understanding. Thank you so much sir. Please upload more such videos.
@karunjohn9227
2 жыл бұрын
deyy the worst video i have ever seen lolll
Please may you describe the notation used in the thumbnail and also explain it as an introduction to your video since they are designed differently regardless of the same concept
@raphaelkadewere2979
Жыл бұрын
thats true
it was great video thanks for your sharing
How can 1 book be written by many authors??
Found helpful. Thanks a lot..
great videos,,,
Good attempt
At 3:50, books and subjects have M:1 relationship, won't it be M:M as there can be many books on many subjects. Correct me if I'm wrong.
@salmananjum-thestoryteller1515
6 жыл бұрын
1 Book in particular can have only 1 Subject Either Physics Or Chemistry but each Subject can have many books available in market.!
@mutlutaygut8580
9 ай бұрын
If one book can be written by more than one author, it could naturally have different subjects in it@@salmananjum-thestoryteller1515
thank you very much!
Great helped a lot
You are very good teacher .. please upload video on erd Case study on security management system .
@amnamustafa2379
5 жыл бұрын
Sir please reply.
I was wondering if there could be a relationship two relationships with editor, " company EMPLOYS editors and EDITING as you have it
@JASXKRM
8 жыл бұрын
."?
@greekmotivation589
4 жыл бұрын
thought about the same thing
@danishali-qv4wk
3 ай бұрын
i think we can use disjoint i.e editor as attribute
Thank so much for explaining in such detail😃🙂
@jaychaudhary5822
Жыл бұрын
Behn k lund kya detail di isne
@jaychaudhary5822
Жыл бұрын
Hwa hwa m le gya h
First where can i found this i mean to construct
hard level example........but its esy....thankyou..
Today is my DBMS exam, this helped a lot. Thanks a lot sir. :)
@sancharidas7532
7 жыл бұрын
tomorrow is mine.
@tapamoychakraborty6896
7 жыл бұрын
Sanchari Das lol, good luck. My exam went kinda decent.
@sancharidas7532
7 жыл бұрын
Tapamoy Chakraborty xm to na jano Laden er boma Are you from IT?
@tapamoychakraborty6896
7 жыл бұрын
Sanchari Das I am doing BCA :)
@tapamoychakraborty6896
7 жыл бұрын
and you?
i want about er diagram for online event planning system
if " Shop owner buys books from the publisher" why shop owner ->buy ->books in ERD ?
@sajalpatil
4 жыл бұрын
same doubt please help us someone
@suchintandas1624
3 жыл бұрын
It is the wrong part of the video, it would be connected to the publisher.
@dnesbhattarai242
11 ай бұрын
@2023 it need to correct
Shouldn't subject be a weak entity- It is meaningless without it's book?
Thanks 👍
👍👍
but the shop keeper buys the books from publisher then where is the relation between the shop keeper and the publisher
How can 1 book be written by many authors?? please explain us
thanks
Sir Please Change the microphone its not very good and your sound is not also clear, anyway thank you for the ERD Example.
Sir ap na erd diagram kis m bnai ha
@DebarghyaMukherjeeEducation
6 жыл бұрын
usama farooq ms-paint
what does N mean?plss helpp....
@asimkhan-sd2km
9 жыл бұрын
N also means many ie the relation between books and auther is many to many. So for one entity it is n and other entity it is M
God the accent and the mouse cursor made me go crazy all over the town
Why item --> supplier and books---> author is not M ---> 1. I don't understand this N.
@mones097
8 жыл бұрын
+AntiMassovka 1 item can be brought from many supplier and 1 supplier can sell many item so m->N 1 book can written by multiple authors and 1 author can write multiple book so m>n
loud u r volume
in a last, one book can be bought by many shop owners and one shop owners can buy many books. so it's has to be m-n (many to many)relationship
abc
@AJAYPAREEK007
9 жыл бұрын
won't there be any relationship between shop owner and publisher?
@gatlingrimes3019
9 жыл бұрын
Ajay Pareek The store owner is indeed connected to the publisher, I will try to explain this with an example. Say you want to see what books a store has, and display the publishers of the books they own: you would use an inner join statement with the 'books', 'publisher', and 'shop owner' tables by using the book's primary id which would also be a foreign key in the other two tables. By doing that, it should show a single table where it displays all of the table's columns that you have selected The query could look something like this: select books.book_id, books.book_name, publisher.publisher_name from books join publisher on books.book_id = publisher.book_id join store_owner on books.book_id = store_owner.book_id I could have missed something, as I am refreshing my knowledge on systems design... The idea's there though, I hope this helps you and others understand how this works into actually querying it :)
@nhhridoy944
7 жыл бұрын
Ajay Pareek djfkfsjstwistdikssflshhz jdvxksdvslkfs ajsgskfdsjgsksgddogs susjfdlahsslgsgssfhaanika
@MrMegaFlich
4 жыл бұрын
Can a book have more than one publication? Because it's kinda confusing, in the text we have book, book publication and publication and they all sound like separate entities to me. Especially book publication sounds like a weak entity connected to book and editor. Also can we put "Item" as a multi-valued attribute between Books and Supplier instead of it being an entity? If you could answer I'll be very grateful since I have an exam next week and the professors are still on a holiday ¯\_(ツ)_/¯
please talk louder
i think you are talking in the bathroom
@mrgaming7840
2 ай бұрын
😂😂
Your method is irritating
@nikhilkamode9090
7 ай бұрын
?
tbh boring