LAB EXAM 2 QUESTIONS : (Exam will taken in next DBMS lab as per timetable)
1 Define Anomaly. List its type and explain all with example.
2 Explain Armstrong axioms or Inference Rules.
3 What is decomposition. Explain types of decomposition with example.
LAB EXAM 1 QUESTIONS : (Exam will taken in next DBMS lab as per timetable)
1 List the relational algebra operators. List the type of joins in relational algebra. Explain all joins with example.
2 Explain set operation with example.
3 Explain the term ‘Generalization’, ‘Specialization’ and ‘Aggregation’ with example.
4 Define with examples. A. Weak Entity Set B. Strong Entity Set C. Total Participation D. Partial Participation E. Single Valued Attribute F. Multivalued Attribute G. Derived Attribute I. Composite Attribute.
PBL ACTIVITY :
ACTIVITY 1 (ER DIAGRAMS): DOWNLOAD STUDENT WISE ER DIAGRAM LIST
DBMS SYLABUS : DOWNLOAD
DBMS PRACTICAL MANUAL (1 to 5) : DOWNLOAD
DBMS ASSIGNMENTS
ASSIGNMENT 1: DOWNLOAD
ASSIGNMENT 2: DOWNLOAD
ASSIGNMENT 3: DOWNLOAD
ASSIGNMENT 4: DOWNLOAD
ASSIGNMENT 5: DOWNLOAD
DBMS MATERIAL:
1 UNIT 2 : DOWNLOAD
2 UNIT 4 : DOWNLOAD
3 UNIT 5 : DOWNLOAD
DBMS PRACTICALS:
1 PRACTICAL 1 : DOWNLOAD
2 PRACTICAL 2 : DOWNLOAD
3 PRACTICAL 3 : DOWNLOAD
4 PRACTICAL 4 : DOWNLOAD
5 PRACTICAL 5 : DOWNLOAD
6 PRACTICAL 6 : DOWNLOAD
7 PRACTICAL 7 : DOWNLOAD
8 PRACTICAL 8 : DOWNLOAD
9 PRACTICAL 9 : DOWNLOAD
10 PRACTICAL 10 : DOWNLOAD
DBMS GTU PAPERS:
1 GTU PAPER 30-11-2019 : DOWNLOAD
2 GTU PAPER 29-10-2020 : DOWNLOAD
3 GTU PAPER 04-03-2021 : DOWNLOAD
4 GTU PAPER 11-09-2021 : DOWNLOAD
5 GTU PAPER 21-02-2022 : DOWNLOAD
6 GTU PAPER 24-02-2023 : DOWNLOAD
7 GTU PAPER 28-07-2023 : DOWNLOAD
8 GTU PAPER 18-01-2024 : DOWNLOAD
9 GTU PAPER 29-06-2024 : DOWNLOAD
10 GTU PAPER 29-11-2024 : DOWNLOAD
11 GTU PAPER 31-05-2025 : DOWNLOAD
12 GTU PAPER 15-12-2025 : DOWNLOAD
13 GTU PAPER 19-12-2025 : DOWNLOAD
14 GTU PAPER 24-06-2026 : DOWNLOAD