Nalanda Open University 2009 B.Com Computer Applications Final , SET-III Bachelor of Computer Application, Part-I -XIV {CS-67 P (RDBMS) } - Question Paper
Final Examination, 2009 SET-III Bachelor of Computer Application, Part-I Paper-XIV {CS-67 P (RDBMS) }
Nalanda Open University
Final Examination, 2009
SET-III
Bachelor of Computer Application, Part-I Paper-XIV {CS-67 P (RDBMS) }
Time : 2.00 Hrs. Full Marks : 75
There are 2 questions in this paper. Answer both the questions.
They carry 50 marks. The rest 25 marks are for vive-voice.
1. An ABC company keeps the records for its employees, working on different project in the company. An employee can work on more than one project and more than one employees can work on the same project.
(a) Design & implement the suitable table/ relations to keep the records of the employees of the company. Include keys and constraints in your implementation.
(b) Enter at least 5 meaningful records in the table/ relation.
(c) Design 5 suitable queries on the relation.
Make suitable assumptions, if any.
Final Examination, 2009
SET-IV
Bachelor of Computer Application, Part-II Paper-XIV {CS-67 P (RDBMS) }
Time : 2.00 Hrs. Full Marks : 75
There are 2 questions in this paper. Answer both the questions.
They carry 50 marks. The rest 25 marks are for vive-voice.
1. Design table/ relation for a Library Information System. The Library Information System maintains the following information:
i. The list of registered members.
ii. List of books, which are categorised, either authorwise or topicwise.
iii. List of books which have been ordered for purchase.
iv. Details of book which have been issued or returned.
(a) Enter at least 5 meaningful records in each relation. Include keys and constraints in your implementation.
(b) Design and implement at least five queries.
Make suitable assumptions, if any.
|
Attachment: |
| Earning: Approval pending. |
