SQL Constraints, NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT, CREATE INDEX

SQL Constraints

(Image by - Sharma Guides | Subham232330)

Constraints

|- CHECK

|- NOT NULL

|- UNIQUE

|- PRIMARY KEY

|- DEFAULT

|- FOREIGN KEY

|- INDEX

* These constraints are also known as Integrity Constraints.

* SQL Constraints:- Constraints are the rules and restrictions applied to the data in a table.

* NOT NULL:- Value cannot be Null in a column.

* UNIQUE:- Value cannot be the same in a column.

* PRIMARY KEY:- Used to uniquely identify a row.

* FOREIGN KEY:- References a row in another table.

* CHECK:- Satisfies a specific condition.

* DEFAULT:- Set default value.

* CREATE INDEX:- Used to speed up the reading process.

Comments

Joins in DBMS

DBMS Joins: Inner, THETA, Outer, Equi Types of Join Operations Join in DBMS is a binary operation that allows you to combine join product and selection in one single statement. The goal of creating a join condition is that it helps you to combine the data from two or more DBMS tables. The tables in DBMS are associated using the primary key and foreign keys. Types of Join There are mainly two types of joins in DBMS: Inner Joins: Theta, Natural, EQUI Outer Join: Left, Right, Full Inner Join Inner Join is used to return rows from both tables which satisfy the given condition. It is the most widely used join operation and can be considered as a default join-type An Inner join or equijoin is a comparator-based join which uses equality comparisons in the join-predicate. However, if you use other comparison operators like “>” it can’t be called equijoin. Inner Join further divided into three subtypes: Theta join Natural join EQUI join Theta Join Theta Join allows you to merge two tables ba...

Implement a ping server program using TCP socket

Implement a ping server program using a TCP socket Server-side import java.net.*; import java.io.*; import java.net.SocketException; import java.util.*; import java.lang.*; class pingtcpserver { public static void main(String args[]) throws Exception { ServerSockets=null; Socketsoc=null; String smsg=""; PrintWriter pw; try { s=new ServerSocket(5219); System.out.println("Connecting with client ....... "); soc=s.accept(); System.out.println("Connection Established"); BufferedReader brin=new BufferedReader(new InputStreamReader(soc.getInputStream())); for(int i=0;i<5;i++) { pw=new PrintWriter(soc.getOutputStream(),true); smsg=brin.readLine(); if(i==3) Thread.sleep(100); pw.println(smsg); }} catch(SocketException e) { System.out.println(e); } finally { s.close(); soc.close(); }}} Client-side import java.io.*; import java.net.*; import java.net.SocketException; import java.util.*; class pingtcpclient { public static void main(String args[]) throws Exception ...

DBMS Keys

DBMS Keys KEYS in DBMS is an attribute or set of attributes which helps you to identify a row (tuple) uniquely in a relation(table). They allow you to find the relation between two tables. Keys help you uniquely identify a row in a table by a combination of one or more columns in that table. Key is also helpful for finding unique record or row from the table. Database key is also helpful for finding unique record or row from the table. Example: Employee ID FirstName LastName 11 Andrew Johnson 22 Tom Wood 33 Alex Hale In the above-given example, employee ID is a primary key because it uniquely identifies an employee record. In this table, no other employee can have the same employee ID. Here are some reasons for using sql key in the DBMS system. Keys help you to identify any row of data in a table. In a real-world application, a table could contain thousands of records. Moreover, the records could be duplicated. Keys in RDBMS ensure that you can uniquely identify a table record despite ...

Sharma Guides

Search This Blog