Master in Data Science (SMS, TU) Database Management Systems Question Paper 2080 Nepal

How problems related to data integrity and automicity occur in flatfile system?

Describe relationship type and relationship set in ER Model.

Define parallel database with its possible architectures.

What are the security threats to databases?

State the concept of information rule and non-subversion rule in Codd's Rule.

Create a relation containing trivial and non-trivial functional dependencies. When a relation is in 3NF? (3 + 3)

OR

What is the stored procedure? Create a stored procedure of your choice containing input and output parameters. (2 + 4)

Describe how incorrect summary and unrepeatable read problems occur in concurrent execution of transactions? Illustrate with examples. (6)

OR

Consider any two transactions T1, T2 performing read and write operations over data items X, Y, Z. Now show how Two-Phase Locking Protocol ensures serializability in concurrent execution of T1 and T2. (6)

How fixed length attributes and variable length attributes are represented in variable length record approach in file organization? What is a slotted page structure? (4 + 2)

What is embedded SQL? How is heuristic optimization of query trees done? Illustrate with an example. (2 + 4)

Consider the following relations defining exam management system. (6)

Answersheet(Copyno, Symbolno, Subject_name, Marks, Eid, Sid)
Examiner(Eid, Ename, Qualification)
Scrutinizer(Sid, Sname)
Scrutinydetail(Eid, Sid, Scrutiny_date)

Write the SQL and Relational Algebra statements for following;

a) Find the names of the subjects having marks greater than 40. b) Find the number of copies which are examined and scrutinized. c) Find the names of the examiners and scrutinizers with the scrutinizing date July 1. d) Find the names of examiners who have not examined any answer sheet.