Scribd
Upload
77 views2 pages

Relational Database Management System: Vivekanandha College of Arts and Sciences For Women (Autonomous), Elayampalayam

This document contains two sample exam papers for a Relational Database Management Systems course. The first exam paper has three sections: Section A contains 5 short answer questions worth 2 marks each, Section B contains 1 question requiring a diagram explanation worth 5 marks, and Section C contains 1 long answer question worth 10 marks requiring discussion of components of the ER model. The second exam paper follows the same format but contains different questions on topics like the ER model, entity lists, attribute types, normalization, keys, functional dependencies, and Codd's rules.

Uploaded by

satisa123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
77 views2 pages

Relational Database Management System: Vivekanandha College of Arts and Sciences For Women (Autonomous), Elayampalayam

This document contains two sample exam papers for a Relational Database Management Systems course. The first exam paper has three sections: Section A contains 5 short answer questions worth 2 marks each, Section B contains 1 question requiring a diagram explanation worth 5 marks, and Section C contains 1 long answer question worth 10 marks requiring discussion of components of the ER model. The second exam paper follows the same format but contains different questions on topics like the ER model, entity lists, attribute types, normalization, keys, functional dependencies, and Codd's rules.

Uploaded by

satisa123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

14U4CAC07 /SET A

VIVEKANANDHA COLLEGE OF ARTS AND SCIENCES


FOR WOMEN (AUTONOMOUS), ELAYAMPALAYAM.
(For the candidates admitted from 2014-2015 onwards)
CIA TEST II – FEB 2018
BCA DEGREE EXAMINATION
IV Semester
DEPARTMENT OF COMPUTER APPLICATIONS

RELATIONAL DATABASE MANAGEMENT SYSTEM


Time: ONE Hour Maximum: 25 Marks
SECTION A (5 X 2 = 10 Marks)
Answer ANY FIVE Questions.

1. What is Entities?
2. Define E-R model.
3. What are the types of E-R Diagrams?
4. Define relationships?
5. Define RDBMS terminology.
6. What are the types of decomposition?
7. Write the abbreviation of the following. (a) BCNF , (b) FK

SECTION B (1 X 5 = 5 Marks)
Answer ALL Questions.

8. a) Explain E-R Diagram Conventions with neat diagram? (OR)


b) Explain about 1NF with example.
SECTION C (1 X 10 = 10 Marks)
Answer Any ONE Question.
9. Discuss with components of an E-R Model.
10. Explain about the pitfalls in relational database design.
14U4CAC07 /SET B

VIVEKANANDHA COLLEGE OF ARTS AND SCIENCES


FOR WOMEN (AUTONOMOUS), ELAYAMPALAYAM.
(For the candidates admitted from 2014-2015 onwards)
CIA TEST I – JAN 2018
BCA DEGREE EXAMINATION
IV Semester
DEPARTMENT OF COMPUTER APPLICATIONS

RELATIONAL DATABASE MANAGEMENT SYSTEM


Time: ONE Hour Maximum: 25 Marks
SECTION A (5 X 2 = 10 Marks)
Answer ANY FIVE Questions.
1. Define E-R model.
2. What is Entity List?
3. What are the types of attributes?
4. Define RDBMS terminology.
5. Define Normalization?
6. What are the keys available in RDBMS ?
7. Write the abbreviation of the following. (a) BCNF , (b) FK

SECTION B (1 X 5 = 5 Marks)
Answer ALL Questions.
8. a) What you mean by functional dependencies. Explain (OR)
b) Explain Integrity constraints?

SECTION C (1 X 10 = 10 Marks)
Answer Any ONE Question.
9. Explain the different concepts of relationship with neat diagrams?
10. Explain about Codd's rules.

You might also like