Insertion anomaly-data redundancy, Database Management System

Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have a value for the primary key as entity integrity constraint needs that a key may not be totally or partially NULL. Though, in the given relation if one required inserting the number and name of a new course in the database, it would not be feasible until a student enrols in that course. Likewise information about a new student cannot be inserted in the database unless the student enrols in a course. These problems are known as insertion anomalies.

 

Posted Date: 3/7/2013 1:43:09 AM | Location : United States







Related Discussions:- Insertion anomaly-data redundancy, Assignment Help, Ask Question on Insertion anomaly-data redundancy, Get Answer, Expert's Help, Insertion anomaly-data redundancy Discussions

Write discussion on Insertion anomaly-data redundancy
Your posts are moderated
Related Questions
Which of the operations constitute a basic set of operations for manipulating relational data? Relational algebra operations constitute a basic set of operations for manipulati

Problem : AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P

Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people

tell me the functionality,advantages and disadvantages of student database

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

There are three main sources of utilities and applications for a DBMS: a. Vendor applications and utilities are given for working with or maintaining the database, and generally

what do you mean by consistency in rdbms?

There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes

Define the categories of SQL Statements? 1) Statements that don't return a result set. This statement class includes INSERT, DELETE, and UPDATE. 2)Statements that return

Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.