• March 27, 2025

Database Users, DBMS(BCA II, MCA I, M.Sc. IT) Gurukpo

Ms. Payal Khandelwal, Assistant Professor, Biyani Girls College explained about DB users, 12 codd rules, Definition and concept of schemas and instances. www.gurukpo.com, www.biyanicolleges.org

Data Models ,DBMS(BCA II, MCA I), Gurukpo

Ms. Payal Khandelwal, Assistant Professor, Biyani Girls College explained about Data Models based on their mapping cardinalities and, 4 data models . www.gurukpo.com, www.biyanicolleges.org

Introduction to DBMS (DBMS)

Ms. Payal Khandelwal, Assistant Professor, Biyani Girls College explained about DBMS, its architecture and difference between DBMS and File System . www.gurukpo.com, www.biyanicolleges.org <iframe width=”560″ height=”315″ src=”https://www.youtube.com/embed/kTVLO9F1QoY” frameborder=”0″ allowfullscreen></iframe>

Concept of Keys(ADBMS)

Mr. Vivek Sharma Assistant Professor, Biyani Girls College explained about key concept.It is an attribute which is uniquely retrieve tuple or set of tuples. www.gurukpo.com, www.biyanicolleges.org <iframe width=”560″ height=”315″ src=”https://www.youtube.com/embed/-ZD8XeG0DH4″ frameborder=”0″ …

Data Models (ADBMS)

Mr. Vivek Sharma, Assistant Professor, Biyani Girls College explained about Data Models. It is a way which is useful to store information or records in the Database. www.gurukpo.com, www.biyanicolleges.org <iframe width=”560″ …

Constraint Satisfaction Lecture by Dr. Madhu Sharma.

This is part of lecture presented by Dr. Madhu Sharma, Head of the Department (MCA) in Biyani Institute of Science and Management. This lecture is about – Constraint Satisfaction Algorithm, in …

What is File System versus DBMS? DBMS (IT) Gurukpo

Ms. Payal Khandelwal, Assistant Professor, Biyani Groups of College explained about why we switched from file system to Data Base Management System to store data, www.gurukpo.com, www.biyanicolleges.org

Aggregate functions in SQL Lecture by Ritu Kumawat.

Aggregate functions calculate the values of a column and return single value as result. These are: 1.avg() 2.min() 3.max() 4.count() 5.sum() 6.first() 7.last()