BIM (TU) Question Paper 2014 – Database Management System | 4th SEM

Download our Android App from Google Play Store and start reading Reference Notes Offline.

Database ServerTribhuvan University | Faculty of Management
BIM / Fourth Semester / ITC 218: Database Management System
Year: 2071 (2014)

Full Marks: 40 | Time: 2 hrs
Candidates are required to answer the questions in their own words as far as practicable.

Group “A”- 1. Brief Answer Questions: [10 X 1 = 10]

i. What do you mean by schema of a database?
ii. What is theta join?
iii. What do you mean by entity constraint?
iv. How parallel database differs from centralized database?
v. What do you mean by functional dependency?
vi. What is extraneous attribute?
vii. Write syntax to define trigger in SQL.
viii. Why is dynamic SQL used?
ix. What is NULL value on database?
x. What do you mean by closure of an attribute?

Group “B – Short Answer Questions: [5 X 3 = 15]

2. Explain 3NF and BCNF with examples.
3. What do you mean by distributed database system? Explain different reasons for building distributed database system.
4. Write SQL statement to create following tables:
Project (Oid, pname, budget)
Employee (Eid, name, address, Pid) Foreign Ke yPid References Project
5. What is transaction? Explain concurrent transactions with example.
6. Consider schema U={A,B,C,D,E,F} and the functional dependencies: AB → C, B → E, CF → D. Find closure of AB.

Group “C” – Long Answer Questions: [3 X 5 = 15]

7. Design a database using ER diagram for a mobile shop. This mobile shop maintains information about entities: customer, mobile, bills, and login.

  • Customer has attributes: cid, cname, address, phone, type, the cname is composed of first_name, middle_name, and last_name.
  • Mobile has attributes: model, name, brand, IMEINo. A customer may purchase one or more mobile and request only one bill for payment.
  • Login has attributes: userid and password
  • Bill has attributes: billno, cname, amount.

State any assumptions made in the design of the E-R diagram

8. Consider the following relational database.

Students (RollNumber, StudentName, Address, Year)
Teachers (TeacherID, TeacherName, CourseID, Salary, Department)
Courses (CourseID, RollNumber, CourseTitle, Semester)

Write relational algebra expression for the following requests

i) Find the name of the Students of 3rd year and studying Computer Network.
ii) Find the name of the teacher who teaches subject “Database System” to Rajan Sharma.
iii) Find the maximum salary of teacher in each department.
iv) Delete record of 4th year students of Account department.
v) Change salary of teacher Arju Shrestha from 21000 to 17000.

9. Consider the following relational database

Project (P_ID, P_Name, P_Location, Type)
Employee (EMP_id, Emp_Name, Address, Salary, POST, Data_Join)
Works (Dept_No, Emp_Id, Shift)

Write the SQL statement for the following queries
i) Insert new project {‘P1002’,’Edge of tommorow’,’Putalinagar’,’Private’}.
ii) List the name of the employees who work at “Save the Children” project.
iii) List the name of the employees whose salary is above the average salary.
iv) Remove record of all employees who work in morning shift at the project located in Nagbazar Kathmandu.
v) Change address and post of employee ‘Sing Shab’ to ‘Pokhara’ and ‘assistant lecturer’.

Posted By : MeroSpark | Comment RSS | Category : Bachelor Level, Tribhuvan University
Tag :

One Comment

  1. haftay
    Posted December 18, 2015 at 6:52 pm

    that is so nice questions if u can attach the answers of the above questions

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*