Recent Posts

Functional dependency in 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 same table. For example: Suppose… Read More

Multivalued dependency in 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 colors (Black and white) in… Read More

Transitive dependency in 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 dependency if the following three… Read More

DBMS languages

Database languages are used for read, update and store data in a database. There are several such languages that can be used for this purpose; one of them is SQL… Read More

Data models in DBMS

A 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 Data Models: Object based… Read More

Hierarchical model in 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 of this model is that… Read More

Relational model in 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 represents attribute of an entity… Read More

E-R model in DBMS

An entity–relationship model (ER model) is a systematic way of describing and defining a business process. An ER model is typically implemented as a database. The main components of E-R… Read More

keys in DBMS

Key plays an important role in relational database; it is used for identifying unique rows from table. It also establishes relationship among tables. Primary Key - A primary is a… Read More

Page 1 of 561234...1020...Last »