PCA25C03J · Cycle Test 1

Database Technology

Covers units 1 & 2: Introduction to Database concepts / Structured Query Language, DDL and DML commands

Part - A (4 * 5=20 Marks)

Answer Any 4 Questions

1.
Define: Entities, Attributes and Constraints
5mCO1BL1
2.
What are SQL Data Types? Give examples for each.
5mCO1BL1
3.
Describe the different Data Models.
5mCO1BL2
4.
Define and explain the different types of keys used in a relational database.
5mCO1BL2
5.
Discuss any five DDL commands in SQL with examples.
5mCO2BL2
6.
What are Data Manipulation Language (DML) commands? Give suitable examples.
5mCO2BL1

Answer all the Questions

7.a)
Draw an ER diagram for your own Database. Convert the ER diagram into relational schema and list appropriate constraints
15mCO1BL4
OR
b)
Explain the architecture of a DBMS with a neat diagram.
15mCO1BL2
8.a)
Explain Set Operations in SQL. Demonstrate the following with example tables and SQL queries: i) UNION ii)INTERSECT
iii) DIFFERENCE iv) CROSS PRODUCT
15mCO2BL2
OR
b)
Discuss in detail the difference and advantages of File system over DBMS
15mCO2BL2