Mid Qpaper_DBMS_2017

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.