Scribd
Upload
8 views1 page

Database Management System Concepts

The document outlines a series of questions related to the Database Management System course, focusing on key concepts such as relational models, E-R diagrams, integrity constraints, and relational algebra operations. It includes definitions, explanations, and examples for various topics including generalization, specialization, and update operations. Additionally, it presents practical database queries related to a sample database involving sailors and boats.

Uploaded by

My Own
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
8 views1 page

Database Management System Concepts

The document outlines a series of questions related to the Database Management System course, focusing on key concepts such as relational models, E-R diagrams, integrity constraints, and relational algebra operations. It includes definitions, explanations, and examples for various topics including generalization, specialization, and update operations. Additionally, it presents practical database queries related to a sample database involving sailors and boats.

Uploaded by

My Own
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

J N N COLLEGE OF ENGINEERING,

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Module 2

Subject: Database Management System (BCS403)

Q. No Answer the following Question(s)


1. Define the following terms as they apply to the relational model of data:
domain, attribute, n-tuple, relation schema, relation state, degree of a relation, relational database
schema, and relational database state.
2. Demonstrate the concepts of Generalization & Specialization with examples.

3. Explain the steps for E-R to relational model when we have relationship of type 1: N and M: N and 1:1
between entities with example (Consider Company database with WORKS_FOR, WORKS_ON,
CONTROLS, SUPERVISION relationships) Draw the E-R diagram considering the entities
EMPLOYEE, DEPARTMENT, PROJECT, DEPENDENTS

4. Define Referential integrity constraints in relational model. With a neat block diagram, Explain the
DBMS Component Modules.

5. Draw Weak entity type with E-R diagram considering identifying relationship (consider company
database) Transform the same to schema diagram.

6. Explain the different types of update operations on relational database. How basic operation deals with
constraint violation.

7. Explain Unary relational operations with examples.

8. What is an Integrity Constraint? Explain the importance of Referential Integrity Constraint.

9. Explain the following relational algebra operation. JOIN, DIFFERENCE, SELECT, UNION

10. Discuss the E.R to Relational mapping algorithm with example for each step.

11. Explain the relational algebra operation for set theory with examples.

12. Discuss the Equijoin & Natural Join with suitable example.

13. Consider the following database


Reserves (sid, bid, day)
Sailors (sid, sname, rating, age)
Boats (bid, bname, color)
(i) Find the names of sailors who have reserved boat number 103
(ii) Find the names of sailors who have reserved a red boat
(iii) Find the id of sailors with age over 20 who have not reserved red boat
(iv) Find the names of sailors who have reserved at least one boat

You might also like