Scribd
Upload
5 views2 pages

DBMS-Module2 Important Questions

The document discusses various aspects of relational databases, including update operations, joins, relational algebra operations, and integrity constraints. It also covers the mapping from E.R to relational models and provides examples of relational algebra expressions for specific queries. Overall, it serves as a comprehensive guide to understanding relational database concepts and operations.

Uploaded by

suhafathima3110
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views2 pages

DBMS-Module2 Important Questions

The document discusses various aspects of relational databases, including update operations, joins, relational algebra operations, and integrity constraints. It also covers the mapping from E.R to relational models and provides examples of relational algebra expressions for specific queries. Overall, it serves as a comprehensive guide to understanding relational database concepts and operations.

Uploaded by

suhafathima3110
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1. Explain the different types of update operations on relational database.

How basic
operation deals with constraint violation.
2. Discuss the Equijoin & Natural Join with suitable example.
3. Explain Unary and binary relational operations with examples.
4. What is an Integrity Constraint? Explain the importance of Referential Integrity
Constraint.
5. Explain the following relational algebra operation.
JOIN, DIFFERENCE, SELECT, UNION
6. Discuss the E.R to Relational mapping algorithm with example for each step.
7. Explain the different Relational Model constraints.
8. Explain Schema based Constraints with example?
9. Given the relational tables:
Student Project

Language Enrollment

Write relational algebra expression for the following:


(i) Rename the student table to Learner and display it.
(ii) Find the students (learners) who are not enrolled in any project.
(iii) Find the students who are enrolled in all projects.
(iv) Find the students who are not enrolled in any project.
(v) Find the students who are enrolled in both the 'Alpha' and 'Beta projects.

10. Given the relational tables:

Employee Department
Project

Write relational algebra expression for the following:


(i) Find the names and salaries of all employees in the 'IT' department.
(ii) Find the ID's and names of employees who are in the 'IT' department and have a
salary greater than 6000.
(iii) Find the ID's and names of employees who are either in the 'HR' department or have
a salary greater than 6000.
(iv) Find the names of employees who are not in the 'IT' department
(v) Find the names of employees along with their department names.

You might also like