DBMS - Tech Fizz

Schema Refinement – Normalization in DBMS

Posted on August 16, 2021August 16, 2021

Schema Refinement – Normalization in DBMS

Normalization is a step-by-step process of decomposing a complex relation into a simple and stable data structure. It’s a formal process to achieve a good database design. Normalization is the bottom approach.

Posted on August 3, 2021August 16, 2021

Some other Relational Algebra

Relational Algebra Relational algebra provides a set of operations for the relational model to specify basic data retrieval requests. It is a procedural language for manipulation relations i.e, it uses a

Posted on July 26, 2021August 3, 2021

Relational algebra in DBMS

What are Relational Models The relational model, also known as RDBMS is the most widely used DBMS model because it is the easiest. The model organizes data in rows and columns in the form of a table. And relational

Posted on July 16, 2021July 28, 2021

Aggregation

The E-R model has one limitation that it is not possible to express relationships among relationships. In such a situation we use aggregation. Aggregation is an approach to modeling a relationship set as a

Posted on July 12, 2021July 16, 2021

Extended E-R Features

Superclass and Subclass Some instances of an entity class can include attributes that are not needed in other instances of the same entity class. In these cases, it is useful to use a superclass/subclass structure.

Posted on July 7, 2021July 12, 2021

Types of Relationship: Cardinally

An entity may be associated with one, none, or many occurrences of another entity. In entity-relationship diagrams, the type of relationships are represented as follows: O represents zero and | represents one.

Posted on July 4, 2021July 8, 2021

Entity-Relationship Model

An er model is a graphical representation of an organization’s data storage requirements. This model is used to design the data elements and relationships for a specified system. In ER modeling, the database

Posted on June 30, 2021July 5, 2021

Structure of DBMS

The exact architecture or structure of DBMS depends on the operating system on which it has to work because the operating system will provide the basic services, which the database system uses base for completing

Posted on June 28, 2021June 30, 2021

Important Terminology of DBMS

A database system provides a data definition language to specify the schema and a data manipulation language to express database queries and updates. These two are part of the SQL language. Schema The overall design