Question 1
(a)
Define Superkey, Candidate Key and Primary Key.
3 Marks
(b)
Enlist advantages of Database Management Systems over traditional File System
4 Marks
(c)
Explain DBMS architecture with a neat sketch.
7 Marks
Gujarat Technological UniversityWinter 2023 Examination
GTU 3130703 Database Management Systems (DBMS) Winter 2023 Paper Solution & PDF
B.E. · Computer Engineering · Semester 3 · Subject Code: 3130703
Total Marks70 MarksExternal theory exam
Passing Marks23 Marks33% minimum cutoff
Exam Duration2.5 Hours10:30 AM – 1:00 PM
Paper Structure5 QuestionsWith internal OR choices
Question 2
(a)
Differentiate terms relation and relation schema with suitable example.
3 Marks
(b)
List various integrity constraints in reltional model. Explain referential integrity constraint with suitable example.
4 Marks
(c)
Briefly explain generalization and specialization in E-R diagram with suitable example.
7 Marks
OR OPTION
(c)
Differentiate Weak Entity and Strong Entity with suitable example.
Also draw a sample E-R diagram which depicts weak entity.
7 Marks
Question 3
(a)
What is functional dependency? Explain armstrong’s axioms.
3 Marks
(b)
Consider following relations and write queries in the form of relational algebra. Students(std_id, std_name, semester, dept_id) Departments(dept_id, dept_name, no_of_faculties)
1)List names of students studying in “Computer” department.
2)Display all information of the student whose name is “Pratik”
4 Marks
(c)
What is normalization? Explain 2NF, 3NF and BCNF with suitable examples.
7 Marks
OR OPTION
(a)
Let R = (A, B, C, D, E, F) be a relation schema with the followingdependencies-C → FE → AEC → DA → BWhat is the Candidate key of the relation R?3 Marks
(b)
Consider following relations and write queries in the form of relational algebra. Accounts(acc_no, acc_name, balance, bank_id) Bank(bank_id, bank_name, city)
1)List all Acount Numbers in “HDFC” bank.
2)List all bank names in “Ahmedabad” city.
4 Marks
(c)
Consider the relation Employees(empId, empName, carName,parkingSlot) with dependencies F ={empId→ carName, empId→empName, carName→ parkingSlot}.Does the above table appear in 3NF? If not, normalize it in 3NF.7 Marks
Question 4
(a)
List and explain ACID properties with respect to Database transaction.
3 Marks
(b)
Write a short note on Intrusion Detection in DBMS.
4 Marks
(c)
Discuss various steps of query processing with diagram.
7 Marks
OR OPTION
(a)
List and explain different types of locks in transactions.
3 Marks
(b)
Write a short note on SQL injection.
4 Marks
(c)
What do you mean by Serializable Schedule? Explain View Serializability with example.
7 Marks
Question 5
(a)
What is a trigger? List various types of triggers and explain any one with example.
3 Marks
(b)
Differentiate Sparse and Dense dense index in DBMS with example.
4 Marks
(c)
Consider the following tables and answer the queries in SQL. Books (isbn_no, title, publisher_id, year) Authors (author_id, author_name, country, city) Publishers (publisher_id, publisher_name, city) WrittenBy (isbn_no, author_id)
1)List all the books published after 1998.
2)Update the city of author to “Baroda” whose author id is 10.
3)List all the book titles written by author “korth”
4)Add column “price” in the table Books.
5)Display number of Publishers from the city “Ahmedabad”.
6)List all the books published by “McGaw Hill”
7)Display all publishers in the ascending order of their name.
7 Marks
OR OPTION
(a)
What is a cursor? Differentiate implicit and explicit cursor with example.
3 Marks
(b)
Differentiate open and closed hashing in DBMS.
4 Marks
(c)
Consider the following tables and answer the queries in SQL. Products(prod_id, prod_name, category, price) Customers(cust_id, cust_name, country, city) Orders(order_id, cust_id, prod_id, order_date, quantity)
1)List all the products having price less than 2000.
2)Update price of a product to 3000 whose product id is 43.
3)Display names of customer who have placed atleast one order.
4)Display customer id and total number of orders placed by them.
5)List all Customers in the descending order of their city.
6)Display names of customers who have ordered “Television”
(Product Name)
7)Remove column “category” from the Products table.
7 Marks
College Exam Groups
Studying for Database Management Systems?
Circulate this solved paper with KaTeX formulas and 1-click AI step solvers to your batchmates on WhatsApp or Telegram.
About this Examination Paper & Attribution
Official Gujarat Technological University (GTU) examination paper and step-by-step solutions for Database Management Systems (DBMS) (Winter 2023, B.E. · Computer Engineering, Sem 3). Features complete 70-mark regular & remedial examination pattern, official marking distribution across all 5 questions, and direct 1-click official PDF download.
Transcribed for student exam preparation from Gujarat Technological University official examination archives. Questions, syllabus guidelines, and curriculum marking schemes remain the intellectual property of Gujarat Technological University.