SQL | DDL, DML, DCL Commands
Structured Query Language(SQL) is the database language which is used to perform certain operations on the existing database and also this language is used to … Read more
DBMS
Advantages and Disadvantages of DBMS
Advantages of DBMS DBMS offers a variety of techniques to store & retrieve data DBMS serves as an efficient handler to balance the needs of … Read more
Introduction to Database
Before knowing database one must know about data. Data In simple words data can be facts related to any object in consideration. For example your … Read more
Introduction to DBMS
DBMS stands for Database Management System. DBMS means database with management system. That means a system used to manage database. Database Management System is a … Read more
RGPV DBMS Explain the concepts of generalization and aggregation with appropriate examples
RGPV 2019Q. Explain the concepts of generalization and aggregation with appropriate examples ? Ans. Generalization: It is a bottom-up approach in which two lower level … Read more
RGPV solved Database approach vs Traditional file accessing approach
RGPV 2019Q. Differentiate between Database approach vs Traditional file accessing approach ? Ans. Database approach Traditional file accessing approach All Application shares a pool 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