Tuesday, June 30, 2015

Annamalai University 240 - Relational Database Management Systems BCA 2014 Question Paper

Sponsored Links

Annamalai University Question Papers Collection : Old Previous Years / Model and Sample Question Papers of various years.
B.C.A. DEGREE EXAMINATION, December 2014
Second Year
240 - Relational Database Management systems Question Paper Dec 2014
Time: 3 hours
Maximum :100 Marks

Annamalai University
B.Sc. DEGREE EXAMINATION December 2014
(COMPUTER SCIENCE)
(SECOND YEAR)
(PART-III)
240. RELATIONAL DATABASE MANAGEMENT SYSTEMS
(Common with B.C.A and Double Degree)
Time: Three hours Maximum: 100 marks

SECTION – A
Answer any EIGHT questions (8× 5 = 40)

1. Explain the purpose of database system.
2. Discuss the importance of foreign key.
3. What is generalization in E-R diagram?
4. Explain about database schemas.
5. Give the syntax of five numeric functions in SQL with example.
6. What is QBE?
7. What is functional dependency? Give an example.
8. Discuss about Multivalued dependency.
9. What is anonymous Block in PL/SQL?
10. Write the syntax of EXIT WHEN statement in PL/SQL.

SECTION – B
Answer any THREE questions (3× 20 = 60)

11. Discuss the basic concepts entity sets and attributes of Equity Relationship Model.
12. Illustrate the concepts in Relational Algebra.
13. Briefly discuss about any five database commands.
14. Explain about BCNF and 4NF with an example for each.
15. Summarize about Data Manipulation PL/SQL editor.

Duraimani

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as www.IndianUniversityQuestionPapers.com . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!