VPMP Polytechnic, Gandhinagar
Department of Computer Engineering – Semester 3
RDBMS (4330702) - ASSIGNMENTS
Assignment 1
Unit – I (Introduction to Database System and SQL commands)
1. Define following terms.
a. Data f. Files
b. Information g. Records
c. Database h. Schema
d. Database system i. Sub schema
e. Metadata j. Instance
2. Explain Data dictionary and its components.
3. List out DDL commands and Explain CREATE and ALTER command with
an example.
4. List out DML commands and Explain UPDATE and DELETE command
with an example.
5. Explain SELECT command with suitable examples.
6. Differentiate Delete and Truncate command.
7. Difference between Commit v/s Rollback.
8. Explain Save point concept.
9. Write a short note on DCL (data control language).
10. Explain following Data Base Objects.
a. Synonyms.
b. Sequence.
c. View
d. Index.
VPMP Polytechnic, Gandhinagar
Department of Computer Engineering – Semester 3
RDBMS (4330702) - ASSIGNMENTS
Assignment 2
Unit – II (SQL In built functions and Joins)
1. List out Operators. Explain Arithmetic operator in detail.
2. Write a short note on Logical operator.
3. Explain Date functions.
4. Explain Numeric functions.
5. Explain Character functions.
6. Explain Conversion function.
7. Explain Group functions.
8. Explain Group by, Having and Order by clause in detail.
9. Explain Set operators in detail.
10. Explain Equi-join, Non-Equi Join and Self-join with an example.
11.Write a short note on Outer Join.
12. Explain Concept of Sub-Query.
13. Explain Multiple and Correlated sub query with an example.
VPMP Polytechnic, Gandhinagar
Department of Computer Engineering – Semester 3
RDBMS (4330702) - ASSIGNMENTS
Assignment 3
Unit – III (SQL Constraints)
1. What is constraint? Explain types of constraints.
2. Explain Not null and Check constraint in detail.
3. Explain Check and Primary Key constraint with an example.
4. Write a short note on Referential Integrity constraint.
5. Explain On Delete Cascade option with example.
VPMP Polytechnic, Gandhinagar
Department of Computer Engineering – Semester 3
RDBMS (4330702) - ASSIGNMENTS
ASSIGNMENT: 4
Unit– IV PL/ SQL and Triggers
1. What is PL/SQL? Explain the Generic Block of PL/SQL. Give the
advantages of PL/SQL.
2. Give the Difference of SQL and PL/SQL
3. Explain anchored data type with Example.
4. Explain various steps to manage Explicit Cursors.
5. Explain Exception OR Error Handling with Example.
6. Explain PRAGMA EXCEPTION_INIT(Numbered Exception) with
Example.
7. Write a short note on stored Procedure.
8. Explain Function with Example.
9. What is Trigger? Explain Types of Trigger.
10.Explain Trigger with Example.
VPMP Polytechnic, Gandhinagar
Department of Computer Engineering – Semester 3
RDBMS (4330702) - ASSIGNMENTS
ASSIGNMENT: 5
Unit– V Normalization
1. What is normalization explain in brief?
2. Explain First Normal Form with Example.
3. Explain Second Normal Form with Example.
4. Explain Third Normal Form with Example.
5. Explain Advantages and Disadvantages of Normalization.
