BeginnersBook

  • Home
  • Java
    • Java OOPs
    • Java Collections
    • Java Examples
  • C
    • C Examples
  • C++
    • C++ Examples
  • DBMS
  • Computer Network
  • Python
    • Python Examples
  • More…
    • jQuery
    • Kotlin
    • WordPress
    • SEO
    • JSON
    • JSP
    • JSTL
    • Servlet
    • MongoDB
    • XML
    • Perl

ACID properties in DBMS

By Chaitanya Singh

To ensure the integrity and consistency of data during a transaction (A transaction is a unit of program that updates various data items, read more… [Read More]

Posted Under: DBMS

Cardinality in DBMS

By Chaitanya Singh

In DBMS you may hear cardinality term at two different places and it has two different meanings as well. In Context of Data Models: In… [Read More]

Posted Under: DBMS

RDBMS Concepts

By Chaitanya Singh

RDBMS stands for relational database management system. A relational model can be represented as a table of rows and columns. A relational database has following… [Read More]

Posted Under: DBMS

Functional dependency in DBMS

By Chaitanya Singh

The attributes of a table is said to be dependent on each other when an attribute of a table uniquely identifies another attribute of the… [Read More]

Posted Under: DBMS

Multivalued dependency in DBMS

By Chaitanya Singh

Multivalued dependency occurs when there are more than one independent multivalued attributes in a table. For example: Consider a bike manufacture company, which produces two… [Read More]

Posted Under: DBMS

Transitive dependency in DBMS

By Chaitanya Singh

A functional dependency is said to be transitive if it is indirectly formed by two functional dependencies. For e.g. X -> Z is a transitive… [Read More]

Posted Under: DBMS

Non trivial functional dependency in DBMS

By Chaitanya Singh

If a functional dependency X->Y holds true where Y is not a subset of X then this dependency is called non trivial Functional dependency. For… [Read More]

Posted Under: DBMS

Trivial functional dependency in DBMS with example

By Chaitanya Singh

The dependency of an attribute on a set of attributes is known as trivial functional dependency if the set of attributes includes that attribute. Symbolically:… [Read More]

Posted Under: DBMS

DBMS languages

By Chaitanya Singh

Database languages are used to read, update and store data in a database. There are several such languages that can be used for this purpose;… [Read More]

Posted Under: DBMS

Data models in DBMS

By Chaitanya Singh

Data Model is a logical structure of Database. It describes the design of database to reflect entities, attributes, relationship among data, constrains etc. Types of… [Read More]

Posted Under: DBMS

Hierarchical model in DBMS

By Chaitanya Singh

In hierarchical model, data is organized into a tree like structure with each record is having one parent record and many children. The main drawback… [Read More]

Posted Under: DBMS

Relational model in DBMS

By Chaitanya Singh

In relational model, the data and relationships are represented by collection of inter-related tables. Each table is a group of column and rows, where column… [Read More]

Posted Under: DBMS

Entity Relationship Diagram – ER Diagram in DBMS

By Chaitanya Singh

An Entity–relationship model (ER model) describes the structure of a database with the help of a diagram, which is known as Entity Relationship Diagram (ER… [Read More]

Posted Under: DBMS

keys in DBMS

By Chaitanya Singh

Key plays an important role in relational database; it is used for identifying unique rows from table. It also establishes relationship among tables. Types of… [Read More]

Posted Under: DBMS

Alternate key in DBMS

By Chaitanya Singh

As we have seen in the candidate key guide that a table can have multiple candidate keys. Among these candidate keys, only one key gets… [Read More]

Posted Under: DBMS

  • « Previous Page
  • 1
  • …
  • 3
  • 4
  • 5
  • 6
  • Next Page »

Copyright © 2012 – 2022 BeginnersBook . Privacy Policy . Sitemap