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

Ask an Expert

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

Write your message here..

Related Questions

Which of the operations constitute a basic set of operations, Which of the ... 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

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

Define tables students and teachers as sub tables of people, Write a query ... 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

Student database, tell me the functionality,advantages and disadvantages of... tell me the functionality,advantages and disadvantages of student database

What is the use of group by clause, What is the use of group by clause? ... 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

Sources of utilities for a dbms, There are three main sources of utilities ... 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

Consistency, what do you mean by consistency in rdbms? what do you mean by consistency in rdbms?

There are two major types of fragmentation, There are two major types of fr... 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, Define the categories of SQL State... 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 displaying an er schema as an er diagram, Explain the conventions f... 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.