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
Team EasyExamNotes
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
Introduction to Data Models
INTRODUCTION TO DATA MODELS In DBMS data models define how the logical structure of a database is modeled. Data models define how data is connected … Read more
Database applications
DATABASE APPLICATIONS Facebook Amazon eBay Microsoft Access Wikipedia YouTube Airlines ticket systems IRCTC Flipkart Snapdeal