Published by: sadikshya
Published date: 25 Jun 2021
This is the question set Database Management System Spring 2015, which was taken by the Pokhara University.
Pokhara University – Database Management System Spring 2015
Level: Bachelor | Semester –Spring | Year: 2015 |
Program: BCIS | Full Marks: 100 | |
Course: Database Management System | Pass Marks: 45 | |
Time: 3hrs. |
Section “A”
Very Short Answer Questions
Attempt all the questions.
Section “B”
Descriptive Answer Questions
Attempt any six questions
Course(course_id, title, dept_name, credits)
Student(ID, name, dept_name,tot_cred)
Instructor ( ID, name, dept_name, salary)
Write SQL statements:
Case Analysis
Read the case situation given below and answer the questions that follow.
After major earthquake of April, 2015, an INGO is working on Emergency Response Program in Dolkha district. 15 staff( Manager, field supervisors, engineers etc) are responsible to run the project. The major work of this INGO are (a) Build 300 homes for those poor people lost their home in earthquake, (b) Reconstruct or repair 5 community schools, (c) support 150 families in their livelihood ( farming, animal husbandry etc) (d) education support to the children and (e)temporary support in food and clothing etc.
You have been hired to develop the database system for this INGO.
i) Draw an E-R diagram
ii) Enlist the max number of tables you require in the system.
iii) Show all possible and relevant attributes of at least for two tables.
iv) Offer some Views (logical) of the system.