Database Normalization

Database Management System

Types of DBMS System

Advantages Of DBMS

  1. A DBMS uses various powerful functions to effectively store and retrieve data.
  2. The DBMS implies integrity constraints to get a high level of protection against prohibited access to data.
  3. It provides backup and recovery subsystems that create an automatic backup of data from hardware and software failures and restores the data if required.
  4. A DBMS schedules concurrent access to the data in such a manner that only one user can access the same data at a time.

Dis-Advantages Of DBMS

  1. The cost of Hardware and Software of a DBMS is quite high which increases the budget of your organization.
  2. In certain organizations, all information is integrated into a common database that may be destroyed due to electrical loss or the storage medium database is compromised.

Need For Normalization

Types of Normal Forms

  1. First Normal Form — 1NF
Before
After
Before
After
Before
Before
After
Before
After

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Installing Flipper-Glog pod install re

On testing software

Working with Spark SQL

Find the Easy Pass — HackTheBox! [Beginner track]

Python Data Types

Analysis of CPython

Digital Transformation through Business Process Re-Engineering

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sudhanshu Paliwal

Sudhanshu Paliwal

More from Medium

Postgres SQL with Micronaut on Heroku

Explore Data Structure and Algorithm Part-2

Column or expression in SELECT list not valid exception

Specification Design Pattern