Department of Information Technology
B. Tech. [SEM V (IT)]
IMPORTANT QUESTION SHEET-1
(Session: 2024-25)
BCS-501:Database Management System
Unit No. & Name: I- Introduction Course Outcome: CO1:Apply knowledge of
database for real life
applications.
Date of Distribution: 16/12/2024 Name of Faculty: Ankit Singh
Subjective Questions
Overview of database , File System, ER model
Q1) Explain the process of reducing an ER diagram to relational tables with an example.
Q2) Discuss the components of an ER model and create an ER diagram for a library management
system.
Q3) Discuss the concepts of generalization and aggregation with appropriate examples.
Keys and Schema
Q4) What is a schema? How is it different from an instance?
Q5) Define superkey, candidate key, and primary key with examples.
ER and Mapping Constraint
Q6) Write a short note on the Extended ER Model.
Q7) What are mapping constraints? Provide examples.
Generalization and Architechture
Q8) Define the terms generalization and specialization in the context of ER modeling.
Q9) Describe the three-schema architecture of database systems with a diagram.
Data Independence and architecture
Q10) Explain data independence and its types. Why is it important in DBMS?
Q11) Explain the three-tier architecture of a DBMS with a neat diagram.
Q12) What are data models ? Briefly explain different types of data model
SUPPLEMENTARY QUESTIONS
Relational Data Model
Q1) Describe Mapping Constraint with its types
Q2) What is Relational Calculus ?
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 [Link]
…………………. X………………….
Signature of Faculty: ______________ Signature of HOD: _______________
(With Date) (With Date)
Page 2 of 2
