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

Define deadlock prevention, Define Deadlock prevention These protocols... Define Deadlock prevention These protocols make sure that the system will never enter a deadlock state. There are two methods to deadlock prevention. One approach makes sure t

SQL, Ask Write the SQL code that will create the table structure for a tabl... Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in

What is a foreign key, What is a foreign key, and what is it used for? ... What is a foreign key, and what is it used for? A foreign key is used to establish relationships between relations in the relational model. Technically, a foreign key is a colu

Processing arrays, 1. A company wants a report containing a breakdown of pa... 1. A company wants a report containing a breakdown of payroll by department. Input, which should be stored in 3 parallel arrays, includes each employee's department number, hourly

DB TECHNOLOGIES, WHAT IS DATABASE TECHNOLOGIES WHAT IS DATABASE TECHNOLOGIES

What is rdbms terminology for a row, What is RDBMS terminology for a row? ... What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row

Define physical and logical data independence, Define physical and logical ... Define physical and logical data independence. How does this architecture help in achieving these? Data independence entails that change in one view must not need a change in t

Explain superkey, Explain Superkey Ans: A superkey is described in the ... Explain Superkey Ans: A superkey is described in the relational model of database organization like a set of attributes of a relation variable for which it holds that in all re

Sequential file organisation, Sequential File Organisation The most nec... Sequential File Organisation The most necessary way to organise the collection of records in a file is to use sequential Organisation. Records of the file are stored in series

B+ tree, construct a B+ tree for the following set of key value (2,3,5,7,11... construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six C. eigh