FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

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

This post was last modified on 21 January 2020

This download link is referred from the post: DBATU B-Tech Last 10 Years 2010-2020 Previous Question Papers || Dr. Babasaheb Ambedkar Technological University


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:

  1. Attempt all questions as per the instructions.
  2. Assume suitable data wherever necessary.
  3. Draw necessary diagram.
  4. --- Content provided by FirstRanker.com ---

Q. 1

FirstRanker.com

  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
  2. 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
  3. Using Relational Algebra the query that finds customers, who have a balance of over 1000 is
    a) Customer_name(σ balance >1000(Deposit)) b) σ Customer_name(II balance >1000(Deposit))
    c) II Customer_name(σ balance >1000(Borrow)) d) σ Customer_name(II balance >1000(Borrow))
  4. 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
  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 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 ---

FirstRanker.com

Solve Any Two of the following.

  1. Explain the concept of generalization and specialization with example. 3
  2. FirstRanker.com Illustrate with example the use of aggregate operators supported by SQL. 2
  3. Discuss the concept of normalizations and explain its types.
  4. --- 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