Veer Narmad South Gujarat University 2010-1st Sem M.C.A Database Management Systems : (A.T.K.T) (External) , , - - Question Paper
M. C. A. (Sem. I) (ATKT) (External) Examination
April/May - 2010
Paper - 102 : Database Management Systems
RF-4793
Time : 3 Hours]
Instructions :
[Total Marks : 70
N Seat No.:
6silq<3i Puunkiufl [qaim SuwiA u* qsq <KH=fl. Fillup strictly the details of signs on your answer book.
Name of the Examination :
M. C. A. (Sem. 1) (ATKT) (External)
Name of the Subject:
102 : Database Management Systems
-Section No. (1,2......): Nil
Student's Signature
-Subject Code No.:
4 Attempt any two : 14
(a) Discuss security features of MS Access
(b) Explain 1st Normal Form
(c) Explain Entity-Relationship model with proper example.
5 (a) Consider following table and set of functional
dependencies holds on the table. Employee (Employee No, Employee Name, Designation, Date of birth, Branch Code, Branch name, Branch city, salary)
Functional dependencies:-
Employee No-> Employee name, Designation, Date of birth, salary.
Branch Code-> Branch Name, Branch City
Employee No-> Branch Code, Branch Name, Branch City
(i) Find candidate key(s) for table ... 2
(ii) State whether the relation is in 2NF or not? 4 Justify your answer ...
(b) Consider following table (Underlined attributes forms the candidate key).
Book Master ( Book Code, ISBN, Title, Publication)
Book Detail (Book ID, Book Code, Purchase Date)
(i) Write relational algebra expression for 4 followings ...
(a) List Book ID, Title and ISBN for all books.
(b) List titles for all books from Pearson publication.
(ii) Write SQL statements for followings ... 4
(a) List total number of books within library.
(b) Find Book Code for which maximum numbers of books have been purchased in the year 2009.
RF-4793] 2 [ 500 ]
Attachment: |
Earning: Approval pending. |