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
MCA Fifth Semester Model Papers
Faculty: IT 2019 Sample Papers with Solutions Sr. No. Paper Name Question Paper Link Solution Link 1. Cloud Computing Click Here Click Here 2. Analysis & Design of Algorithm Click Here …
MCA Third Semester Model Papers
Faculty: IT 2019 Sample Papers with Solutions Sr. No. Paper Name Question Paper Link Solution Link 1. Java Technologies Click Here Click Here 2. Web Technologies Click Here Click Here 3. …
MCA First Semester Model Papers
Faculty: IT 2019 Sample Papers with Solutions Sr. No. Paper Name Question Paper Link Solution Link 1. Discrete Mathematics Click Here Click Here 2. Programming in C & C++ Click Here …
MSC (Biotechnology) Previous Year Model Papers
Faculty: Science 2019 Sample Papers with Solutions Sr. No. Paper Name Question Paper Link Solution Link 1 Immunology, Virology and Pathogenesis Click Here Click Here 2. Cell Biology Click Here Click …
MSC (Biotechnology) Final Year Model Papers
Faculty: Science 2019 Sample Papers with Solutions Sr. No. Paper Name Question Paper Link Solution Link 1 Plant Biotechnology Click Here Click Here 2. Genetic Engineering Click Here Click Here
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()
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
