Scribd
Upload
58 views1 page

DBMS Assignment 1

This document is an assignment for the DBMS course at Dayananda Sagar Business Academy, consisting of three sections with questions of varying marks. Section A includes definitions and concepts related to DBMS, Section B focuses on applications and data independence, and Section C requires detailed explanations of DBMS advantages, architecture, and relationships. The assignment aims to assess students' understanding of database management systems and their components.

Uploaded by

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

DBMS Assignment 1

This document is an assignment for the DBMS course at Dayananda Sagar Business Academy, consisting of three sections with questions of varying marks. Section A includes definitions and concepts related to DBMS, Section B focuses on applications and data independence, and Section C requires detailed explanations of DBMS advantages, architecture, and relationships. The assignment aims to assess students' understanding of database management systems and their components.

Uploaded by

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

DAYANANDA SAGAR BUSINESS ACADEMY

DEPARTMENT OF BACHELORS IN COMPUTER APPLICATION


Subject : DBMS Subject code : BCA204T

ASSIGNMENT – 1
SECTION – A
Answer the following. Each question carries two marks :
1. Define : a) DBMS b) Data Model.
2. Define Data independence. Mention the types.
3. Differentiate centralized database architecture and client server database architecture.
4. What is an entity? Mention the types of entities.
5. Define RAID.
6. What are database anomalies ? Mention the types.
7. Explain different data types in SQL.
8. Define database. Give an example.
9. Write any two applications of DBMS.
10. Define schema.
11. Define instance.
12. What is multivalued attribute ? Give example.
13. Define track and sector.
14. Define functional dependency.
15. List DDL commands.
16. Define composite key.
17. What do you mean by generalisation and specialisation ?
18. Explain Domain and Tuple
19. Explain Commit and Rollback commands.
20. What is DBMS? Why do we need a DBMS?
21. Write down any two responsibilities of data base administrator.
22. Define referential integrity constraints with example.

SECTION – B

Answer any five questions. Each question carries three marks.


1. Explain applications of DBMS.
2. What is data independence? Explain briefly two types of data independence.
3. Explain buffering of blocks. '
4. Explain constraints in relational data model.
5. Explain the difference between logical and physical data independence.

SECTION – C

Answer any 5 of the following. Each question carries 5 marks :


1. Explain the advantages of DBMS.
2. Explain three schema architecture.
3. Define different types of keys.
4. Exptain different Hashing Techniques.
5. Draw an ER diagram for STUDENT DATABASE SYSTEM.
6. Explain three level DBMS architecture with neat diagram.
7. Explain different types of relationships in ER-datamodel.
8. Explain different people behind DBMS.
9. Explain one to one , one to many and many to many relationships with example.
10. Write an ER-Diagram of employee salary database and also mention type of association between
the entities.

You might also like