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 | Filed Under: DBMS

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]

Cardinality in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

RDBMS Concepts

By Chaitanya Singh | Filed Under: DBMS

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]

Functional dependency in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

Multivalued dependency in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

Transitive dependency in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

Non trivial functional dependency in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

Trivial functional dependency in DBMS with example

By Chaitanya Singh | Filed Under: DBMS

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]

DBMS languages

By Chaitanya Singh | Filed Under: DBMS

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]

Data models in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

Hierarchical model in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

Relational model in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

Entity Relationship Diagram – ER Diagram in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

keys in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

Alternate key in DBMS

By Chaitanya Singh | Filed Under: DBMS

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]

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

Copyright © 2012 – 2023 BeginnersBook . Privacy Policy . Sitemap