Government Engineering
College, Modasa
|
|||
Mid Semester Exam B.E. IT sem 3rd
|
|||
Subject: Database Management
System(2130703)
|
|||
Marks:30 Time: 1h30m
Date:
|
|||
Q.1
|
A
|
Attempt any Five
|
10
|
1
|
Define
DBMS. What are the major components of DBMS?
|
||
2
|
Distinguish
between physical and logical data independence.
|
||
3
|
What
are the responsibilities of a DBA?
|
||
4
|
Explain
Weak and Strong entity set with example.
|
||
5
|
Explain
aggregation operation of E-R Diagram.
|
||
6
|
Explain
the rollback and commit command.
|
||
Q.2
|
A
|
Attempt any Two
|
10
|
1
|
Explain
database system 3 tier architecture with clear diagram in detail.
|
||
2
|
Explain
following relational algebra operation.
i)Natural
join operation ii)Selection and Projection operation
|
||
3
|
Draw
E-R Diagram for supplier who supplies parts. The parts are used in different
projects. Explain the mapping cardinality used. Assume suitable attributes.
|
||
Q.2
|
A
|
Attempt any Two
|
10
|
1
|
What
is constraint in database? Explain types of constraints with suitable example.
|
||
2
|
Consider
following schema and write SQL for given statements.
1.student(rollno,name,branch)
2.exam(
rollno,subject_code,obtained_marks,paper_code
3.papers(paper_code,paper_satter_name,university)
A.
Display name of students who got first class in subject.
B.
Display name of all students with their total mark.
C.
Display list number of student in each university.
D.
Display list of student who has not given any exam.
|
||
3
|
What
is view? Explain the syntax of view in SQL with example.
|