Nalanda Open University 2009 B.Com Computer Applications Final , SEET-I Bachelor of Computer Application, Part-II -XIV {CS-67 P (RDBMS) } - Question Paper
Final Examination, 2009 SEET-I Bachelor of Computer Application, Part-II Paper-XIV {CS-67 P (RDBMS)}
Nalanda Open University
Final Examination, 2009
_|SET-I
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. Project evaluation is one of the important activities for BCA/ MCA students. The University maintains the following information about the projects:
i. The list of students and Project submitted by them.
ii. The list of evaluators.
iii. The allocation of student projects to evaluators.
iv. Keeping track of evaluated projects.
(a) Design and implement the normalized relations/ tables for the requirements listed above.
(b) Enter 5 sets of meaningful data in each of the relation/ table.
(c) Design and implement five suitable queries/ forms/ reports for the above.
SET-II
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. A bank offers International accounts for its customers. The bank allows international ATM withdrawal, electronics fund transfer, point of sale withdrawal and similar services. Bank charges a fee (different fee for different service) from the customers.
(a) Design and implement suitable tables/ relations to keep track of customers of the bank, services used by them and bank charges that they need to pay in a month. Please include keys, and constraints in your implementation.
(b) Enter about 5 sets of meaningful data in each of the table/ relation.
(c) Design and implement 5 suitable queries/ forms/ reports for the requirements as above.
Make suitable assumption, if any.
|
Attachment: |
| Earning: Approval pending. |
