JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD MCA 2017 DATABASE MANAGEMENT SYSTEMS Previous Question Paper (August - 2017 - R15)
Note: This question paper contains two parts A and B. Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 10 marks and may have a, b, c as sub questions.
Part A
Define instance and schema.
Answer
A Database Schema is the logical design or blueprint of the database, defined during the design phase. It specifies the structure, data types, and constraints of the data, and it changes very infrequently. A Database Instance is the collection of information stored in the database at a particular moment in time. It represents the actual data content and changes frequently as operations like insertion, deletion, or updates are performed.
What is domain integrity?
Answer
Domain integrity is a set of rules that ensures that all data in a specific column falls within a defined domain of valid values. It restricts the type, format, and range of data that can be entered into a column. This is typically enforced through data types (e.g., Integer, Date), default values, and check constraints to ensure consistency and prevent invalid data entry.
Explain about inclusion dependency.
Answer
Sign in to view the complete answer paper.
What are recoverable schedules?
Answer
Sign in to view the complete answer paper.
Explain Clustered Indexes.
Answer
Sign in to view the complete answer paper.
Part B
Describe the Structure of DBMS with neat sketch.
Answer
Sign in to view the complete answer paper.
Discuss about the Conceptual database Design with the ER Model.
Answer
Sign in to view the complete answer paper.
Consider the following schema for a company database: Employee (Name, SSN, Address, Sex, Salary, Dno), Department (Dname, Dnumber, MGRSSN, MGRSTART Date), Dept-Locations (Dnumber, Dlocations), Project (Pname, Pnumber, Plocations, Dnum), Works-On (ESSN, PNo, Hours), Dependent (ESSN, Dependent-name, Sex, Bdate, Relationship). Give the queries in SQL:
Retrieve the names and address of employees who work for Department 10.
Answer
Sign in to view the complete answer paper.
List all the project names on which employee “Shyam” is working.
Answer
Sign in to view the complete answer paper.
Retrieve all employees in Dept. 5 whose salary is between 50,000 and 80,000.
Answer
Sign in to view the complete answer paper.
Retrieve the name of each employee who works on all the projects controlled by department number 2.
Answer
Sign in to view the complete answer paper.
Retrieve the names of employees who have no dependents.
Answer
Sign in to view the complete answer paper.
Discuss about Complex integrity constraints in SQL.
Answer
Sign in to view the complete answer paper.
Consider the relation R = {CourseNo, SecNo, OfferingDept, Credit-Hours, CourseLevel, InstructorSSN, Semester, Year, Days_Hours, RoomNo, NoOfStudents}. Suppose that the following functional dependencies hold on R: {CourseNo} → {OfferingDept, CreditHours, CourseLevel}; {CourseNo, SecNo, Semester, Year} → {Days_Hours, RoomNo, NoOfStudents, InstructorSSN}; {RoomNo, Days_Hours, Semester, Year} → {Instructorssn, CourseNo, SecNo}. Try to determine which sets of attributes form keys of R. How would you normalize this relation?
Answer
Sign in to view the complete answer paper.
Write loss-less Boyce Codd Normal Form decomposition algorithm and explain with example.
Answer
Sign in to view the complete answer paper.
Explain the concept of Deadlock avoidance and prevention in detail.
Answer
Sign in to view the complete answer paper.
Describe Validation-based protocols.
Answer
Sign in to view the complete answer paper.
Write about the various levels of RAID with neat diagrams.
Answer
Sign in to view the complete answer paper.
Explain and Compare Extendible Hashing with Linear Hashing.
Answer
Sign in to view the complete answer paper.