Scribd
Upload
2 views2 pages

Structured Database Task

Students of TY A are required to submit assignments covering various database topics, including disadvantages of file processing systems, responsibilities of DBAs, and relational algebra operations. Specific roll numbers are assigned to different tasks, with instructions to write answers on assignment pages. Additional tasks include analyzing GATE question papers and identifying relevant questions from the SDB course.

Uploaded by

Vaishnavi Shinde
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
2 views2 pages

Structured Database Task

Students of TY A are required to submit assignments covering various database topics, including disadvantages of file processing systems, responsibilities of DBAs, and relational algebra operations. Specific roll numbers are assigned to different tasks, with instructions to write answers on assignment pages. Additional tasks include analyzing GATE question papers and identifying relevant questions from the SDB course.

Uploaded by

Vaishnavi Shinde
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

Structured Database

All students of TY A are hereby informed to submit the assigned task for you while
submission.

Roll Numbers Assigned Task


Write the answers of following questions on assignment pages and
submit it.
1, 20, 63, 66, 1. Explain disadvantages of file processing system in brief.
2. List and explain different users of database system.
76, 87, 94, 95,
3. List and Explain responsibilities of DBA.
99, 100, 104,
4. Explain with diagrams extended E-R feature- Aggregation.
109, 115, 116, 5. Define relational algebra? State and explain fundamental
operations of relational algebra with proper example.
118, 120, 127,
6. Describe Natural join and Outer Join in relational algebra with an
130, 137, 138,
example for each.
140, 141 7. Explain Set operations and Aggregate functions in relational
algebra with an example for each.
8. Illustrate SQL DDL commands with syntax and suitable example.
9. Illustrate SQL DML commands with syntax and suitable example.
10. What is procedural SQL? What are its advantages? Give
difference between stored procedure and function in PL/SQL.

Write the answers of following questions on assignment pages and


7, 25, 34, 38,
submit it.
41, 44, 46,
1. What is decomposition? Describe lossy and lossless
50,51, 53, 55,
decomposition with proper example.
60, 64, 69, 72,
2. Determine the set of candidate keys for following sample relation.
74, 75, 77, 84,
Let R (A, B, C, D, E) is a relation with following functional
86, 89, 96,
dependencies-
102, 105, 110,
(A → BC, CD → E, B → D, E → A)
111, 114, 117,
3. Define normalization? Explain 1NF and 2NF with example.
121, 123, 125,
4. Explain BCNF in detail with example.
126, 129, 132,
5. Explain 3NF in detail with example.
134, 135, 136,
139
Roll Numbers Assigned Task

2, 3, 4, 5, 6, 8,
1. Take GATE Question papers of year 2021, 2022. 2023.
9, 10, 11, 12,
2. Identify questions of SDB course on Unit -I, Unit-II and
13, 14, 15, 16,
Unit-III
17, 18, 19, 21,
3. Write that questions with answers on assignment pages & submit.
22, 23, 24, 26,
27, 28, 29, 30,
31, 32, 33, 35,
36, 37, 39, 40,
42,43, 45, 47,
48, 49, 52, 54
56, 57, 58, 59,
1. Take GATE Question papers of year 2024, 2025, 2026.
61, 62, 65, 67,
2. Identify questions of SDB course on Unit -I, Unit-II and
68, 70, 71, 73,
Unit-III
78, 79, 80, 81,
3. Write that questions with answers on assignment pages & submit
82, 83, 85, 88,
90, 91, 92, 93,
97, 98, 101,
103, 106, 107,
108, 112, 113,
119, 122, 124,
128, 131, 133

You might also like