STUPIDSID
Solve any one question from Q1 and Q2
1 (a)
Discuss the entity integrity & referential integrity constraints.
4 M
1 (b)
For a Library Management System following information is maintained.Books (Accession_no, Title, Author, Price, Booktype, publisher)
Borrower(Membership_no, Name, Address, Category, max_no_of_books_issued, Accession_no)
Draw E-R Diagram for the above taking into consideration following constraints and by making use of atleast one Extended ER feature:
i) A book may have more than one author.
ii) There may be more than one copy of a book.
iii) Borrower can be staff or a student. Depending on this category max number of books that can be issued will vary. [i.e. student can ask for max 3 books whereas staff can ask for 10 books]
Draw E-R Diagram for the above taking into consideration following constraints and by making use of atleast one Extended ER feature:
i) A book may have more than one author.
ii) There may be more than one copy of a book.
iii) Borrower can be staff or a student. Depending on this category max number of books that can be issued will vary. [i.e. student can ask for max 3 books whereas staff can ask for 10 books]
6 M
2 (a)
What do you mean by correlated subquery? How it is different from
uncorrelated subquery
4 M
2 (b)
How to use oracle sequences? Explain with proper example.
6 M
Solve any one question from Q3 and Q4
3 (a)
For the Given transactions T1 & T2 check if the schedule is conflict
Serializable.
Justify your Answer.
Justify your Answer.
| T1 | T2 |
| Read (A) | |
| Write (A) | |
| Read (A) | |
| Write (B) | |
| Read (A) | |
| Write (A) | |
| Read (B) |
5 M
3 (b)
What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock.
5 M
4 (a)
Explain Join in SQL. Give proper example for Recursive Join.
6 M
4 (b)
How multiple granularity locking can improve two phase locking.
4 M
Solve any one question from Q5 and Q6
5 (a)
Enlist the technical advantages when going from one tier to two tier
architectures also specify the disadvantages with which 2 tier
architectures suffer from.
8 M
5 (b)
What are the key elements of parallel processing.
6 M
5 (c)
Enlist the Advantages & Disadvantages of Replication.
4 M
6 (a)
If you were designing a web based system to make airline reservations
& sell airline tickets, which DBMS architecture would you choose
from Centralized & client server Architecture? Why? Why would the
other architectures not be a good choice.
8 M
6 (b)
Draw & Explain architecture of parallel databases.
8 M
6 (c)
Enlist various architectural models for parallel databases.
2 M
Solve any one question from Q7 and Q8
7 (a)
How data validation is done in XML.
4 M
7 (b)
What are different data types of JSON? What is difference between
XML & JSON.
6 M
7 (c)
Discuss Hbase Data Model.
6 M
8 (a)
Give the DTD for an XML representation of the following nested relational schema.
Emp = (ename, ChildrenSet set of (Children), SkillSet Set of (Skills))
Children = (name, Birthday)
Birthday = (day, month, year)
Skills = (type, Examset setof (Exams))
Exam = (year, city)
Use the DTD and write the following queries in Xqueries format. Find the names of all employees who have a child who has a birthday in March.
Emp = (ename, ChildrenSet set of (Children), SkillSet Set of (Skills))
Children = (name, Birthday)
Birthday = (day, month, year)
Skills = (type, Examset setof (Exams))
Exam = (year, city)
Use the DTD and write the following queries in Xqueries format. Find the names of all employees who have a child who has a birthday in March.
7 M
8 (b)
What is HDFS? Explain in detail.
5 M
8 (c)
When to use Hbase & When not to use it.
4 M
Solve any one question from Q9 and Q10
9 (a)
What are the characteristics of NoSQL cloud databases?
8 M
9 (b)
Draw & explain the machine learning system model. What factors affect the performance of the system?
8 M
10 (a)
What are the design criteria for mobile databases? List existing mobile databases.
8 M
10 (b)
XML can be used to create new Internet language. Justify. Enlist features & advantages of XML.
8 M
More question papers from Database Management Systems