Scribd
Upload
15 views1 page

Advantages of ER Model in DBMS

This document outlines the questions for a Database Management Systems exam for a B.Sc degree. It includes 5 short answer questions worth 5 marks each from various DBMS topics like the drawbacks of file processing systems, the entity-relationship model, mapping cardinalities and Codd's rules. It also includes 5 long answer questions worth 10 marks each, covering additional topics such as the advantages of DBMS, ER modeling concepts like specialization and generalization, relational algebra vs tuple relational calculus, SQL commands and PL/SQL blocks. Students must answer any 5 short questions and all 5 long questions for a total of 75 marks.

Uploaded by

gdayanandam
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views1 page

Advantages of ER Model in DBMS

This document outlines the questions for a Database Management Systems exam for a B.Sc degree. It includes 5 short answer questions worth 5 marks each from various DBMS topics like the drawbacks of file processing systems, the entity-relationship model, mapping cardinalities and Codd's rules. It also includes 5 long answer questions worth 10 marks each, covering additional topics such as the advantages of DBMS, ER modeling concepts like specialization and generalization, relational algebra vs tuple relational calculus, SQL commands and PL/SQL blocks. Students must answer any 5 short questions and all 5 long questions for a total of 75 marks.

Uploaded by

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

Govt.

College for Men(A):: Kadapa


[Link] DEGREE EXAMINATION
Database Management System
( B.A, [Link] & [Link])
Time: 3 Hrs [Link]

I. Answer any FIVE questions 5x5=25

1. Explain the drawbacks of File processing systems?

2. Explain the advantages of DBMS?

3. Explain about Entity – Relation model?

4. Explain mapping Cardinalities with Examples?

5. Write and explain CODD’S rules?

6. Relational Alzebra & Tuple relational Calculus: differentiate

7. Write about SQL commands briefly?

8. Explain about triggeres with example?

II. Answer ALL questions 5x10=50

11. Advantages of DBMS?


[Or]
12. Functions of DBA?

[Link] about ER model?


[Or]
[Link] a) Specialisation b) Generalisation c) Aggregation.

[Link] a) Tuple relational Calculus b) Domain Relational Calculus


[Or]
[Link] QBE with examples?

[Link] any Five SQL commands with example?


[Or]
[Link] any 5 of a)Relational set operators b) Aggregate functions?

19. Explain the structure of PLSQL block structure with syntax?


[Or]
[Link] of cursors?

You might also like