NEWS

This blog consists of all information about bsc csit along with notes, old questions, routines and solutions.

B.Sc.CSIT III Semester-077 Exam Form Filling Notice !!!CLICK HERE

Pageviews

Thursday, September 19, 2019

DBMS model question solution [Bsc. CSIT database management system]

Database
management system
(DBMS)

Model Question Solution bsc csit


database management system dbms model question solution bsc csit
csit notes DBMS model question solution


Section A (Long questions)
Attempt any two questions. (2 × 10 = 20)
1. Consider the following database and write SQL as given:
Customer (Cno, Cname, Caddress, Ccontact)
Purchase (Cno,Pid)
Product (Pid, Pname, price, quantity) (5 × 2 = 10)
a. Find the names of all products having price 1000.
b. Find the name of those customers who purchased Dell Laptop.
c. Find the total number of products purchased by customer ‘Ram’
d. Increase price of all products by 5 %
e. Find total price of Apple Mobiles

2. What are the benefits of using normalization? Discuss 1NF, 2NF, and 3NF with suitable example. (2.5 + 7.5 = 10)

3. Define Relational Algebra (RA) and explain its six fundamental operations with suitable example. (2 + 8 = 10)

Section B (Short questions)
Attempt any eight questions. (8 × 5 = 40)

4. What database schema? What are functions of database administrator? (2 +3 = 5)

5. Construct an E-R diagram for online course registration where students register courses online.(5)

6. Discuss referential integrity with example. (5)

7. What is functional dependency? Why do we need inference rules? (2 + 3 = 5)

8. Why do we need concurrency control? Discuss two phase locking protocol. (2 + 3 = 5)

9. Why do we need database recovery? Discuss shadow paging technique for database recovery. (2 + 3 = 5)

10. Differentiate concept of Centralized and Client/Server Architectures for DBMSs with suitable example. (5)

11. Define Transaction and explain its desirable properties. (5)

12. Explain constraints and characteristics of Specialization and Generalization of data model. (5)





csit notes







0 comments:

Post a Comment

For any queries comment and ask in case of any doubts.