Foreign key in DBMS
What do you understand by the term foreign key in DBMS, and why is it employed for?
Expert
A foreign key is employed to establish relationships among relations in the relational model. Technically, a foreign key is a column (or columns) emerging in one relation which is (or are) the primary key of any other table. Though there might be exceptions, the values in the foreign key columns generally must correspond to values existing in the setup of primary key values. This correspondence requirement is made in a database employing a referential integrity constraint on the foreign key.
What is meant by star schema?
Specify the several types of Strategies?
Give a brief introduction of the term active data warehousing?
Describe briefly How can we configure mapping in the informatica?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Explain the group by in select statement? Answer: Group by clause is utilized in Teradata to eliminate repetitive values in a column or group of columns, while we se
Explain the term replication server software?
Illustrates the term bucket size, while the overlapping and collision arise at same time? Answer: Bucket size is one. When there is only one entry possible in the bu
Explain what is meant by the term catalog and its types in the cagonos?
How do I take a known dollar (totalcost) such as $240.00, back out the sales taxes from the known values using the States (VA and WV) sales tax, showing the difference so that I can print an invoice, with the fields Customer name, address, city, state Subtotal, sales tax and totalcost $240.00. All
18,76,764
1941641 Asked
3,689
Active Tutors
1428436
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!