BIT202 Database Management System
Database Management System: most repeated questions
Questions that have come up in more than one paper, matched by what they ask rather than exact wording. Most repeated first.
- 3×Asked in 2080, 2079, 2078From the the relations given below, answer the following questions. EMPLOYEE (Ssn, Fname, Bdate, Address, Sex, Salary, Super ssn, Dno) DEPARTMENT (Dname, Dnumber, Mgr ssn, Mgr start date) PROJECT (Pname, Pnumber, Plocation, Dnum) DEPENDENT (Essn, Dependent…Answer coming10
See the wording in each paper
- From the the relations given below, answer the following questions. EMPLOYEE (Ssn, Fname, Bdate, Address, Sex, Salary, Super ssn, Dno) DEPARTMENT (Dname, Dnumber, Mgr ssn, Mgr start date) PROJECT…TU Board 2080
- Retrieve the Employee Name, Department Number and Department Name of "John Smith" using Relational Algebra. The relations are given below. a.EMPLOYEE ( Ssn, Fname, Lname, Bdate, Address, Sex,…TU Board 2079
- 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)…TU Board 2078
- 2×Asked in 2083, 2080Explain the Three Schema Architecture of a DBMS with diagram. Differentiate between logical data independence and physical data independence with one example each.Answer coming5
See the wording in each paper
- 2×Asked in 2079, 2078Explain the various Symbols used in E R Model?Answer coming10
See the wording in each paper
- 2×Asked in 2083, 2078Write short notes on: a. NoSQL Database b. Database UsersAnswer coming5
See the wording in each paper
- 2×Asked in 2083, 2080What is database recovery? Explain shadow paging technique with suitable diagram.Answer coming5
See the wording in each paper
- 2×Asked in 2080, 2079What is Normalization? Explain the 2NF with Examples.Answer coming5
See the wording in each paper
- What is Normalization? Explain the 2NF with Examples.TU Board 2080
- What is normalization? Explain 2NF with example.TU Board 2079