Download DBATU B.Tech 2019 Oct-Nov CSE 5th Sem Database Systems Question Paper

Download DBATU (Dr. Babasaheb Ambedkar Technological University) B Tech 2019 Oct-Nov (Bachelor of Technology) CSE 5th Sem Database Systems Question Paper

Q.2
(A)
t (B)
.(C) .
Q.3
f?) ?
(B)
L? DR. BABASAHEB AMBEDKAR TECHNOLOGICAL UNIVERSITY, LONE?RE
Mid Semester Examination ,? Oct 2019
Course: i3. Tech in Computer Science and Engineering Sem: V
Subject Name:Database Systems , ' Subject Code: BTCOCSOI
Max Marks:20 * Date:- 23-09-2019 Duration:- 1 Hr.
Instructions to the Students: .
1. Attempt all questions as per the instructions.
2. Assume suitable data wherever necessary.
3. Draw necessary diagram.
(LevelICO) Marks ,
6
1. For select operation the
parenthesis after the sigma.
31 Predicates. relation b) Relation. Predicates c) Operation, Predicates d) Relation. Operation
2. The number of entities to which another entity can be associated via a relationship set is expressed as:
a) Entity h) Cardinaiity c) Schema , d) Attributes
3. Using Relational Aigebra the query that ?nds customers, who have a baiance of over 1000 is '
a) ?Customer_name(o balance >1000(Deposit)) b) a Customer_name(?balance >1000(Deposit))
c) [I Customer_name(o balance >1000(Borrow)) d) a Customer_name(l'i bal'ance >1000(Borrow))
4. Process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is
classi?ed as ' ?
a) normalization of data b) denomination of data c) isolation of data d)de~normalization of data
5. The number of entities to which another entity can be associated via a relationship set is expressed as:
a) Entity . b) Cardinality c) Schema d) Attributes
6. Data independence means :
a) Data is de?ned separately and not included in programs.
b) Programs are not dependent on the physical attributes of data.
c) Programs are not dependent on the logical attributes of data
(1) Both (b) and (c)
appear in the subscript and the argument appears in the
Solve Any Two of the following. I , . 3 X 2
Explain?the?concept of generalization and specialization with example.
Illustrate with example the use of aggregate operators supported by SQL.
Discuss. the concept of normalizations and explain its types.
Solve Any One of the following. * I . e ? 8?
Consider the following schema, write relational algebra queries for the following
Suppliers (sid, s_name, address)
Parts (pid, pname, color)
Catalog (sid, pid, cost) ?
i) Find the sids of suppliers who supply every?part.
ii) Find the name of suppliers who supply sonic red parts,
A iii) Find the IDs of suppliers whosu?ppiy only red parts. .
iv) Find thesids of su?pliefs ?who supply some red part or are at 221 Park street. . *
Draw an ER diagram for small college database comprising the entity types DEPARTMENT,COURSE, STUDENT
and LECTURER. Each department has many lecturers , one of whom is head of department. A lecturer belongs to
only one department. Each department offers many different courses, each of which is taught by a single lecturer. A
, student may enrol for many courses offered by different depanment.
? *1?: End ***