Basics of Relational Model

Duration: 5 min

This video lesson is available to enrolled students.

Return to /learn/COGNIZANT-PREPARATION/dbms/relational-model-functional-dependencies/basics-of-relational-model-anomalies/asset-basics-of-relational-model after enrolling

Inside: a video lesson and guided study material.

Module outline

  1. Communication Round: Vocabulary, Subject Verb Agreement (Verb Noun Agreement), Tenses, Comprehension / Reading Comprehension / Unseen Passages (Critical Reasoning) (Paragraph Questions), Cloze Test (Cloze Passage), Sentence Correction (Error Correction), Sentence Completion (Fill in the blanks), Sentence Re-arrangements (Para Jumbles) (Narrative Sequencing), Direct and Indirect Speech, Active Passive Voice (Voice), Verbal Analogy (Word Based Analogy), Articles, Preposition, Conjunction, Sentence Construction, English Writing Ability, Communication Assessment
  2. Quantitative Aptitude: Ratio and Proportion (Ratios), Divisibility Rules, Data Interpretation, Mixture and Alligation, Permutation and Combination, Logarithm, Number System, HCF LCM, Speed Time and Distance, Percentage, Average, Powers and Exponents (Surds and Indices), Time and Work, Mensuration and Geometry, Age Problems, Pipe and Cistern, Probability, Profit and Loss, Simple Interest and Compound Interest, Algebra
  3. Analytical and Logical Reasoning: Series (Number and Letter Series) (Numerical Relations and Reasoning), Coding Decoding, Data Sufficiency, Non Verbal Reasoning (Spatial Aptitude) (Spatial Reasoning) (Visual Reasoning), Directions (Direction Test), Ranking, Order and Sequence, Deductive and Inductive Reasoning (Logical Deduction and Induction) (Prepositional Reasoning), Selection Decision Table (Decision Making), Logical Sequence Of Words, Puzzle Solving (Puzzles), Syllogisms, Seating Arrangements, Calendar, Clock, Blood Relations, Cubes & Dices, Venn Diagram, Analytical Reasoning (Counting Figures Reasoning)
  4. Cognizant Gaming Aptitude: Gamified / Game Based Aptitude
  5. Java (Cluster 1): Java
  6. ANSI SQL MySQL (Cluster 1,2,3): SQL
  7. HTML, CSS, JavaScript (Cluster 1,3): HTML, CSS, JavaScript
  8. Python (Cluster 2): Python for Placements by Yash Sir
  9. Cloud Fundamentals (Cluster 2): Emerging Tech Trends
  10. C# (Cluster 3): C#
  11. OOPs: Object Oriented Programming (OOPS)
  12. Technical Assessment (Coding): Coding Questions by Yash Sir, C Programming by Yash Sir, Programming in C++, Pseudo Codes
  13. Data Structures: Introduction to DS, Array, Stack, Queue, Linked List, Tree, Graphs, Hashing
  14. DBMS: Basics of DBMS, ER Diagram, Relational Model & Functional Dependencies, Keys & Integrity Constraints, Normalization (1NF - BCNF), Decomposition Properties & 4NF, File Organization & Indexing, Relational Algebra, Relational Calculus, Transaction Management, Concurrency Control, Database Recovery, ORDBMS, Database Security & Authorization, Query Processing & Optimization, Enhanced Data Models, Data Warehousing & Mining, Big Data Systems, NoSQL
  15. Operating Systems: Introduction to OS, Process Management, CPU Scheduling, Process Synchronization, Deadlock, Threads & Process Creation, Memory Management, Virtual Memory, Disc Scheduling, File Management, Windows OS, Linux OS, Security, Distributed Systems, Virtual Machines
  16. 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, Network Security, Mobile Technology, Cloud Computing and IoT, Cyber and Info Security
AI summary & chapters

AI Summary

An AI-generated summary of this video lecture.

This educational video introduces the core concepts of Relational Database Management Systems (RDBMS). It begins by defining RDBMS as a system based on the relational model proposed by Edgar F. Codd in 1970. The lecture then moves to the basics, defining essential terms such as Domain, Tuple, Arity, and Cardinality using a sample table containing student information. Finally, the instructor outlines the seven fundamental properties of relational tables, emphasizing atomicity, uniqueness, and the insignificance of row and column order.

Chapters

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

    The video opens with a slide titled RELATIONAL DATABASE MANAGEMENT SYSTEM. The text defines RDBMS as a database engine/system based on the relational model specified by Edgar F. Codd. Key phrases like relational model and Edgar F. Codd are underlined in red. A second bullet point identifies Codd as The father of modern relational database design in 1970, with modern relational database design and 1970 also underlined. A black and white photograph of Edgar F. Codd is displayed on the right side of the slide. The instructor is visible in the bottom left corner, introducing the topic.

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

    The content shifts to BASICS OF RDBMS. The slide defines Domain as a set of permissible value in particular column consisting of atomic values. It explains that atomic means indivisible. A sample table is shown with columns NAME, ID, CITY, COUNTRY, and HOBBY. The instructor highlights the CITY column to illustrate a domain. The slide then defines Table (Relation) as a set of tuples, Tuple as each row, Arity/Degree as the number of columns (example: 5 in Table Student), and Cardinality as the number of rows (example: 4 in table Student). Red boxes and arrows are used to visually connect these definitions to the table structure. Specific data values like NISHA, 1, AGRA, INDIA, and PLAYING are visible in the table rows.

  3. 5:00 – 5:23 05:00-05:23

    The final section covers Properties of Relational tables. The slide lists seven specific rules. These include: Cells contains atomic values, Values in a column are of the same kind, Each row is unique, No two tables can have the same name in a relational schema, Each column has a unique name, The sequence of rows is insignificant, and The sequence of columns is insignificant. As the instructor discusses each point, he places a red checkmark next to it on the screen to indicate its validity and importance in relational theory. He gestures with his hands to emphasize the concepts.

The lecture provides a structured introduction to RDBMS, starting with historical context and moving to technical definitions. By using a concrete example table, the instructor clarifies abstract concepts like domain and cardinality. The lesson concludes by establishing the strict rules that govern relational tables, ensuring students understand the theoretical constraints necessary for database design.

Loading lesson…