Scribd
Upload
29 views1 page

Dbms Assignment 1

This document is an assignment for the BCA 5th Semester course on Introduction to DBMS at the Global Institute of Information Technology. It outlines course outcomes related to relational database management systems, including understanding data models, SQL queries, and transaction processing. The assignment includes a series of questions categorized by taxonomy levels aimed at assessing students' knowledge and understanding of database concepts.

Uploaded by

ayushmshra9999
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
29 views1 page

Dbms Assignment 1

This document is an assignment for the BCA 5th Semester course on Introduction to DBMS at the Global Institute of Information Technology. It outlines course outcomes related to relational database management systems, including understanding data models, SQL queries, and transaction processing. The assignment includes a series of questions categorized by taxonomy levels aimed at assessing students' knowledge and understanding of database concepts.

Uploaded by

ayushmshra9999
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

Global Institute of Information Technology

BCA – 5th Semester (year 2025)


Sub: Introduction to DBMS
Paper Code: BCA - 501
Assignment 1

Date of Giving Assignment: 09 Sept’ 2025


Date of Submission: 18 Sept’ 2025

Course Outcome:

CO1: Understand and explain the concept of basic elements of a relational database management system.
CO2: Identify the data models and design entity relationship and convert entity relationship diagrams into
RDBMS. Implement normalization algorithms using database design theory for different application.
CO3: Familiar with basic database storage structures and access techniques: file and page organizations,
indexing methods including B tree, and hashing.
CO4: Formulate SQL queries on the respect data into RDBMS and formulate SQL queries on the data.
CO5: Understand data base Design using EER to relational language.
CO6: Analyze and implement transaction processing, concurrency control and database recovery protocols
in databases.

S.No. Questions Level of Course


Taxonomy Outcome
1. Define data base management system. Remembering CO1

2. Define data model. Remembering CO1


3. Define attributes. Remembering CO2

4. Explain attributes with examples. Understanding CO2


5. Explain DDL and DML commands with example. Understanding CO2
6. Explain data independence with its type. Understanding CO1
7. Explain the primary key, super key and foreign key. Understanding CO2

8. Draw an E-R diagram for a small marketing company data- Creating CO2
base, assuming your own data requirement.
9. Explain referential integrity. Understanding CO2
10. Give example of a simple, composite attributes of an entity. Remembering CO2

11. List any five applications of DBMS. Remembering CO1


12. Write short note on strong and weak entity. Analyzing CO2

You might also like