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
What is DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.

Describe the advantage of State chart Diagram A state chart represents a state machine, emphasizing flow of control from one state to other. A state machine is a behaviour whi

Create a Student database and Retrieve the names of all students majoring in ‘CS' Consider the following relational database: STUDENT (name, student#, class, major) COURSE (co

Define Database layer? The database layer defines the data formats used in the database.

How is the database organised in Oracle? Database organized within Oracle in terms of table and table holds attributes and values. A database consists of one or more logical

Which operator is Cartesian product in relational algebra? Cartesian product in relational algebra is a binary operator. (It requires two operands. e.g., P X Q)

Primary index A primary index is a file that has a sorted series of records having two columns: a block address for that key field in the data file; and the ordering key field.

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi