Это пробный урок. Оформите подписку, чтобы получить доступ ко всем материалам курса. Премиум

  1. Урок 1. 00:10:19
    Introduction
  2. Урок 2. 00:03:55
    Data model and its types
  3. Урок 3. 00:11:17
    Entity, Relationship and Attribute Explained
  4. Урок 4. 00:04:14
    Database Designer's perspective
  5. Урок 5. 00:02:01
    ER Model and Relational Model - Advantages and Disadvantages
  6. Урок 6. 00:01:58
    Basic Idea of Attributes of relationship
  7. Урок 7. 00:11:18
    Simple vs Composite Attributes, Single valued vs Multi-valued Attributes
  8. Урок 8. 00:04:15
    Stored vs Derived Attributes
  9. Урок 9. 00:02:24
    Complex Attributes
  10. Урок 10. 00:11:16
    Degree of a relationship and Cardinality Ratio
  11. Урок 11. 00:05:54
    Cardinality Ratio Explained with example
  12. Урок 12. 00:09:13
    Types of Participation - Total vs Partial Participation
  13. Урок 13. 00:05:10
    Example to illustrate Total and Partial Participation
  14. Урок 14. 00:08:07
    More Examples on Maximum and Minimum Cardinality
  15. Урок 15. 00:02:36
    Types of Relationships
  16. Урок 16. 00:09:10
    Recursive Relationship
  17. Урок 17. 00:01:20
    Example on finding the type of relationship
  18. Урок 18. 00:07:35
    Tuple, Field, Domain and Entity vs Entity types
  19. Урок 19. 00:12:37
    How Relational Model is derived from Discrete Math
  20. Урок 20. 00:03:38
    Degree of a relation, state of a relation, Intention vs Extension
  21. Урок 21. 00:07:30
    Important Rules in Relational Model
  22. Урок 22. 00:09:56
    Types of Constraints, Domain Constraints Explained
  23. Урок 23. 00:02:07
    Key Constraints - Intro
  24. Урок 24. 00:14:51
    Super Key Explained with example
  25. Урок 25. 00:09:14
    More Points on Super Key
  26. Урок 26. 00:12:29
    Key Explained with example
  27. Урок 27. 00:06:07
    Example to illustrate the difference between Key and Super Key
  28. Урок 28. 00:09:09
    Super Key vs Key vs Candidate Key vs Primary Key
  29. Урок 29. 00:09:18
    Finding the number of Super Keys
  30. Урок 30. 00:03:07
    Finding the number of Super Keys - 2
  31. Урок 31. 00:02:48
    Finding the number of Super Keys - 3
  32. Урок 32. 00:08:13
    Key Constraints
  33. Урок 33. 00:03:31
    Entity Integrity Constraints
  34. Урок 34. 00:10:30
    Foreign Key Explained with example
  35. Урок 35. 00:06:14
    Example on Foreign Key
  36. Урок 36. 00:08:12
    Difference between Foreign Key and Primary Key
  37. Урок 37. 00:01:20
    Referential Integrity Constraints
  38. Урок 38. 00:11:45
    Constraints violated by Insertion
  39. Урок 39. 00:04:58
    Constraints violated by Deletion
  40. Урок 40. 00:05:00
    Constraints violated by Updation and Viewing
  41. Урок 41. 00:13:01
    Steps taken by DBMS in case of constraint violation
  42. Урок 42. 00:05:07
    Problem on ON-DELETE CASCADE
  43. Урок 43. 00:05:54
    Problem on Referential Integrity Constraint
  44. Урок 44. 00:04:35
    Problem 1 on finding the number of Super Keys
  45. Урок 45. 00:12:15
    Finding Number of Super Keys using Venn Diagram 1
  46. Урок 46. 00:13:16
    Finding Number of Super Keys using Venn Diagram 2
  47. Урок 47. 00:03:03
    Important Observation
  48. Урок 48. 00:04:57
    Finding Number of Super Keys using Venn Diagram 3
  49. Урок 49. 00:03:40
    Finding Number of Super Keys using Venn Diagram 4
  50. Урок 50. 00:04:27
    Conversion of Entities, Attributes, Prime Attribute and Composite Attributes
  51. Урок 51. 00:14:06
    Conversion of one-to-many relationship
  52. Урок 52. 00:12:23
    Example for conversion of one-to-many relationship
  53. Урок 53. 00:07:20
    Conversion of One-to-one relationship
  54. Урок 54. 00:09:33
    Conversion of Many-to-many relationship
  55. Урок 55. 00:11:11
    A good approach to follow but not a rule
  56. Урок 56. 00:06:46
    Problem on Multivalued attributes
  57. Урок 57. 00:05:58
    Problem on finding minimum number of tables needed for conversion
  58. Урок 58. 00:03:24
    Problem on finding maximum number of tables needed for conversion
  59. Урок 59. 00:11:22
    Special Case : One-to-one relationship with total participation on both sides
  60. Урок 60. 00:05:37
    Lecture 60 continued
  61. Урок 61. 00:02:55
    Weak vs Strong Entity - Differences
  62. Урок 62. 00:12:39
    Example to illustrate Weak Entity and their conversion to Relational model
  63. Урок 63. 00:04:52
    N-ary relationships
  64. Урок 64. 00:02:35
    Identifying Relationships
  65. Урок 65. 00:01:16
    Important Notations Revisit
  66. Урок 66. 00:03:53
    Problem 1
  67. Урок 67. 00:11:51
    Attributes to relationship : one to many relationship
  68. Урок 68. 00:03:18
    Attributes to relationship : one-to-one relationship
  69. Урок 69. 00:04:21
    Attributes to relationship : many-to-many relationship
  70. Урок 70. 00:03:42
    Problem
  71. Урок 71. 00:04:22
    Introduction to Functional Dependencies
  72. Урок 72. 00:07:22
    Examples on Functional Dependency
  73. Урок 73. 00:03:17
    Important Point to note
  74. Урок 74. 00:02:59
    More Examples on Functional Dependency
  75. Урок 75. 00:06:07
    Trivial Functional Dependency
  76. Урок 76. 00:04:09
    Non Trivial Functional Dependency
  77. Урок 77. 00:02:17
    Semi Trivial Functional Dependency
  78. Урок 78. 00:15:02
    Important Point to Note
  79. Урок 79. 00:15:07
    Closure set of an attribute 1
  80. Урок 80. 00:03:57
    Closure set of an attribute 2
  81. Урок 81. 00:06:10
    Closure set of an attribute 3
  82. Урок 82. 00:06:18
    Example on finding Closure Set
  83. Урок 83. 00:02:07
    Applications of Closure operation
  84. Урок 84. 00:10:53
    Problem 1 on finding keys using Closure Operation
  85. Урок 85. 00:03:47
    Problem 2 on finding keys using Closure Operation
  86. Урок 86. 00:15:37
    Problem 3 on finding keys using Closure Operation
  87. Урок 87. 00:10:28
    Problem 4 on finding keys using Closure Operation
  88. Урок 88. 00:15:26
    Problem 4 on finding keys using Closure Operation - continued
  89. Урок 89. 00:06:47
    Problem 5 on finding keys using Closure Operation
  90. Урок 90. 00:02:38
    Problem 6 on finding keys using Closure Operation
  91. Урок 91. 00:03:13
    Problem 7 on finding keys using Closure Operation
  92. Урок 92. 00:02:16
    Problem 8 on finding keys using Closure Operation
  93. Урок 93. 00:12:41
    Problem 9 on finding keys using Closure Operation
  94. Урок 94. 00:10:02
    Problem 1 on finding keys of sub relation
  95. Урок 95. 00:07:47
    Problem 2 on finding keys of sub relation
  96. Урок 96. 00:03:34
    Problem 3 on finding keys of sub relation
  97. Урок 97. 00:04:34
    Problem
  98. Урок 98. 00:08:25
    Checking Equivalence of FD'S - 1
  99. Урок 99. 00:02:14
    Checking Equivalence of FD'S - 2
  100. Урок 100. 00:04:33
    Checking Equivalence of FD'S - 3
  101. Урок 101. 00:02:36
    Checking Equivalence of FD'S - 4
  102. Урок 102. 00:14:13
    Minimization of Functional Dependency Set - 1
  103. Урок 103. 00:08:14
    Minimization of Functional Dependency Set - 2