1000+ Free Courses With Free Certificates: https://www.mygreatlearning.com/academy?ambassador_code=GLYT_DES_Top_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Top_SEP22
Get your free certificate of completion for the My SQL Basics Course, Register Now: http://glacad.me/MySQLCourse
To implement a database we need a blueprint and we can create this blueprint using Entity-Relationship or ER diagram. The Entity-Relationship diagram describes the structure of a database. As its name indicates, the Entity-Relationship diagram shows the relationship between different entities or entity sets of the database.
An entity is the object or component of the data and is represented by a rectangle in the Entity-Relationship diagram. similarly, we have different shapes to represent different components of the data. For instance, an attribute is represented by an oval.
In this tutorial, we will be discussing in brief the various components involved in a database and Entity relationship diagram. It is a core part of the Database Management system. To know more about this interesting topic, watch the video till the end.
Following pointers will be covered in this video:
00:00:00 Introduction
00:01:13 What is an ER Diagram?
00:02:00 History of ER Diagram
00:02:32 Facts of ER Diagram
00:03:15 Why ER Diagram is Used?
00:05:31 Components of ER Diagram
00:06:19 What is Entity?
00:07:20 What is a Weak Entity?
00:07:59 Strong Entity Set Vs Weak Entity
00:10:00 What are Attributes?
00:10:44 Types of Attributes
00:11:23 What is Simple Attributes?
00:12:16 What are Composite Attributes?
00:13:08 What is Divided Attributes?
00:13:58 What is Multivalued Attributes?
00:15:18 What is Cardinality?
00:16:58 What is One To One Relationship?
00:18:22 What is One To Many Relationship?
00:19:20 What is Many To One Relationship?
00:21:17 Example of ER Diagram
Visit Great Learning Academy, to get access to 80+ free courses with 1000+ hours of content on Data Science, Data Analytics, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free. https://glacad.me/3duVMLE
Get the free Great Learning App for a seamless experience, enroll for free courses and watch them offline by downloading them. https://glacad.me/3cSKlNl
About Great Learning:
- Great Learning is an online and hybrid learning company that offers high-quality, impactful, and industry-relevant programs to working professionals like you. These programs help you master data-driven decision-making regardless of the sector or function you work in and accelerate your career in high growth areas like Data Science, Big Data Analytics, Machine Learning, Artificial Intelligence & more.
- For more interesting tutorials, don't forget to subscribe to our channel: https://bit.ly/2s92TDX
- Learn More at https://www.greatlearning.in/
For more updates on courses and tips follow us on:
- Telegram: https://t.me/GreatLearningAcademy
- Facebook: https://www.facebook.com/GreatLearningOfficial/
- LinkedIn: https://www.linkedin.com/company/great-learning/
- Follow our Blog: https://www.greatlearning.in/blog/?utm_source=Youtube
#ERDaigram#DBMS#GreatLearning