[go: up one dir, main page]
Scribd
Upload
30 views1 page

DBMS Assignment 1 2023

This document outlines the assignment for the Database Management System course at Ganpat University, detailing various questions related to database concepts, data models, and SQL queries. It includes instructions on the course outcomes and Bloom's taxonomy levels for each question. The submission deadline is set for October 5, 2023, with no late submissions accepted.

Uploaded by

vasuviroja101
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
30 views1 page

DBMS Assignment 1 2023

This document outlines the assignment for the Database Management System course at Ganpat University, detailing various questions related to database concepts, data models, and SQL queries. It includes instructions on the course outcomes and Bloom's taxonomy levels for each question. The submission deadline is set for October 5, 2023, with no late submissions accepted.

Uploaded by

vasuviroja101
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

GANPAT UNIVERSITY

U.V.PATEL COLLEGE OF ENGINEERING


B Tech Semester III CE/IT/CE-AI
2CEIT303: Database Management System
Assignment-1
Instructions -
The right-most text indicates the Course Outcomes (CO) Numbers, followed by Bloom’s taxonomy level of the
question, R: Remembering, U: Understanding, A: Applying, N: Analyzing, E: Evaluating, C: Creating.

SR. NO. QUESTIONS Mapped CO & Bloom’s


Taxonomy
1 Define (i) Database (ii) DBMS 1-U

2 Compare and Contrast file Systems with database systems. 1-A

3 Define Data Abstraction and discuss levels of Abstraction. 1-U

5 Discuss about different types of Data models. 1-U

6 Explain different types of database users and write the functions of DBA. 1-U

7 Illustrate use of various DDL & DML Commands. 1-A

8 Illustrate use of SELECT, PROJECT, UNION operations in Relational 1-R


algebra with an example.
9 Illustrate use of RENAME, DIVISION operations Relational algebra with an 1-R
example.
10 Define Join. Explain different types of joins with suitable example. 1-U

11 Consider the following relational schema: 1-A


passenger ( pid, pname, pgender, pcity)
agency ( aid, aname, acity)
flight (fid, fdate, time, src, dest)
booking (pid, aid, fid, fdate)

Write the following queries in relational algebra.


(a) Get the complete details of all flights to New Delhi.
(b) Get the details about all flights from Chennai to New Delhi.
(c) Find the passenger names for passengers who have bookings on at least
one flight.
(d) Find the passenger names for those who do not have any bookings in any
flights. (use minus)
(e) Rename the table booking to confirmed.
12 Consider the following Tables: 3-A
Branch (Branch_Name, Branch_City, Assets)
Account (Account_no, Branch_Name, Balance, Customer_Name)

Write the following queries in SQL


(a) To find the following expression (2^3)+(3*6-2).
(b) To find All Customer’s name and Balance having account in Branch B1.
(c) To update the Balance = 12000 and Branch_Name=’B2’ for Account_no
1002.
(d) A an SQL query to find all Names with starting character ‘H’ or second
last character ‘a’.
13 Define and discuss the various types of keys. 4-U

Submission Deadline: 05/10/2023


Note: No submission will be accepted after deadline.

You might also like