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

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

Q.l
Q.2
(A)
(B)
.(C)
Q.3
~(A)__
.? ., V .. 'Parts?(bid;.'Pna?i.e,9?l?F)
(B)
DR. BABASAHEB AMBEDKAR TECHNOLOGICAL UNIVERSITY, LONERE
. Mid Semester Examination ? Oct 2019
Course: B. Tech in Computer Science and Engineering Sem: V
Subject NamezDatabase Systems ? ? Subject Code: BTCOCSOI
Max Marks220 X Date:? 23-09-2019 Duration:- 1 Hr.
O S~ I 0 '- 2 0? 3 ?
Instructions to the Students:
1. Attempt all questions as per the instructions.
2. Assume suitable data wherever necessary.
3. Draw necessary diagram.
(Level/CO) Marks
6
l. The attribute name could be structured as an attribute consisting of ?rst name, middle initial, and
last name. This type of attribute is called ?
a)Simp1e attribute b] Composite attribute c) Multivalued attribute d) Derived attribute
2. A super key is a set of one or more attributes that, taken collectively, allow us
, aytonidentify uniquely an entityjn the entity set b) to make the key most powerful for faster retrieval
c) to increase effe?ctix?r'ehess-of?dambaSe access , ? . d) none of the above , ,
3. The set of all possible values of data item is ealled :
a) Domain b) Attribute c) Tuples (1) None ?
4. A relation is in INF if it doesn't contain any _ ,
a) Determinants b] Repeating groups .c)Nu11valuesin primary key ?elds (1) Functional dependencies
5. The operation which only selects some of the columns from table and neglect the remaining columns is
classi?ed as . ' ' l , '
a) 0R operation h) AND operation c)TABLE operation (I) PROIECT operation
6; Using Relational Algebra the query that ?nds customers, who haVe a balance of over 1000 is
a) [lCustomer_name(o balance >1000(Dep.osit)) b) o Customer_name[l'l balance >1000(Deposit))
c) ['1 EnstomeLnameto balance >1000(Borrow)) d) o Customer_name(l'l balance >1000[Borrow))
k,
f
Solve Any Two of the following. ? ? 3 X
De?ne functional dependency? List?out and explain the Amlstrong?s inference rules of functional dependencies with
' suitable example.
What do you mean by a key? Explain the different types of keys in dbms ?
Illustrate, with suitable diagram the three level-schema architecture.Why do we need mapping between schema levels?
Solve Any One of the following. , ' 8
Consider the following schema, write relational algebra queries for the following
Suppliers(sid, sname, address) '
Catalog (Sid, pid; cost) ' ? -
a. Find the sids of suppliers who supply red part.
b. Find the name of suppliers who supply parts costing <150.
c) Find the IDs of suppliers who supply red or green parts.
. (1) Find the sids of suppliers who supply some red part or axe at 221 Park street.
Consider the following attribute and normalize the table upto 3NF.
r?np code I Dept code [mile 1? Course code I Coutes TitlLI
FDs mentioned for the above relation are :
- Emp__code 9 Dept_code
Emp__.code?) Mgr_code
Course_code -> Course_Title
*** End *iei: