Go Back   2021-2022 StudyChaCha > StudyChaCha Discussion Forum > General Topics

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

Any buddy, please provide me the IETE ALCCS Database Management Systems Exam Previous Years Question Papers………..
Reply With Quote
Other Discussions related to this topic
Thread
Download IETE ALCCS Computer Architecture Exam Paper
Download IETE ALCCS Data Structures Through C Exam Paper
Past year question papers of DOEACC B Level Course Operating Systems Exam
IETE ALCCS Computer Programming and problem solving through c exam paper
Cochin University B.Tech in CSE 6th Sem Database Management Systems Exam Papers
IGNOU, Advanced Diploma in IT, Data Relational Database Management Systems Exam Paper
DOEACC A Level Introduction to Database Management Systems Previous Years Question Pa
Past year question papers of IETE AMIETE-ET (Old Scheme) Computer Networks Exam
IETE ALCCS Computer Networks Exam Papers
JNTU B.Tech in Computer Science and Engineering-2nd Year Database Management Systems
BPUT-B.Tech 2nd Year- Relational Database Management Systems Exam Papers
IETE ALCCS Mobile Computing previous years question papers
IGNOU, Bachelors in Information Technology, Database Management Systems previous year
PTU MCA 4th Sem-Relational Database Management System –II Exam Papers
IGNOU Advanced Diploma in Information Technology-Advanced Database Management Systems
IETE ALCCS System Software Exam Download Paper
TNOU MCA 3rd Year Relational Database Management Systems Exam past Papers
IETE ALCCS Software Engineering Exam old Papers
M.Sc in IT 2nd sem Database Management Systems and Oracle previous year’s question pa
Basic Concepts of Database Management Systems (DBMS)






  #2  
Old May 4th, 2014, 02:23 PM
Super Moderator
 
Join Date: Dec 2011
Default 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.




__________________
Answered By StudyChaCha Member
Reply With Quote
  #3  
Old February 14th, 2015, 11:46 AM
Super Moderator
 
Join Date: Nov 2011
Default 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



__________________
Answered By StudyChaCha Member
Reply With Quote
Reply


Reply to this Question / Ask Another Question
Your Username: Click here to log in

Message:
Options



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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8