Unit IV: Queries in Database – Database Management System

BCA 4th Semester DBMS (Database Management System) Notes Pdf, Queries in Database – Database Management System

Queries in Database – Database Management System

In this unit named Queries in Database – Database Management System” readers and viewers will get information regarding the following topics:

  1. Introduction to Query in Database
  2. Methods for Creating Queries
  3. Selecting Parameters from a Menu, Query by Example (QBE)
  4. Power of Queries
  5. Query Language
  6. Query Processing
  7. Steps of Query Processing
  8. Parsing and Translation, Optimization, Evaluation
  9. Query Optimization
  10. Equivalence Rules
  11. Relational Algebraic Query Tree
  12. Steps for Query Optimization through Query Tree
  13. Computation of Relational Algebra Operators
  14. Computation of Selection
  15. Computation of Joins
  16. Multiple Tables
  17. Joining Tables
  18. Conditional Join, Equijoin, Natural Join, Left Outer Join, Right Outer Join, Full Outer Join
  19. Hints on Joining Tables
  20. SQL Server Hash Joins, SQL Server Remote Joins, SQL Server Loop Joins, SQL Server Merge Joins
  21. Table Alias
  22. View
  23. Creating Views, Updating Views, Inserting Rows into a View, Deleting Rows into a View, Dropping Views

This article Queries in Database – Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

BCA 4th Semester DBMS (Database Management System) Notes:

Unit I: Operating System Overview - Database Management System

Unit II: Designing A Database - Database Management System

Unit III: Data Normalization - Database Management System

Unit V: Advanced Queries In Database - Database Management System

Unit VI: Developing Stored Procedures - Database Management System

Unit VII: Creating DML Triggers - Database Management System

Unit VIII: Physical Design - Database Management System

Unit IX: Database Application Types - Database Management System

Unit X: Distributed Database System - Database Management System

Unit XI: Object Oriented Database - Database Management System

No comments

Post a Comment

Share your honest opinion and feedback about this website, through the comment box.

Don't Miss
© 2019 - All Rights Reserved
Lots of BCA Notes (Pokhara University)