Twitter Facebook Delicious Digg Stumbleupon Favorites More

Monday, 26 December 2016

IPU BBA Semester 2 - Database Management System - End Term Examination Paper (2015)

END TERM EXAMINATION
Second Semester BBA
May - June 2015
BBA - 108

Subject: Database Management System


Time: 3 Hours                                                           M.M. : 75

Note: Attempt any five questions including Q No. 1 which is compulsory.


Q1: Explain briefly:
(a) Define three level of data abstraction  (☛See Answer)            (3)
(b) Define entity      (3)
(c) Define super key and primary key             (3)
(d) Define normalization              (3)
(e) What are the functions of Database administrator              (3)
(f) Define tuples and attribute             (3) ☛See Answer
(g) Define mail merge     (3)
(h) Define SQL (3)
(i) Define UNION and INTERSECTION (2)

Q2:
(a) Differentiate between loss less and lossy decomposition with example (4)
(b) Give five examples statements of each DDL and DML.                 (4.5)
(c)  Explain primary key, secondary key, candidate key and foreign key in brief. (4)




Q3: Draw ER diagram corresponding to Customers and Loan. Explain the various shapes and lines used in ER model. (12.5)

Q4: Define the following anomalies:                                (12.5)
(a) Update anomaly
(b) Insertion anomaly
(c) Deletion anomaly


Q5: (a) Explain the purpose of the database system.          (6)
(b) Explain different Database users. (6.5)


Q6: We have following relations:                  (12.5)
Suppliers (S#, sname, status, city)
Parts  (P#, pname, color, weight, city)
SP  (S#, P#, quantity)

Answer the following queries in SQL.

(a) Find the supplier for city = 'Delhi'.
(b) Find suppliers whose name start with 'AB'
(c) Find all suppliers whose status is 10, 20 or 30.
(d) Find total number of city of all suppliers.
(e) Find the name of suppliers who supplies quantity of the item P1 more than 50.


Q7: (a) List three reasons why null values might be introduced to the database.  (6)
(b) Mention the fundamentals operations of relational DBMS and their symbol.  (6.5)


Q8: Write short notes on any two:                     (6.25 x 2 = 12.5)
(a) Creating report using Report Wizard
(b) Accessing object understanding
(c) Codd rules

Share:

0 comments:

Post a Comment

NodeJS Tutorial

NodeJS Tutorial
Developer-Bytes

Maths Resources

Maths Resources
Maths Resources

Buy Books

Buy Books
Buy Books

Geography Quiz

Geography Quiz
Geography Quiz

History MCQs

History MCQs
History Quiz For Competitive exams

Categories

Popular Posts

GooglePlus

Recent Posts

Unordered List

Express Print Zone

Eduvictors Quizzes

Online Quizzes, Study notes for CBSE Class 6 - 12

Text Widget

Compete4Exams

Study notes for Competitive Exams

Developer Bytes

Developer Bytes
Developer Bytes
Powered by Blogger.

Blogger Tutorials

Blogger Templates

Sample Text

Copyright © IP University Musings BCA, MCA, BBA, MBA, BTech Question Papers and Study Notes | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com