Advance Concept In Data Bases

Explain the Three Levels of Abstraction in data modeling and design.

Consider the following relational database of college:

Student (RollNumber, StudentName, Address)

Teacher (TeacherID, TeacherName, Teaching Subject)

College (RollNumber, TeacherID)

Write Relational Algebra expression for following requests.

1. Find the name of student who lives in "New Delhi".
2. Find the name of Teacher who teaches "Database Management System" subject.
3. Find the Name of teacher who teaches "Computer Organization" to "Mr. Ramakrishna"
4. Insert a new tuple into relation Teacher
5. Delete records of students whose address is "Mumbai".

What is an SQL Query block? Why is it important in the context of Query optimization.

Explain the structure of query evaluation plan.

Explain in detail about special databases and multimedia databases.

When does deadlock occurs? Explain two phase commit protocol with an example.

What are the characteristics of Object-Oriented DBMS? List the various open-source object relational mapping tools are available.

Write brief note on ORDBMS design and ORDMBS Query Language.

Describe the various components of data warehouse and explain the different data model used to store the data with example.

What is Data Mart? How it is different from data warehouse?

Draw an ER Diagram for Week entity set and Strong entity set with an example.

Why BCNF is more desirable normal form than lower forms? Give an example of relational schema that is in 3^rd normal form but not in BCNF.

What is recovery in Distributed databases? Explain the concurrency problems in distributed databases.

What is an object-oriented database management system? What are the building blocks of an object-oriented database? List the advantage and disadvantages of object-oriented databases?

Describe pipelining and write its advantages

How is the cost of a plan estimated?

What considerations are involved in designing a data warehouse?