BIT 3rd Semester
Database Management System Board Question Paper 2078

What is an E-R Diagram? Explain various symbols used in the E-R Diagram.

What is Transaction? State and explain the properties of Transaction.

From the relation given below, answer the following questions.
EMPLOYEE (Ssn, Fname, Minit, Name, Bdate, Address, Sex, Salary, Super_ssn, Dno)
DEPARTMENT (Dname, Dnumber, Mgr_ssn, Mgr_start_date)
PROJECT (Pname, Pnumber, Plocation, Dnum)
DEPENDENT (Essn, Dependent_name, Sex, Bdate, Relationship)
DEPT_LOCATIONS (Dnumber, Dlocation)
a) Retrieve all the attributes of employees who work for the 'Computer' department
department no 5 using SQL
b) For each Department, retrieve the department number, the number of employees in
department, and their average salary using SQL
c) For each project in which more than two employees work, retrieve the project number,
name, and the number of employees who work on that project using SQL
d) Select the EMPLOYEE tuples whose department is 10, or those whose salary is greater
than Rs 50,000 using Relational Algebra.
e) Retrieve the names of employees who have no dependents using Relational Algebra

What are different types of Database Users? Explain in Brief.

What is Primary key and Foreign Key? Why is this required in the DBMS?

What is Integrity constraint? What are the three main categories of Integrity constraints?

What is Schedule? Explain Serializability and Conflict Schedule.

What is starving in DBMS? Explain with example.

During ER-to-Relational Mapping, explain with example to map 1: N and N:M relationship into a relation?

What is NoSQL? What are the types of NoSQL? Explain.

Explain Data Models, Schemas, and Instances.