module 2 : Data Modelling

 Relational Database model


Entity Relationship Model (ER model)

Types of Attributes and its Symbol



Connectivity of Relationship



Degree of an Relationship



Designing an ER models

 


Conversion from ER Model to Relational Model

 



 Conversion from ER Model to Relational Model_Composite Attributes






Conversion from ER Model to Relational Model - Derived and Multi-valued Attributes 





Many to Many Relationship

 


Location: P2V2+QJV, Nagram - Nilmatha Rd, Sarthuwa, Barauna, Uttar Pradesh 226301, India

Comments

Post a Comment

Popular posts from this blog

Database Management System (DBMS)

                                                      Module 1: Introduction Concept and Characteristics of DBMS Overview : Learn the fundamental concepts of Database Management Systems. This video covers how a DBMS manages data efficiently, the importance of data integrity, and key characteristics like self-describing nature, insulation between programs and data, and support of multiple views. History and Evolution of Database Overview : Take a journey through the evolution of data storage. This video explains the transition from traditional file systems to hierarchical, network, relational, and modern NoSQL databases, highlighting why the world moved toward structured database management. Database System Architecture Overview : Understand the structural blueprint of a database. We explore the 1-tier, 2-tier, and 3-tier architectures, ex...
Read more