KEMBAR78
DBMS Assignment1 | PDF
Scribd
Upload
17 views1 page

DBMS Assignment1

The document outlines an assignment with ten questions related to Database Management Systems (DBMS). It covers topics such as the need for DBMS, advantages and disadvantages, schema architecture, ER-Diagrams, SQL statements, and key differences among various database concepts. Each question is assigned specific marks and categorized by course outcomes and performance indicators.

Uploaded by

SACHIN VERMA
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
17 views1 page

DBMS Assignment1

The document outlines an assignment with ten questions related to Database Management Systems (DBMS). It covers topics such as the need for DBMS, advantages and disadvantages, schema architecture, ER-Diagrams, SQL statements, and key differences among various database concepts. Each question is assigned specific marks and categorized by course outcomes and performance indicators.

Uploaded by

SACHIN VERMA
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/ 1

Assignment No.

# 01

Q. No. QUESTION Marks CO PI BL


1 Describe the need of Database Management System with 10 1 3.4.2 K2
suitable example of daily life.
2 Enlist 3 major Advantages and Disadvantages of DBMS. 10 1 3.2.1 K1
3 Discuss the three schema architecture of DBMS and can it 10 2 3.1.6 K2
be converted into two schema architecture, how?
4 Justify ER-Diagram is a visual representation of data. How .10 2 3.4.1 K4
does it relate the data to each other?
5 Given the relation schema R = (A,B,C) and S = (D,E,F) and 10 3 3.4.1 K3
relations r(R) and s(S). Give equivalent SQL statements for
each of the following expressions:
i) πA (r) ii) σB =17 (r)
iii) rXs iv) πA,F(σC=D(rXs))

6 What is the difference among "dropping a table", "truncating 10 3 3.4.1 K3


a table" and "deleting all records" from a table?
7 What's the difference between a primary key, unique key, 10 4 4.1.2 K3
null key and foreign key?
8 Differentiate between the 2-Tier & 3-Tier Architecture. 10 4 3.1.1 K3

9 What are aggregate functions? And list the aggregate 10 5 3.4.1 K2


functions supported by SQL?
10 What is view in SQL? How is it defined? 10 5 3.4.1 K2

You might also like