DR. BABASAHEB AMBEDKAR TECHNOLOGICAL UNIVERSITY, LONERE
Mid Semester Examination – Oct 2019
Course: B. Tech in Computer Science and Engineering
--- Content provided by FirstRanker.com ---
Subject Name: Database Systems
Max Marks: 20
Date: 23-09-2019
Sem: V
Subject Code: BTCOC501
--- Content provided by FirstRanker.com ---
Duration: 1 Hr.
Instructions to the Students:
- Attempt all questions as per the instructions.
- Assume suitable data wherever necessary.
- Draw necessary diagram.
--- Content provided by FirstRanker.com ---
Q. 1
- For select operation the __________ appear in the subscript and the __________ argument appears in the parenthesis after the sigma.
a) Predicates, relation b) Relation, Predicates c) Operation, Predicates d) Relation, Operation (Level/CO) Marks 6 - The number of entities to which another entity can be associated via a relationship set is expressed as:
--- Content provided by FirstRanker.com ---
a) Entity b) Cardinality c) Schema d) Attributes - Using Relational Algebra the query that finds customers, who have a balance of over 1000 is
a) Customer_name(s balance >1000(Deposit)) b) s Customer_name(II balance >1000(Deposit))
c) II Customer_name(s balance >1000(Borrow)) d) s Customer_name(II balance >1000(Borrow)) - Process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as
--- Content provided by FirstRanker.com ---
a) normalization of data b) denomination of data c) isolation of data d) de-normalization of data - 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 - Data independence means :
a) Data is defined separately and not included in programs.--- Content provided by FirstRanker.com ---
b) Programs are not dependent on the physical attributes of data.
c) Programs are not dependent on the logical attributes of data
d) Both (b) and (c)
Q.1
(A)
--- Content provided by FirstRanker.com ---
Solve Any Two of the following.
- Explain the concept of generalization and specialization with example. 3
- FirstRanker.com Illustrate with example the use of aggregate operators supported by SQL. 2
- Discuss the concept of normalizations and explain its types.
--- Content provided by FirstRanker.com ---
Q.3 Solve Any One of the following.
A)
Consider the following schema, write relational algebra queries for the following
Suppliers (sid, sname, address)
Parts (pid, pname, color)
--- Content provided by FirstRanker.com ---
Catalog (sid, pid, cost)i) Find the sids of suppliers who supply every part.
ii) Find the name of suppliers who supply some red parts.
iii) Find the IDs of suppliers who supply only red parts.
iv) Find the sids of suppliers who supply some red part or are at 221 Park street.
--- Content provided by FirstRanker.com ---
(B)
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 department.
Firstranker's choice
*** End ***
--- Content provided by FirstRanker.com ---
This download link is referred from the post: DBATU B-Tech Last 10 Years 2010-2020 Previous Question Papers || Dr. Babasaheb Ambedkar Technological University