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

Oracle, comparison of oracle RDBMS with MySQL

comparison of oracle RDBMS with MySQL

Difference between operating system and database security, Difference betwe...

Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t

What is gathering information and producing erd, What is Gathering informat...

What is Gathering information and Producing ERD Gathering information: This could be a written document that explains the system in question with reasonable quantity of detai

Development of an ER diagram and database implementation, i want answers th...

i want answers this assignment now if yiu can maket for me now ?

By which techniquestransaction processing is associated, By which technique...

By which techniquesTransaction processing is associated? Transaction processing is associated by producing detail, summary, or exception reports and recording a business activi

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

How do you find the final model after iterative analysis, How do you find t...

How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur

Maping constraits, #question.what is mapping constraints and types?.

#question.what is mapping constraints and types?.

Explain growing phase of locking, Explain Growing Phase of locking Grow...

Explain Growing Phase of locking Growing Phase: In this phase the transaction can only obtain locks, but cannot release any lock. The transaction enters the growing phase as so

Define thomas write rule, Define Thomas write rule Thomas' write rule: ...

Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages