Khandesh Bahuuddeshiya Sanstha’s

College of Engineering & Technology,

North Maharashtra Knowledge City, Jalgaon

Mid Semester Examination – Sept/Oct. 2025

Department of Computer Engineering
Academic Year: 2025-26
Course Name with Code: - BTCOC501- Database System Semester:-V
Max. Marks: 20 Class:- T.Y.BTech
Duration: 1 Hr. Date:- 29 /09/2025
CO Course Outcomes (CO)
CO1 Explain fundamental concepts of database systems, database environment, and data models.
CO2 Design Entity–Relationship (E–R) diagrams and convert them into relational schemas.
CO3 Apply relational algebra and relational calculus to query databases
QUESTION PAPER FORMAT
Instruction to the candidates:
1. Neat Diagram must be drawn whenever necessary.
2. Figures to the right indicate full marks.
3. Assume suitable data, if necessary
Mapping
Q. Blooms
Questions Marks with
No. Taxonomy
COs
Q. No. 1 Attempt MCQ question of the following. (1x6=6)
1. Which of the following is not a characteristic of a database
system?
a) Data redundancy
Remember
b) Data independence
01 CO1
Understand
c) Data integrity
d) Data security
2. A DBMS acts as an interface between:
a) Data and operating system
b) Data and application programs Remember
01 CO1
Understand
c) Data and compiler
d) Data and assembler
3. In an ER diagram, a weak entity is represented by:
a) Oval
b) Double rectangle Remember
01 CO2
Understand
c) Diamond
d) Single rectangle
4. If an entity set has a primary key, it is called:
a) Weak entity set
b) Strong entity set Remember
01 CO2
Understand
c) Sub entity set
d) Composite entity set
 5. Which of the following is a fundamental operation in relational
algebra?
a) Selection
Remember
b) Join
01 CO3
Understand
c) Intersection
d) Division
6. The operation that retrieves only the required attributes from
a relation is:
a) Union
Remember
01 CO3
b) Projection Understand
c) Selection
d) Cartesian product

Q. No. 2 Attempt any Two question of the following. (4x2=8)

(A) Define DBMS. Explain any two advantages of using a DBMS
Remember
04 CO1
over a traditional file system. Understand
(B) Explain the three levels of DBMS architecture (external,
04 CO1 Analyze
conceptual, internal).
(C) Draw an ER diagram for a library management system and
04 CO2 Create
convert it into relational schema.
Q. No. 3 Attempt any One question of the following. (6x1=6)
(A) Explain the basic operations of relational algebra with Understand,
06 CO3
suitable examples. Apply
Draw an E–R diagram for a hospital management system
(B) showing patients, doctors, and treatments. Convert it into 06 CO2 Create
a relational schema.