Scribd
Upload
26 views2 pages

DBMS Assignment 1

This document outlines the assignment for the Data Base Management System course for the academic year 2024-25, specifically for the IV semester. It includes a list of questions related to relational database concepts, entity-relationship diagrams, SQL operations, and DBMS characteristics, along with their corresponding course outcomes and Bloom's taxonomy levels. The assignment aims to assess students' understanding and application of various database management principles.

Uploaded by

nithingowda0718
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
26 views2 pages

DBMS Assignment 1

This document outlines the assignment for the Data Base Management System course for the academic year 2024-25, specifically for the IV semester. It includes a list of questions related to relational database concepts, entity-relationship diagrams, SQL operations, and DBMS characteristics, along with their corresponding course outcomes and Bloom's taxonomy levels. The assignment aims to assess students' understanding and application of various database management principles.

Uploaded by

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

DEPARTMENT OF AI&DS

Academic year 2024-25


EVEN SEMESTER
ASSIGNMENT – 1

SEMISTER: IV SEC:AI&DS Subject code: BCS403 Subject: Data Base


Management System
Assignment Issue date:4/4/2025
COURSE OUTCOME
At the end of the course, the student will be able to:
● Describe the basic elements of a relational database management system
● Design entity relationship for the given scenario.
● Apply various Structured Query Language (SQL) statements for database
manipulation.
● Analyse various normalization forms for the given application.
● Develop database applications for the given real-world problem.
● Understand the concepts related to NoSQL databases.

Ques.No Questions CO’s Blooms


Level
Module 1

1. Describe the Three-schema architecture. Why do we need CO1 L2


mapping among schema levels?
2. Draw an ER diagram for an COMPANY database with CO3 L3
employee, department, project as strong entities and dependent
as weak entity, Specify the constraints, relationships and ratios
in the ER diagram.
3. Define the following terms with example for each using ER CO3 L2
notation, Entity, attribute, composite attribute, multivalued
attribute, Participation role.
4. Explain all the ER Diagram Notation CO3 L2

5. Explain the Four Relational Model Constraints CO2 L2

6. What are the advantages of using DBMS? Explain CO1 L2

7. Describe the characteristics of DBMS CO1 L2

8. Explain briefly about Update, Delete and Insertion operation in CO2 L2


Relational model schema and also explain Relational Model
Constraints rules violation with example
9. Discuss the E.R to Relational mapping algorithm with example CO3 L3
for each step.
10 Define the Following Terms CO1 L2
a. Attributes b. Foreign Key c. Super Key d. Primary Key
e. Data Model f. Weak Entity g. Meta Data
11. Briefly explain Components of DBMS system with a neat CO1 L2
diagram.
12 Explain Briefly about DBMS Languages and Interfaces CO1 L2

13 Explain early database application using hierarchical and CO1 L2


network system.
14. Explain the types of end users with examples. CO1 L2

15 Explain Unary relational operations with examples. CO2 L2

16 Explain the following operations with an example CO2 L2


1)JOIN 2)SELECT 3) DIVISION 4) RENAME
17 Discuss the E.R to Relational mapping algorithm with example CO2 L3
for each step.
18 Demonstrate the concepts of Generalization & Specialization CO2 L2
with examples.
19 Explain the different types of attributes in ER model. CO1 L2

20 Explain the relational algebra operation for set theory with CO2 L2
examples.

You might also like