SQL-ForeignKeyConstraint-Page6

-

                                                                            

👉Foreign Key Constraint

Foreign Key represent relationships between tables.

A foreign key is a column or group of columns whose values are derived from the primary key or unique key of some other table.


✅The table in which the foreign key is defined is called Foreign table or Detail table.

✅The table that defines the primary or unique key and is referenced by the foreign key is called the Primary table or Master table.


👉Features

1)Master table cannot be updated if child records exists.

2)Records cannot be inserted or deleted into a detail table if corresponding records in the master table do not exist.

3)Records of the master table cannot be deleted if corresponding records in the detail table already exist.


👉On Delete Cascade

If this option is set, a delete operation in the master table will trigger a Delete operation for corresponding records in all detail tables.

If the On Delete Set Null option is set, a Delete operation in the Master table will set the value held by the foreign key of Detail tables to null. Refer Fig 1 as shown below.


👉Foreign Key at column level

👉Foreign Key at table level

       Fig 1

👉Naming Constraints


When constraints are defined, database engine assigns a unique name to each constraint.
The convention used by Oracle is Sys_Cn where n is a numeric value that makes the constraint name unique.
Constraints can also be given a unique user-defined name along with the constraint definition.
A constraint can then be dropped by referring to the constraint by its name.

Comments

Post a Comment

Popular posts from this blog

Javascript-OOPs(Part4)-Polymorphism- (10)

-
Image
   👉 Javascript with OOPs (Polymorphism) Polymorphism is possible only with strongly typed languages, we cannot implement it in Javascript since we cannot declare strongly typed variables, and datatypes of variables are decided at runtime. We have achieved a bit of polymorphism while implementing inheritance, where in "cust" object first refers to the "Customer" class and then to the "CustomerChild" class, but still direct polymorphism is not available. Javascript variables are dynamic and they are created based on the datatype of the right-hand side value. To summarize: 1)You can create a class by using a function. You have a new keyword to create an instance. 2)You can define private and public methods by using/not using the "this" keyword. 3)Function inside a function is a closure. Closures are the core while implementing classes and objects in javascript. 4)Use Closures to create private methods, if you want to expose the method use "th...
Read more

Javascript-OOPs(Part3)-Inheritance - (9)

-
Image
   👉 Javascript with OOPs (Inheritance) In Javascript, Inheritance is done using prototype object. A prototype object is an object pointing to another object. We don't have a direct inheritance in Javascript, we can mimic inheritance using prototype. Let's say, we have one more class that inherits from Customer, and it submits to Server2. function CustomerChild(){         this.submit = function() {         alert ("this submits the data to Server2" + " "      +  this.CustomerName + " "                                       + this.CustomerCode");   }}             CustomerChild.prototype = new Customer(); var cust = new Customer(); cust.CustomerName ("John"); cust.Submit();  --this is a call to the submit method of the Customer class.  cust = new CustomerChild(); cust...
Read more

Javascript-OOPs(Part1)-Objects - (7)

-
Image
    👉 Javascript with OOPs New javascript specification ES6 introduced "Javascript classes" though it uses "function" internally,  previous frameworks don't allow the "class" keyword, and the below example creates a class using Javascript functions. *Create class and object function Customer(){ //class template } var cust = new Customer(); //object *Create Method and Properties function Customer(){        this.CustomerName = "";       this.CustomerCode = "";       this.submit = function() {            alert("Submit" + this.CustomerName + " " +                       this.CustomerCode); } var cust = new Customer();  cust.CustomerName = "John"; cust.CustomerCode = "1001"; cust.Submit(); The above example defines only variables, which are not secure and not good for developing business components. To define properties in javascript, we d...
Read more