All About Multivaluated Dependency

Duration: 8 min

This video lesson is available to enrolled students.

Return to /learn/UP-LT-GRADE-ASSISTANT-TEACHER-2025/cs-07-database-management-systems/decomposition-properties-4nf/multivalued-dependency-mvd-4nf/asset-all-about-multivaluated-dependency after enrolling

Inside: a video lesson and guided study material.

Module outline

  1. About Course: About the Course
  2. CS | 01 | Digital Logic and Circuits and Discrete Mathematical Structures: Digital Systems & Boolean Basics, Number System, Number Representation, Logic Gates & Hardware, Boolean Expression, Boolean Minimization, Combinational Circuit, Sequential Circuits, Set Theory, Relations, Functions, Graph Theory, Group Theory, Propositional and Predicate Logic, Permutation and Combination
  3. CS | 02 | Computer Organization and Architecture: Basics of COA, Cache Memory Organization, Input Output Organisation, Pipelining, Instr Formats & Modes, Control Unit Design, Multiprocessors
  4. CS | 03 | Data Structures and Algorithm: Introduction to DS, Array, Stack, Queue, Linked List, Tree, Graphs, Hashing, Algorithm Analysis, Time Complexity Analysis, Sorting Algorithms, Greedy Algorithms, Dynamic Programming, Minimum Spanning Trees, Shortest Path Algos, Complexity Theory, Advanced Algorithms
  5. CS | 04 | Problem Solving through C Programming: C Fundamentals, Control Flow, Functions, Arrays & Pointers, Storage Classes, Structures & Enums, DMA, Macros, Scoping & File Handling
  6. CS | 05 | Object Oriented Techniques: Object Oriented Technology, Java
  7. CS | 06 | Operating System: Introduction to OS, Process Management, CPU Scheduling, Process Synchronization, Threads & Process Creation, Deadlock, Memory Management, Virtual Memory, Disc Scheduling, File Management, Windows OS, Unix OS
  8. CS | 07 | Database Management Systems: Basics of DBMS, ER Diagram, Relational Model & Functional Dependencies, Keys & Integrity Constraints, Normalization (1NF - BCNF), Decomposition Properties & 4NF, Relational Algebra, SQL, Relational Calculus, Transaction Management, Concurrency Control, Database Recovery, Database Security & Authorization, Query Processing & Optimization, File Organization & Indexing
  9. CS | 08 | Computer Networks: Introduction to CN, Data Communication, DLL: Access Control, DLL: Flow Control, DLL: Error Control, DLL: Framing, Data Link Layer - Ethernet, Net Layer: IPv4 & Proto, Net Layer: IP Addressing, Net Layer:Routing Protocol, Transport Layer Services, TL: Congestion & UDP, Application Layer, Hardware basics
  10. CS | 09 | Software Engineering: Fundamentals of Software Engineering, Software Requirements and Quality Assurance, Software Design, Estimation and Metrics, Software Testing, Software Maintenance and Configuration Management
  11. CS | 10 | Internet Technology, Web Design and Web Technology: Internet Fundamentals, Web Design & Development, Protocols & Services, Web Publishing & Hosting, Server Side & Security, Emerging Technologies, JavaScript-Basics, HTML Basics
  12. CS | 11 | System Analysis And Design: Fundamentals of Systems and Information Systems, SDLC and Development Approaches, Software Documentation and Software Requirements Specification (SRS), SDD and Quality Assurance, Security, Risk Management & Maintenance
  13. CS | 12 | Information Security and Cyber Laws: Cyber Threats and Malware Attacks, Role of Internet and Web Services, Security in Mobile and Wireless Computing, Electronic Data Interchange and E-Commerce, Physical Security and Cryptography Basics, Intrusion Detection Systems (IDS), Cyber Safety and Security
  14. CS | 13 | Computer Graphics: Basics of Computer Graphics, 2-D Geometrical Transforms and Viewing, 3-D Object Representation, Geometric Transformations and Viewing
  15. GS Paper | 01 | Indian and World Geography: Geography
  16. GS Paper | 02 | History: History
  17. GS Paper | 03 | Indian Economy & Social Development: Indian Economy
  18. GS Paper | 04 | General Science: Biology, Chemistry, वैज्ञानिक उपलब्धियाँ और अनुसंधान / Scientific Achievements and Research
  19. GS Paper | 05 | Elementary Maths: संख्या पद्धति / Number System, Divisibility Rules, महत्तम समापवर्तक और लघुत्तम समापवर्त्य / HCF and LCM, प्रतिशत / Percentage, लाभ, हानि और बट्टा / Profit, Loss and Discount, साधारण और चक्रवृद्धि ब्याज / Simple and Compound Interest, अनुपात और समानुपात / Ratio and Proportion, औसत / Average, समय और कार्य / Time and Work, समय, चाल और दूरी / Time, Speed and Distance, Algebra, घन क्षेत्रमिति / Solid Mensuration, आँकड़ा निर्वचन / Data Interpretation, Arithmetic, Statistics, Probability, Sequence and Series (Series), मिश्रण और एलिगेशन / Mixture and Alligation, Calculus, Trigonometry, Vectors, संख्या पद्धति और संख्या सिद्धांत / Number Systems and Number Theory, यूक्लिडीय ज्यामिति और क्षेत्रमिति / Euclidean Geometry and Mensuration, सांख्यिकी और प्रायिकता / Statistics and Probability, निर्देशांक ज्यामिति, सदिश और त्रिविमीय ज्यामिति / Coordinate Geometry, Vectors and 3D Geometry, बहुपद, समीकरण और सम्मिश्र संख्याएँ / Polynomials, Equations and Complex Numbers, समतल क्षेत्रमिति / Plane Mensuration, सरलीकरण, घातांक और करणी / Simplification, Indices and Surds, समुच्चय, संबंध, फलन और विविक्त गणित / Sets, Relations, Functions and Discrete Mathematics
  20. GS Paper | 06 | Indian Polity and Governance: Polity
  21. GS Paper | 07 | Current Events: समसामयिकी / Current Affairs
  22. UPLT Live Classes Notes: UPLT Live Classes
  23. UPLT Full Mock Tests Tier 1:
  24. UPLT Full Mock Tests Tier 2:
AI summary & chapters

AI Summary

An AI-generated summary of this video lecture.

This lecture introduces Multivalued Dependencies (MVDs) as a consequence of First Normal Form (1NF) restrictions, which disallow attributes from having sets of values. The instructor defines the notation $A woheadrightarrow B$ and distinguishes it from functional dependencies using a table example. The concept of trivial MVDs is explained, where the right-hand side is a subset of the left-hand side or they form the entire relation. Finally, a detailed example of a Student relation demonstrates how MVDs cause redundancy even when a schema is in BCNF, illustrating the cross-product effect of independent multivalued attributes.

Chapters

  1. 0:00 – 2:00 00:00-02:00

    The video begins with the title 'Multivalued Dependency' on the slide. The first bullet point states that MVDs are a 'consequence of first normal form (1NF) which disallows an attribute in a tuple to have a set of values'. The instructor introduces the notation $A woheadrightarrow B$, explaining it means 'for every value of A, there may exist more than one value of B'. He writes $A ightarrow B$ on the screen, then corrects it to $A woheadrightarrow B$. He draws a table with columns A and B, populating it with values: 1 maps to a, 2 maps to a, and 1 maps to b. This visual demonstrates that for A=1, there are multiple values of B (a and b), which is characteristic of a multivalued dependency rather than a functional dependency.

  2. 2:00 – 5:00 02:00-05:00

    The lecture transitions to 'trivial multivalued dependency'. The slide text defines this as a dependency $X woheadrightarrow Y$ where 'either Y is a subset of X, or X and Y together form the whole set of attributes of the relation'. The instructor writes 'T' for Trivial and 'NT' for Non-Trivial. He provides an example $AB woheadrightarrow B$, labeling AB as LHS and B as RHS. He writes the condition $RHS \subseteq LHS$ to show that if the right-hand side is a subset of the left-hand side, the dependency is trivial. He draws a table with columns X and Y to visualize this relationship, reinforcing that if Y is contained within X, the dependency holds trivially.

  3. 5:00 – 7:33 05:00-07:33

    The instructor presents a concrete example using a relation named 'Student'. The slide lists two constraints: $S\_name woheadrightarrow Club\_name$ and $S\_name woheadrightarrow P\_no$. He shows two decomposed tables: one linking Kamesh to Dance and Guitar, and another linking Kamesh to phone numbers 123 and 789. He then displays a combined table with columns S_Name, Club_name, and P_no. He explains that because the club names and phone numbers are independent multivalued attributes, the combined table must contain the cross-product of these values. This results in four rows: (Kamesh, Dance, 123), (Kamesh, Guitar, 123), (Kamesh, Dance, 789), and (Kamesh, Guitar, 789). He circles the P_no values 123 and 789 to highlight the repetition. A note at the bottom states the schema is in BCNF but still has redundancy due to MVD.

The lesson progresses from the theoretical definition of Multivalued Dependencies as a consequence of 1NF to the specific notation $A woheadrightarrow B$. It clarifies the distinction between functional and multivalued dependencies through visual table examples. The concept of trivial MVDs is then defined based on subset relationships between attributes. Finally, the practical implication of MVDs is demonstrated using a Student relation, showing how independent multivalued attributes create a cross-product effect that leads to data redundancy, even in a BCNF schema.

Loading lesson…