Insertion anomaly-data redundancy, Database Management System

Assignment Help:

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.

 


Related Discussions:- Insertion anomaly-data redundancy

Neo4j, I have one assignment that has to be done in neo4j

I have one assignment that has to be done in neo4j

Benefits abd drawback of hashed file organisation, Benefits of Hashed file ...

Benefits of Hashed file Organisation 1.      Insertion or search on hash-key is quick. 2.      Best if equality search is required on hash-key. Drawbacks of Hashed file

Domain constraint, Domain Constraint It shows that each attribute in a ...

Domain Constraint It shows that each attribute in a relation has to contain an atomic value only from the corresponding domains. The data types associated with commercial RDBMS

Database, real life situations where database management system are most su...

real life situations where database management system are most suitable

Give an example of operations from the functions of a bank, Give an example...

Give an example of Operations from the functions of a bank. For creation of a saving account, you can write: bank::: create -savings-account (customer)->account. For oper

View of data, how to submit answers softcopy

how to submit answers softcopy

Two types of blocks in the fixed -length representation, What are the two t...

What are the two types of blocks in the fixed -length representation? Define them. Anchor block: Have the first record of a chain. Overflow block: Have the records other tha

Multi-key file organisation, Multi-Key File Organisation In this part, ...

Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi

Bid Cunt, How do I use strap on?#

How do I use strap on?#

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd