Войти
  • 253598Просмотров
  • 5 лет назадОпубликованоShanu Kuttan CSE Classes

L2.1 Introduction to ER Model | Entity, Attributes, Relationship, Degree, Mapping Cardinalities|DBMS

#ERModel #EntityRelationshipModel #DBMS #ShanuKuttanCSEClasses This video explains the Introduction to ER Model / Entity Relationship Model. What is ER Model? What is Entity Relationship Mode? Why ER Model is Useful? This video explains what is Entity and Entity set? 00:00 ER Model/ Entity Relationship Model 01:55 Why ER Model is useful? 03:23 ER Modelling Constructs 03:35 Entities and it's Examples 06:00 Entity Set & examples 07:10 Attributes, domain of attributes, Example 09:46 Attributes types: Simple & Composite attribute, Single & Multi-valued attribute, Stored & Derived attribute 11:16 Relationship & example 12:22 Relationship Set 13:30 Relationship: Descriptive Attribute 14:37 Degree of Relationship: Unary, Binary, Ternary, n-ary 16:40 Mapping Cardinalities: One to one, one to many, many to one, many to many This is a lecture 11 for Database Management System (DBMS) unit 1 according to CSVTU bhilai. For more videos on DBMS follow the given link: DBMS Playlist: ER Model Playlist: Relational Model Playlist: SQL Playlist: Lecture 1: Database Management System (DBMS) Introduction Lecture 2: View of Data in DBMS | Three Levels of Abstraction | Schema & Instance | Data Independence Lecture 3: Data Models | Relational Model | ER Model |Object Based Model | Semi-Structured Model Lecture 4: Database Languages | DDL, DML, DCL, TCL Lecture 5: Database Access from Application Programs | SQL | APIs - ODBC & JDBC | Embedded SQL Lecture 6: Database Users and Administrators Lecture 7: Transaction Management & Storage Management Lecture 8: Database System Structure, Query Processor, Storage Manager Lecture 9: DBMS Architecture: 1-tier 2-tier 3-tier Architecture Lecture 10: History of Database Systems Lecture 11: Introduction to ER Model, Entity-Attributes-Relationships Lecture 12: Types of Attributes in ER Model Lecture 13: Mapping Cardinalities & Participation Constraints Lecture 14: Keys in DBMS - Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key, Composite Key Lecture 15: Strong Entity & Weak Entity in DBMS Lecture 16: Extended ER Features: Generalization, Specialization, Aggregation in DBMS Lecture 17: Converting ER Diagrams to Tables with Examples | Rules Lecture 18: Questions on Conversion of ER Diagrams to Tables | Part 1 - Lecture 19: Questions on Conversion of ER Diagrams to Tables | Part 2 - Lecture 20: How to draw ER diagram| ER Diagram for Banking System | ER Notations Lecture 21: Relational Model in DBMS | RDBMS Lecture 22: Relational Model Mathematical Structure in DBMS Lecture 23: Integrity Constraints Welcome to this youtube channel "Shanu Kuttan CSE Classes " by Shanu Kuttan. This is a technical educational channel for subjects of computer science and engineering subjects (CSE) as per university syllabus and also cover GATE topics. It provides Computer Science and engineering classes in Hindi. This channel’s video helps Computer Science and Engineering students to understand different subjects like Computer System Architecture (CSA) i.e. Computer Organization and Architecture (COA) or simply Computer Architecture, Database Management System (DBMS), Parallel Processing and Computing (PPC) unit wise as per the CSVTU syllabus i.e. Chhattisgarh Swami Vivekanand Technical University, Bhilai Contact Link in Facebook :