Scribd
Upload
23 views1 page

Dbms Assignment 1

The document outlines an assignment on Database Management Systems (DBMS), covering topics such as the purpose and advantages of DBMS, data views, data models, and the three-schema architecture. It also includes tasks related to E/R diagrams, relational algebra operations, Tuple and Domain Relational Calculus, and SQL operations. The assignment is to be submitted by 10/02/2025 on A4 size white paper.

Uploaded by

ramesh
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
23 views1 page

Dbms Assignment 1

The document outlines an assignment on Database Management Systems (DBMS), covering topics such as the purpose and advantages of DBMS, data views, data models, and the three-schema architecture. It also includes tasks related to E/R diagrams, relational algebra operations, Tuple and Domain Relational Calculus, and SQL operations. The assignment is to be submitted by 10/02/2025 on A4 size white paper.

Uploaded by

ramesh
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

DBMS ASSIGNMENT-1

1. What is the purpose of a Database Management System (DBMS)? Discuss the main advantages of
using a DBMS over a traditional file system.
2. Explain the concept of data views in a DBMS. How do different users of a database (e.g., end-users,
DBAs, developers) interact with data using views?
3. What is a data model? Explain the hierarchical, network, and relational data models
4. Describe the three-schema architecture of a DBMS. What are the roles of the internal, conceptual, and
external schemas?
5. Discuss the major components of a DBMS and explain how each component contributes to the
functioning of the system.
6. Provide examples of common E/R diagram symbols and explain their meaning. Create an E/R diagram
for a simple "Library" database involving entities like "Book," "Author," and "Borrower."
7. Explain the operations of selection and projection in relational algebra. Provide an example of each
operation on a database table.
8. Discuss the different set operations in relational algebra (union, intersection, and difference). Provide
examples illustrating each operation using sample tables.
9. Describe the various types of joins in relational algebra (natural join, theta join, equi join, outer join).
Provide examples of each using sample relations.
10. Define Tuple Relational Calculus (TRC). How does it differ from relational algebra? Provide an
example query using TRC to retrieve data from a database.
11. Explain Domain Relational Calculus (DRC). How does it differ from Tuple Relational Calculus?
Write an example query in DRC to fetch specific attributes from a database.
12. Explain the following SQL operations: CREATE DATABASE, DROP DATABASE, CREATE
TABLE, DROP TABLE, INSERT, UPDATE, and DELETE. Provide SQL queries for each operation.

NOTE:
Submit the assignment on 10/02/2025
Write it in A4 size white paper

You might also like