## MSC (Biotechnology) Final Year Model Papers

### 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>

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″ …

### 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()

### Types of keys in DBMS (Primary Key, Candidate, Super, Alternate, Foreign key)

1. Primary key 2. Candidate key 3. Super key 4. Alternate key

### Users of DBMS by Ms. Ritu Kumawat

Database management System 1. End Users 2. Application Programmers 3. Database Administrator 4. System analyst

### Constraints in SQL by Mr. Ajay Sharma, Biyani Girls College, Jaipur, Rajasthan

In this Video, Mr. Ajay Sharma, assistant professor, Biyani Girls College, Jaipur, explains about the constraints in SQL. There are various types of SQL which are as follows: 1. Primary key …

### What is Data flow Dialogue by Ms. Neha Tiwari of Biyani Girls College, Jaipur

In this video Ms. Neha Tiwari, Assistant Professor, Biyani Girls College explains about Data flow Dialogue which is a structured tool technique. It describes the flow of process in system. It …