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(Part2)-AbstractionAndEncapsulation- (8)

-
Image
    👉 Javascript with OOPs (Abstraction and Encapsulation) Abstraction is showing what's necessary and Encapsulation is hiding the complexity. For ex, if we are making calls to the server, we may have methods like: this.CreateConnection = function() {} this.CreateHttpObject = function() {} Showing these methods to the user who is using this component may increase the complexity of the component. User may have to call          cust.CreateConnection();          cust. CreateHttpObject();          cust.Submit(); So  CreateConnection and CreateHttpObject has to be private, but the time you declare the methods using "this" keyword, it becomes public. Below example solves this problem by creating private functions. If user makes a call to CreateConnection or CreateHttpObject, he will  receive "Not Found" error. *Create private methods function Customer(){        function CreateConnection() {};       function CreateHttpObject () {};       this.submit = function() {    
Read more

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(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 don't have direct "getter" and "setter&quo
Read more