Skip to main content

Anomalies in DBMS with Example Jitendra Ajmera The Crazy Programmer

A Database is a very complex mechanism to handle and control a large amount of data. As we all know the overall design of the database is known as database schema which is further divided into three categories as given below:

  1. Physical schema
  2. Logical schema
  3. View schema

The database or relational schema looks quite simpler and effective from the top but as we go to the bottom, we find a massive collection of data. A database has to face so many problems which we may call anomalies. An anomaly is like an unwanted situation, which may impact the integrity or consistency of a database.

Anomalies a database may face are listed as given below:

  1. Redundancy
  2. Update Anomalies
  3. Insertion Anomalies
  4. Deletion Anomalies
SID Name (Not Null) Subject (Not Null) Mobile
1 Raj English 65468154
2 Jyoti Home science 87668545
3 Vikash Maths 26865948
1 Raj Maths Null
3 Vikash Science Null

Redundancy

Duplicate data storage in a database is called redundancy. As we can see in the above table student’s name and subject’s name are repeated. This is called redundancy. Due to this lots of memory space will be wasted. Also, Redundancy creates other three anomalies.

Update Anomalies

Anomalies generated during update of a database. If a record has multiple copies, and if we make updates in a few copies and leave the remaining copies with old values, then the search result for that record may be misled the information. This may create inconsistency. Like in above given table student “Raj” is repeated twice so if we update the new mobile number for Raj at the second time then Raj has two mobile numbers. This may create confusion that which one is actually the correct mobile number. 

Insertion Anomalies

Anomalies generated during insert data into a database. In the given above table If a new student enrolled in a college but not selects any subject yet. Then we can’t insert that student’s record in the college database as we can’t leave the subject column blank for that student if NULL is not allowed. It means the student is enrolled but no data will be found for the same.

Deletion Anomalies

Anomalies generated during delete data into a database. As in above given table if we delete the subject “Home Science” since it’s no longer available then the record of student “Jyoti” is also deleted whereas Jyoti is still an active student of the college.

The post Anomalies in DBMS with Example appeared first on The Crazy Programmer.



from The Crazy Programmer https://ift.tt/CSZoQUH

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Difference between Web Designer and Web Developer Neeraj Mishra The Crazy Programmer

Have you ever wondered about the distinctions between web developers’ and web designers’ duties and obligations? You’re not alone! Many people have trouble distinguishing between these two. Although they collaborate to publish new websites on the internet, web developers and web designers play very different roles. To put these job possibilities into perspective, consider the construction of a house. To create a vision for the house, including the visual components, the space planning and layout, the materials, and the overall appearance and sense of the space, you need an architect. That said, to translate an idea into a building, you need construction professionals to take those architectural drawings and put them into practice. Image Source In a similar vein, web development and design work together to create websites. Let’s examine the major responsibilities and distinctions between web developers and web designers. Let’s get going, shall we? What Does a Web Designer Do?...
Post a Comment
Read more

A guide to data integration tools

CData Software is a leader in data access and connectivity solutions. It specializes in the development of data drivers and data access technologies for real-time access to online or on-premise applications, databases and web APIs. The company is focused on bringing data connectivity capabilities natively into tools organizations already use. It also features ETL/ELT solutions, enterprise connectors, and data visualization. Matillion ’s data transformation software empowers customers to extract data from a wide number of sources, load it into their chosen cloud data warehouse (CDW) and transform that data from its siloed source state, into analytics-ready insights – prepared for advanced analytics, machine learning, and artificial intelligence use cases. Only Matillion is purpose-built for Snowflake, Amazon Redshift, Google BigQuery, and Microsoft Azure, enabling businesses to achieve new levels of simplicity, speed, scale, and savings. Trusted by companies of all sizes to meet...
Post a Comment
Read more

Olive and NTT DATA Join Forces to Accelerate the Global Development and Deployment of AI Solutions

U.S.A., March 14, 2021 — Olive , the automation company creating the Internet of Healthcare, today announced an alliance with NTT DATA , a global digital business and IT services leader. The collaboration will fast track the creation of new healthcare solutions to transform the health experience for humans — both in the traditional healthcare setting and at home. As a member of Olive’s Deploy, Develop and Distribute Partnership Programs , NTT DATA is leveraging Olive’s open platform to innovate, build and distribute solutions to Olive’s customers, which include some of the country’s largest health providers. Olive and NTT DATA will co-develop new Loops — applications that work on Olive’s platform to provide humans real-time intelligence — and new machine learning and robotic process automation (RPA) models. NTT DATA and Olive will devote an early focus to enabling efficiencies in supply chain and IT, with other disciplines to follow. “This is an exciting period of growth at Olive, so...
Post a Comment
Read more