Department of Information Technology

B. Tech. [SEM V (IT)]

IMPORTANT QUESTION SHEET-2
(Session: 2024-25)

BCS-501:Database Management System

Unit No. & Name: 2.Relational data Course Outcome: CO2: Apply query
Model and Language processing techniques to
automate the real time
problems of databases.
Date of Distribution: 16/12/2024 Name of Faculty: Ankit Singh

Subjective Questions
Referential Integrity
Q1) Q1.Define the term degree and cardinality.
Q2) What do you mean by referential integrity ?
Q3) Explain entity integrity constraints.
Key Constraint
Q4) Define foreign key constraint.
Q5) With an example show how a referential integrity can be implemented.
Joins and SQL
Q6) What is the role of join operations in relational algebra ?
Q7) What are characteristics of SQL?
Views and Queries
Q8) What is the purpose of view in SQL ?
Q9) What do you mean by query and subquery ?
Tiggers and Cursors
Q10) Write the purpose of trigger.
Q11) What do you mean by PL/SQL?
Q12) What is union compatibility ?

SUPPLEMENTARY QUESTIONS
Relational Algebra
Q1) What is Relational Algebra ?
Q2) Define constraint and its types in DBMS.

REFERENCES

Page 1 of 2
 TEXT BOOKS:
Ref. [ID] Authors Book Title Publisher/Press Edition &Year of
Publication
Abraham Silberscatz ,
[T1] Database System Concept McGraw-Hill Education 7th Edition 2019
Henry F Korth
Ramez Elmasri , Shamkant
[T2] Fundamentals of Database Systems Pearson Education 8th Edition 2003
B .Navathe
REFERENCE BOOKS:
Edition &Year of
Ref. [ID] Authors Book Title Publisher/Press
Publication
Raghu Ramakrisnan ,
[R1] Johannes Database Management System McGraw-Hill Education 3rd Edition 2014

ONLINE/DIGITALREFERENCES:
Ref. [ID] Source Name Source Hyperlink
[D1] GeeksforGeeks-DBMS https://www.geeksforgeeks.org/dbms/

…………………. X………………….

Signature of Faculty: ______________ Signature of HOD: _______________

(With Date) (With Date)

Page 2 of 2