2021-2022 StudyChaCha

#1
May 4th, 2014, 11:43 AM
 Unregistered Guest
IETE ALCCS Database Management Systems past Papers

Any buddy, please provide me the IETE ALCCS Database Management Systems Exam Previous Years Question Papers………..

#2
May 4th, 2014, 02:23 PM
 Super Moderator Join Date: Dec 2011
Re: IETE ALCCS Database Management Systems past Papers

As per your request here I am sharing the IETE ALCCS Database Management Systems Exam Previous Years Question Paper:

Q.4 Consider the following relational database schema
SUPPLIER(SupplierNo, SupplierName, SupplierCity)
PART(PartNo, PartName, Weight, Quantity, Color)
SUPPLY(SupplierNo, PartNo, Quantity)
a. Give an SQL DDL definition of the above schema. (3)
b. Express the following queries in SQL:
(i) Find the names of parts which are supplied by more than one supplier.
(ii) Find the name of suppliers who have supplied all the red colored parts.
(iii) Find the names of supplier who has supplied blue parts more than average
number of the blue parts supplied by the supplier in the same city.
(iv) Find the names of supplier who supply atleast two parts.
(v) Delete Suppliers who have supplied no parts. (15)
Q.5 a. State 3NF and BCNF. Compare 3NF and BCNF with respect to lossless join
decompositions and dependency preservation with the help of an example. (5)
b. Consider the relation schema R(P, Q, R, S, T) and the Functional Dependencies
S R , R PQ ® ® and T S® holds on R. Decompose the relation R, if necessary,
into collections of relations that are in BCNF. (4)
c. Suppose that we decompose the schema R={P, Q, R, S, T} into R1={P, Q, R} and
R2={P, S, T}. Verify whether this decomposition is Lossless or Lossy if the
Functional Dependencies S Q , T RS , QR P ® ® ® and P T® holds. Also verify
whether the decomposition is dependency preserving.

__________________
#3
February 14th, 2015, 11:46 AM
 Super Moderator Join Date: Nov 2011
Re: IETE ALCCS Database Management Systems past Papers

As you wan to get IETE ALCCS Database Management Systems past Paper so here I am giving you some questions of that paper:

Q.1
a. What is DBMS? What are the advantages and disadvantages offered by such
systems as compared to file processing systems? Explain.

b. Explain the various levels of abstraction in a DBMS with the help of a diagram.
Why do we need mappings between different schema levels?

c. Differentiate between DBMS and RDBMS.

d. Explain the distinctions among the terms primary key, candidate key, and
superkey. Give suitable examples.

e. (i) Define with examples, the Relation and Relation Schema

(ii) Explain general syntax of SELECT command.

f. What are the properties of a transaction that are enforced by the concurrency
control and recovery methods of the DBMS?

IETE ALCCS Database Management Systems Question Paper

__________________

Message:
Options

All times are GMT +6.5. The time now is 05:22 AM.

 -- Default Style -- Default vBulletin -- Lightweight MBA Discussion - Job Discussion - Contact Us - StudyChaCha - Blog Archives - Forum Archive - Partners : Management Forum | HealthChaCha | VidhyaClinic | Travel ChaCha Top