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
Write a short note on QBE? Stands for "Query By Example." QBE is a feature involved along with various database applications which gives user-friendly techniques of running da

Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

1. Use the Invoice table structure shown below to answer the following questions: a)  Draw the dependency diagram and identify the primary key and all dependencies, including al

It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia

Explain the challenges before an E-business management.

Consider employee (e_no, e_name, e_salary, d_code), dept (d_code, d_name) and dependent (depndt_name, e_no, relation). Show the names of employees in purchase and accounts departm

explain exhausitively the problems associated with er diagrams with ellustrations

You group has been hired by  TrainingrUs.com to keeps track of training revenues. TrainingrUS.com wants you to keep scheduling. COURSE table contains following information:

The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems. (a)  A transaction executing at site A updat