Database Security

Database Security Database security is concerned with authorization rules, user- defined procedures, and data encryption and authentication scheme. These are the database security rules Authentication Rules Authentication rules are restriction…

0 Comments

Deadlock In Database

Deadlock In Database Deadlock In Database: Record locking mechanism may create an undesirable situation where two or more users are waiting for the completion of each other’s actions. This situation…

0 Comments

Record Locking In Database

Record Locking In Database Record Locking In Database: Record Locking mechanism is the most common method to implement the concurrency control in DBMS. Locking means record or set of records…

0 Comments

SQL as Data Manipulation Language

SQL as Data Manipulation Language SQL as Data Manipulation Language: Besides retrieving data from a database using a SELECT statement, SQL also provides statements to manipulate the data of the…

0 Comments

Aggregate Function

Aggregate Function Aggregate Function: The aggregate function is also required in many database applications for generating reports. SQL provides this feature also. SQL provides built-in aggregate functions that are mostly…

0 Comments

SQL Joins

SQL Joins SQL Joins: A joins is a relational operation that combines row in one table to the rows in another table related table according to common values existing in…

0 Comments

Structure Query Language

Structure Query Language Structure Query Language (SQL) is the most popular and widely used relational standard database language. It is easy to learn and use. It allows the user to…

0 Comments

Normalization In Database

Normalization In Database  Normalization In Database: The process to convert the complex data structure into simple and stable data structure is called normalization. The purpose of normalization is to produce…

0 Comments