Define rule that value of foreign key appear in other table, Database Management System

Determine the rule that a value of a foreign key should appear as a value of some particular table is called a

Ans: Referential constraint.

The rule that a value of a foreign key should appear as a value of some particular table is known as a referential constraint. (Referential integrity constraint is referred with foreign key).

Related Discussions:- Define rule that value of foreign key appear in other table

To eliminate duplicate rows-data manipulation language, To eliminate duplic...

To eliminate duplicate rows (distinct operator) Example: SELECT DISTINCT DEPTNO FROM EMP;

Define query language, Define query language? A query is a statement ...

Define query language? A query is a statement requesting the retrieval of information. The portion of DML that includes information retrieval is known as a query language.

Database tables design and test queries, Load sample data into the database...

Load sample data into the database tables design and test queries to return the following information • All rows and columns for employees • All rows and columns for customers •

Example of primary key, Suppose that in an organisation, an employee may do...

Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the

Creating a view-data control, Creating a view: A query can be embed...

Creating a view: A query can be embedded within the CREATE VIEW STATEMENT A query can have complex select statements containing join, groups and sub- queries A quer

What is database utility, What is database utility? Database utility is...

What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

What is a block and a block number, What is a block and a block number? ...

What is a block and a block number? A block is a contiguous sequence of sectors from a single track of one platter. Every request specifies the address on the disk to be refere

Concurrent transactions-backup and recovery, Representing complex relations...

Representing complex relationship among data A database may contain varieties of data interrelated to each other in numerous ways. A DBMS must have the capability to represent

Cataloguing, differences between a classified catalog and a dictionary cata...

differences between a classified catalog and a dictionary catalog

Need web-based database, Our company hires independent contractors to insta...

Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages