What are the two integrity rules, Database Management System

Assignment Help:

What are the two integrity rules?

Ans: The two integrity rules are: Entity Integrity Rule & Referential Integrity Rule.

Entity Integrity Rule - If the attribute A of relation R is a major attribute of R then A cannot agree to take null values.

Referential Integrity Rule - In referential integrity, it is make sure that a value that appears in one relation for a given set of attributes as well appears for a particular set of attributes in another relation.

Related Discussions:- What are the two integrity rules

Explain data independence, Explain data independence ? Data independenc...

Explain data independence ? Data independence is the capacity to modify the schema at one stage of a database system without having to change the schema at the further level.

What is property - properties of a database, What is property - properties ...

What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

Database Management System, please give me introduction to full data in D B...

please give me introduction to full data in D B M S in a short assignment

The natural join is equal to which product, The natural join is equal to wh...

The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

What is a transaction? and how does it differs from update, wh

What is foreign key, What is foreign key? Foreign Key - Let there are...

What is foreign key? Foreign Key - Let there are two relations in tables R and S. Any candidate key of the relation R that is referred in the relation S is known as the forei

Back up files, what is the importance of back up files

what is the importance of back up files

Database design, Why is database design important?

Why is database design important?

Binary relationship, explain in details about one to one binary relationshi...

explain in details about one to one binary relationship

Which file organization provides very fast access, Which file organization ...

Which file organization provides very fast access to any arbitrary record of a file? Hashed file organization provides very fast access to any arbitrary record of a file.

Write Your Message!

Name

Email id

Message

Verfication Code

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!

Submit Assignment

User Account

All Pages