Data mining and Data Warehousing
DATA MINING AND DATA WAREHOUSING Data Mining: Data mining is looking for hidden, valid, and potentially useful patterns in huge data sets. Data Mining is … Read more
Team EasyExamNotes
Introduction to Concurrency Control
INTRODUCTION TO CONCURRENCY CONTROL Concurrency control is the procedure in DBMS for managing simultaneous operations without conflicting with each another. Concurrent access is quite easy … Read more
Introduction to Transaction
INTRODUCTION TO TRANSACTION A transaction can be defined as a group of tasks. A single task is the minimum processing unit which cannot be divided … Read more
What is computer network
COMPUTER NETWORK: Computer network is defined as a set of interconnected autonomous systems that facilitate distributed processing of information. Computer network is an interconnection of … Read more
Relationship among entities
RELATIONSHIP AMONG ENTITIES Relationship A relationship is represented by diamond shape in ER diagram, it shows the relationship among entities. There are four types of … Read more
SQL Functions
SQL FUNCTIONS Five Important aggregate functions are SUM, AVG, MIN, MAX and COUNT. They are called aggregate functions because they summarize the results of a … Read more
Check Constraint
CHECK CONSTRAINT The CHECK constraint is used to limit the value range that can be placed in a column. The CHECK constraint allows only certain … Read more
Primary and Foreign key
PRIMARY KEY AND FOREIGN KEY Primary Key: A primary key is a field in a table which uniquely identifies each row in a table. Primary … Read more