Database Management System – BSc.CSIT (TU) Question Paper 2071 | Fourth Semester

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

DBMS question paper 2071Fourth Semester | Second Year | Tribhuvan University
Computer Science and Information Technology (CSc. 253)
Database Management System, Year: 2071
Old Question Collection | Question Bank

Download Question Paper File
[File Type: PDF | File Size: 401 KB | Download]

OR you can read question paper online below;
Full Marks: 60 | Pass Marks: 24 | Time: 3 hours.

Attempt all the questions:

    1. Why do we need database management system? Discuss drawbacks of file system and advantages of database management system.
    2. What is database system architecture? Describe three levels and benefits of this architecture.
  1. A database is being constructed to keep track of the teams and games of a sports league. A team has number of players, not all of whom participate in each game. If is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Design an ER diagram for this application.
    1. Define integrity constraint? Discuss referential integrity in detail.
    2. What is functional dependency? How can we use functional dependency to normalize a relation in 3NF. Discuss with suitable example.
  2. Consider the following employee database, where primary keys are underlined.
    employee (employee-name, street, city)
    works (employee-name, company-name, salary)
    company (company-name, city)
    manages (employee-name, manager-name)

    Give an expression in SQL for each of the following queries.

    1. Find the names of all employees who work for Second Bank Corporation.
    2. Find the names, street and cities of residence of all employees who work for Second Bank Corporation.
    3. Find the names, street addresses, and cities of residence of all employees who work for Second Bank Corporation and earn less than $10,000.
    4. Find the names of all employees who work under the manager “Devi-Prasad”.
    5. Find the number of employees having salary greater than or equal to 20000
    1. Why do we need concurrency control mechanism? Discuss basic, conservative, and rigorous two phase locking algorithm.
    2. What is shadow paging? How can we use this technique to recover our database?
(Visited 724 times, 1 visits today)

Posted By : Digvijay | Comment RSS | Category : Fourth Semester, Old Question Collection
Tag :

Post a Comment

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

*
*

Wordpress DMCA
Community | Toolbar | Android App | Founder/Developer : Hari Prasad Chaudhary | CSIT Portal Manager : Digvijay Chaudhary