Scribd
Upload
10 views1 page

Dbms Assignment Questions

The document outlines assignment questions for a Database Management System course in the Faculty of Engineering and Technology, specifically for the Department of Computer Science and Design. It includes questions on the advantages of DBMS, definitions of key terms, ER diagrams, and relational algebra operations. The assignment is structured into two modules covering various concepts and operations related to databases.

Uploaded by

sonajipawar9497
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
10 views1 page

Dbms Assignment Questions

The document outlines assignment questions for a Database Management System course in the Faculty of Engineering and Technology, specifically for the Department of Computer Science and Design. It includes questions on the advantages of DBMS, definitions of key terms, ER diagrams, and relational algebra operations. The assignment is structured into two modules covering various concepts and operations related to databases.

Uploaded by

sonajipawar9497
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
You are on page 1/ 1

FACULTY OF ENGINEERING AND TECHNOLOGY (CO-ED)

DEPARTMENT OF COMPUTER SCIENCE AND DESIGN

SUBJECT NAME: DATABASE MANAGEMENT SYSTEM SEM: IV


SUBJECT CODE: 22CS43 ACADEMIC YEAR: 2024-25

ASSIGNMENT QUESTIONS

MODULE 1
1) a) Explain the Advantages of using the DBMS approach
b) Define the following terms with an example
a. Database Schema f. Entity
b. Weak Entity Type g. Attributes
c. Schema Diagram h. Relationship
d. Instances I. Entity Type
e. Metadata k. Entity Set

2) a) Write Notations of ER diagram. Create an ER diagram representing an airline


database.
b) Explain the main characteristics of the database approach and how it differs from
traditional file system.
.

MODULE 2
3) a) Describe the steps of an algorithm for ER to Relational Mapping
b) Define the terms - Entity integrity, referential integrity and foreign key with
examples.

4) a) Write the Relational algebra operations for the given queries


i. Find the name of all the employees who work on all the project controlled by
department number = 3
ii. Retrieve the name & salary of all employees who work for the ‘Research’
department.
iii. List the names of managers who have at least one dependent.
b) Explain Insert ,delete and Update operations constraint violations with examples.

You might also like